Question: iach question is worth 10 points each. Convert the following textual description to an entity-relationship iagram in UML notation. Please spend time differentiating between entities,

 iach question is worth 10 points each. Convert the following textual

iach question is worth 10 points each. Convert the following textual description to an entity-relationship iagram in UML notation. Please spend time differentiating between entities, attributes, relationships and alues of attributes. If you are identifying a strong entity - make sure you identify a primary key for it. Tou are not required to use superclass/subclass hierarchy for any of these problems, but may choose to do 0 if you wish. 1. A book has a title, an ISBN number (a unique international book number), a publisher, a language it was written in, the total number of pages and an author's name. 2. A book has a title, an ISBN number, a publisher, a language it was written in, and the total number of pages. An author has a name and a place of origin. An author writes a book. A book is written by one author and an author writes 1 to many books. 3. A book has a title, an ISBN number, a language it was written in, and the total number of pages. An author has a name and a place of origin. A publisher has a name, a city and a country. A book is written by 1 to many authors. A publisher releases a book. A publisher can release 1 to many books but a book is released by one publisher. 4. A television set has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each television set is associated with exactly 1 manufacturer and 1 model for that manufacturer. A manufacturer has a unique name. A manufacturer can produce 1 to many television models. A model name is unique for a specific manufacturer but is not unique across all manufacturers. A model name is associated with at least 1 manufacturer. 5. A television set has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each television set is associated with exactly 1 manufacturer and 1 model for that manufacturer. A manufacturer has a unique name. A manufacturer can produce 1 to many television models. A model does not have a unique name but is associated with at least 1 manufacturer. An electronic store has a unique name and a unique address that consists of a street number, street address, town, state and zip code. A store stocks 1 to many television sets but a television set can only be found at 1 and only 1 store. 6. A television set has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each television set is associated with exactly 1 manufacturer and 1 model for that manufacturer. A manufacturer has a unique name. A manufacturer can produce 1 to many television models. A model does not have a unique name but is associated with at least 1 manufacturer. An electronic store has a unique name and a unique address that consists of a street number, street address, town, state and zip code. A store stocks 1 to many television sets but a television set can only be found at 1 and only 1 store. A customer consists of a name, and a unique credit card number. A customer buys a television set at a store. A television can be bought by at most one customer but a customer may buy 0 to many television sets

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!