Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 1.6 subclass entities(2*0.2). 2. Identify the key identifier for every entity except for subclasses (6 entities*0.15) 0.9 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) 2 6. Provide relationship name for every relationship 0.5 7. For each superclass and subclasses, provide specialization and subclass constraints 0.4 (2*0.2). Total 7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

What is focal length? Explain with a diagram and give an example.

Answered: 1 week ago

Question

What is physics and how does it apply in daily life?

Answered: 1 week ago