Each question is worth 10 points each. Convert the following textual description to an entity-relationship diagram...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Each question is worth 10 points each. Convert the following textual description to an entity-relationship](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/65180c67c7133_1696074852897.jpg)
![number. A customer buys a laptop at a store. A laptop can be bought by at most one customer but a customer](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/65180c87c1e60_1696074887334.jpg)
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these programming questions
-
There are lots of different things you can own that you hope go up in value and then sell. I bet you know one of the most prominent equity investment products already. How can you own a corporation?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
1. Was the contract between Joel King and Barber bilateral or unilateral? 2. What was bargained for and given in exchange by each party? Mark P. Painter, Judge This case involves neighbors and the...
-
Explain why resources are used efficiently in a competitive market.
-
In Exercises 102105, determine whether each statement is true or false. If the statement is false, make the necessary change(s) to produce a true statement. x - 25 x-5 = x - 5
-
Para la oferta de producto de su plan de marketing : 1 Identifique: a) su etapa en el ciclo de vida del producto y b) las acciones importantes de la mezcla de marketing que pueden ser adecuadas, segn...
-
Water flowing at 2 kg/s through a 40-mm-diameter tube is to be heated from 25 to 75C by maintaining the tube surface temperature at 100C. (a) What is the required tube length for these conditions?...
-
indefinitely. Stockholders require a return of 1 2 % on WME's stock. The most recent annual dividend ( D 0 ) , which was paid yesterday, was $ 1 . 5 0 per share. a . Calculate WME's expected...
-
Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to...
-
h Hulu PepsiCo Beverage... My Cart | Bulova N Netflix G Google Account B 21 Calculator Log in to Canvas Which of the following is a cost pool used with the activity-based costing method? Oa. direct...
-
How do you demonstrate resilience as a leader during times of crisis or uncertainty, and what steps do you take to bolster your team's resilience ?
-
What would you do if it becomes clear to you that the potential successor you were grooming is not going to make the grade as a supervisor? What are your next steps? Do you think this grooming is...
-
How do services and products differ? What kind of decisions do companies make regarding products and services? Why are brands important to marketers? How do marketing strategies change during the...
-
What leadership principles do you feel you possess that are important for APRNs to exhibit? What principles do you need to explore to be more confident in performing? Which leadership style do you...
-
Question 1- Where do you go in the Courier to find out your amount of leftover inventory for a specific product last round? Based on the production tab of the worksheet I gave you; how do you use...
-
( Their are 7 entries : ) ) Marian Manufacturing ( 2 M ) applies manufacturing overhead to jobs based on direct labor costs. For Year 2 , 2 M estimates its manufacturing overhead to be $ 4 2 5 , 6 2...
-
Carlton Stokes owns and operates a car-detailing business named SuperShine & Detailing. For $150, Carltons business will hand wash and wax customers cars, vacuum the interior, and thoroughly clean...
-
Suppose you created a file for each relation in your answer to Problem and Exercise 9-45. If the following queries represented the complete set of accesses to this database, suggest and justify what...
-
Describe three commonly used methods for performing economic costbenefit analysis.
-
Lets say your professor has asked you to help him or her train a new secretary on how to prepare class notes for electronic distribution to class members. Your professor uses word-processing software...
-
25. Which of the following is true about the statement of cash flows for the proprietary funds of a state or local government? a. The indirect method of reporting cash flows from operating activities...
-
18. Which of the following is not necessary for a special purpose local government to be viewed as a primary government for reporting purposes? a. It must have a separately elected governing body. b....
-
17. Which of the following is true about the managements discussion and analysis (MD&A)? a. It is an optional addition to the comprehensive annual financial report, but the GASB encour ages its...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App