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
202 John Smith 1096 2039 8053 100 N . Kent Ave . St . James WA 34 Jamaica