1. Design an EER diagram for a database of a Bank Management System based on the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Design an EER diagram for a database of a Bank Management System based on the below specifications. (7 Marks) EER diagram Requirements 1. Include at least 5 entities (5*0.2), one of them is a superclass entity(0.2)with two subclass entities (2*0.2). 2. Identify the key identifier for every entity except for subclasses (6 entities *0.15) 3. Identify at least 8 simple attributes (10*0.1) 1.0 4. In any entity, identify one composite attribute (0.3), one multivalued attribute (0.15) 0.6 and one derived attribute (0.15) 5. Identify relationships and cardinalities between entities (0.1 each) 1.6 0.9 2 0.5 6. Provide relationship name for every relationship 7. For each superclass and subclasses, provide specialization and subclass constraints 0.4 (2*0.2). Total 7 1. Design an EER diagram for a database of a Bank Management System based on the below specifications. (7 Marks) EER diagram Requirements 1. Include at least 5 entities (5*0.2), one of them is a superclass entity(0.2)with two subclass entities (2*0.2). 2. Identify the key identifier for every entity except for subclasses (6 entities *0.15) 3. Identify at least 8 simple attributes (10*0.1) 1.0 4. In any entity, identify one composite attribute (0.3), one multivalued attribute (0.15) 0.6 and one derived attribute (0.15) 5. Identify relationships and cardinalities between entities (0.1 each) 1.6 0.9 2 0.5 6. Provide relationship name for every relationship 7. For each superclass and subclasses, provide specialization and subclass constraints 0.4 (2*0.2). Total 7
Expert Answer:
Answer rating: 100% (QA)
To satisfy the given requirements five entities are identified as below 1 Branch 2 Customer 3 Accoun... 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
-
Find the remainder of the division problem shown below. (x+x-3x-3)+(x+2)
-
What is the principal purpose of encoding software? What is the function of encoding?
-
The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and...
-
The cost formula for the maintenance department of Rainbow, Ltd., is $19,400 per month plus $7,70 per machine hour used by the production department. Required: a. Calculate the maintenance cost that...
-
What voltage is needed to produce electron wavelengths of 0.26 nm? (Assume that the electrons are nonrelativistic.)
-
Show that for a diatomic molecule [Lz, O] 0.
-
When testing several hypotheses, it is reasonable to reject every hypothesis for which P < 0.05. In Exercises 5 and 6, determine whether the statement is true or false. If the statement is false,...
-
Valuing Preferred Stock Ayden, Inc., has an issue of preferred stock outstanding that pays a $6.50 dividend every year in perpetuity If this issue currently sells for SI 13 per share, what is the...
-
An analyst has obtained the following information about ABC, Inc. Sales: $54,600 COGS = $19,303 Accounts Receivables = $29,458 Accounts Payable = $15,153 Inventory = $49,204 Assume 365 days. What is...
-
The Alfredo Fragrance Company produces only one product, a perfume called Hint of Elegance. Hint of Elegance consists of two secret ingredients blended into an exclusive fragrance, which is marketed...
-
Determine the coefficients p and q and exponents m and n when the following expression is simplified: (2xy) 3 pym 10x6y3 qxn
-
Jasmine Lee owns a catering company that serves food and beverages at exclusive parties and busi- ness functions. Lee's business is seasonal, with a heavy schedule during the summer months and...
-
Prove MM1: Both Umbrella Inc. and Prixxa Inc. produce $300,000 of cash flow each year. Umbrella has no debt outstanding, and its cost of equity capital is 14 percent. But Prixxa has 1,000,000 depts...
-
How has globalization transformed traditional social structures, and what are the implications for cultural homogenization, transnational migration, and the emergence of global inequalities ?
-
Felix, an entrepreneur, sets up several sporting goods stores in his town. Several years after founding, he begins to realize that major chains are entering the market, which is leading to market...
-
Fill in the missing information marked with a in the credit card statement below (Payments/Credits, Unpaid Balance, Finance Charge, New Charges, New Balance). During this month, you made a payment of...
-
On 1 July 2019 Mary acquired a leather sofa for $28632. Mary borrowed $29,000 of the money from XYZ Bank. The loan was a fixed interest loan on which Mary paid interest of $5,000. Mary sold it in...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
When must a many-to-many relationship be modeled as an associative entity?
-
Choose an organization that you have contact with, perhaps your employer or university. Determine how information systems projects are identified. Are projects identified adequately? Are they...
-
Are you using any services offered in the cloud? If so, what service model is offered by your provider? If not, what are your primary reasons for not using services offered in the cloud?
-
Describe one occasion where you have been influenced to buy a product or engage in an activity as a direct result of an item of corporate communication, eg social media update; and explain what that...
-
What are the elements of a master budget?
-
Discuss the potential conflict between using a budget as a motivational device and as a means of control.
Study smarter with the SolutionInn App