each customer for all account types. A customer’s contact address includes street, city and country as well as two phone numbers (cellphone, office line). One customer can own at least one account and every account is identified by its numbers, type and balance. . A customer may own a savings, cheque or loan account. Questions
Read the scenario and answer the questions that follow
Scenario
You have been tasked to design a
identification number is required for each customer for all account types. A customer’s contact address includes street, city and country as well as two phone numbers (cellphone, office line). One customer can own at least one account and every account is identified by its numbers, type and balance. . A customer may own a savings, cheque or loan account.
Questions
i. Using an appropriate tool, draw the conceptual diagram for the proposed database.
ii. Develop the logical model.
iii. Define the physical schema for the proposed database.
iv. Write SQL statements to implement the database.
v. Populate each of the identified tables with 2 records.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
