Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started