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:
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...
-
(a) Is the number of molecules in one mole of N2 greater than, less than, or equal to the number of molecules in one mole of O2? (b) Is the mass of one mole of N2 greater than, less than, or equal to...
-
Distribution Requirements Planning (DRP) is focused in the Front End and Back End sections of Manufacturing Planning & Control (MPC) and has no involvement in the Engine section of the MPC, because...
-
On January 1, 2000, GAZ Ltd. purchased a producing oil well, with an estimated life of 15 years, and started operating it immediately. The management ofGAZ Ltd. calculated the present value of future...
-
Comprehensive Three-Part Revenue Recognition Van Hatten Industries has three operating divisionsDepp Construction Division, Dement Publishing Division, and Ankiel Securities Division. Each division...
-
May 2015 - Management Case Study Variant 1 This excerpt is based on the Management Level case study related to Flote, one of the world's largest transport companies. The primary business is in...
-
Ayayai Hotels Ltd. (AHL) is a small boutique hotel that provides 44 suites that can be rented by the day, week, or month. Food service is available through room service as well. In addition, there...
-
Z Space, Incorporated, is a new company and currently has negative earnings. The company's sales are $2.9 million and there are 148,000 shares outstanding. a. If the benchmark price-sales ratio is...
-
A and B are partners sharing profit and losses as 2:1. On 1st April 1997 they admit C as a partner 1/5th share who pays Rs.4,500 as goodwill privately. On 1st April 1998 they take D as a partner for...
-
Machinery purchased for $47,800 by Flounder Corp. on January 1, 2018, was originally estimated to have an 8-year useful life with a residual value of $3,000. Depreciation has been entered for five...
-
Which of the following is associated with a corporate level strategy? a.To expand, grow, and prosper at a global level b.It is directed at operational effectiveness c.Develop specific business units...
-
Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period. The company's discount rate is 15%. After careful study, Oakmont estimated the following costs and...
-
On December 3 1 , 2 0 2 4 , the Stride well Wholesale Shoe Company sold land in exchange for a nine - month, 1 2 % note. The note requires the payment of $ 2 0 0 , 0 0 0 plus interest on September 3...
-
Within a business unit, 99% of the material costs are incurred by only 2% of the contracts. In addition, for this business unit, direct labor is not their only significant cost. According to Cost...
-
H Corporation has a bond outstanding. It has a coupon rate of 8 percent and a $1000 par value. The bond has 6 years left to maturity but could be called after three years for $1000 plus a call...
-
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...
-
The following balance sheets were drawn up immediately after Pai Ltd had acquired control of Filho Ltd. You are to draw up a consolidated balance sheet. Pai Balance Sheet Investment in Filh Ltd:...
-
Southern California Publishing Company is trying to decide whether or not to revise its popular textbook, Financial Psychoanalysis Made Simple. They have estimated that the revision will cost...
-
Prepare a consolidated balance sheet from the following balance sheets of Pop Ltd and Son Ltd which were drawn up immediately after Pop Ltd had acquired the share capital of Son Ltd. Pop Balance...
Study smarter with the SolutionInn App