Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Convert the following textual description to an entity - relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of
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 are identifying a strong entity make sure you identify a primary key for it You are not required to use superclasssubclass hierarchy for any of these problems, but may choose to do so if you wish. Remember, weak entities do not have a primary key. You are not required to use superclasssubclass hierarchy for any of these problems, but may choose to do so if you wish.
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 manufacturer and model for that manufacturer. A manufacturer has a unique name. A manufacturer can produce to many laptop models. A model does not have a unique name but is associated with at least 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 to many laptops but a laptop can only be found at and only 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 to many laptops.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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