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

Each question is worth 10 points each. Convert the following textual description to an entity-relationship number. A customer buys a laptop at a store. A laptop can be bought by at most one customer but a customer

Each question is worth 10 points each. Convert the following textual description to an entity-relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of attributes. If you are identifying a strong entity - make sure you identify a primary key for it. You are not required to use superclass subclass hierarchy for any of these problems, but may choose to do so 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 unique international book 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. A book is written by one to many authors and an author writes 1 to many books. 3. A book has a title, an ISBN number (a unique international book 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 1 to many books. A book can be released by one to many publishers. When a book is released by a publisher, there is a publication date. 4. A laptop has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each laptop 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 laptop 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 laptop has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each laptop 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 laptop 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. An electronic store stocks I to many laptops but a laptop can only be found at 1 and only 1 store. 6. A laptop has a unique serial number and is associated with a specific manufacturer and a model for that manufacturer. Each laptop 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 laptop 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. An electronic store stocks 1 to many laptops but a laptop 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 laptop at a store. A laptop can be bought by at most one customer but a customer may buy 0 to many laptops.

Step by Step Solution

3.41 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Convert the following textual description to an entityrelationship diagram in UML notation Please spend time differentiating between entities attributes relationships and values of attributes If you a... View full answer

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 Programming Questions!