CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 41

PubCode. Pubcode also persists as a dependent attribute and Foreign
Key in Books. All tables are now in 3NF, and have been given
meaningful names reflecting the entities they represent. LINEITEMS
represents the collection of line items for all invoices. Invoices
represents the collection of Invoices for all customer orders. Books
makes up the list of all books available for sale (whether they have
ever been ordered or not). Each book has a publisher, and the
publisher code and Name reside in the Publishers table.
4. Draw the ERD for exercise 3, using Crow‘s Foot notation.
End of Sample Exercise.
Student Exercise
The student exercise for this lab is similar to the sample exercise
presented above.
Consider the following spreadsheet containing information about
customers, their shipping and billing addresses, and the countries
corresponding to each of those addresses. A customer may be
associated with zero to many addresses. A customer may have 0 or 1
default billing address. A customer may have 0 or 1 default shipping
address. Each address may be associated with 0 or 1 countries, while
each country may be associated with 0 to many addresses.
cust_idfnamelnamedef_bill_addr_iddef_ship_addr_idaddr_idstreet_ad
dr city state zip country_codecountry_name
202 John Smith 1096 2039 1096 123 Happy Ave. Orlando FL 32801
76 United States
202 John Smith 1096 2039 2039 2024 Shorline Dr. Seattle WA 98101
76 United States