Please draw an EER diagram for the bank DB system. It requires to design & plan & document a bank system. Your EER model must include supertype and subtypes inheritance associations based on your initial ER model. Relationship constraints and completeness rules (discussed in the EER module) must be included. Requirements: Metadata: define what attributes (data) represent an object (i.e. account type) and data properties (data types, valid range of values, required vs. optional, etc.)
Please draw an EER diagram for the bank DB system.
It requires to design & plan & document a bank system.
Your EER model must include supertype and subtypes inheritance associations based on your initial ER model. Relationship constraints and completeness rules (discussed in the EER module) must be included.
Requirements:
-
Metadata: define what attributes (data) represent an object (i.e. account type) and data
properties (data types, valid range of values, required vs. optional, etc.)
-
Entities (objects): Account owner, dependent (joint family), Checking account, Savings account,
Money Market account, loan account, or other banking objects, online account, etc.
(suggestion: Define at least 10 entities)
-
Relationships: customer deposit or withdraw money with account, and more.
-
Identify the possible entity sets and their attributes, the relationships among the attributes.
Step by step
Solved in 4 steps with 3 images
