Requirements:
PRACTICAL EXAMINATION
Subject code: DBI202
Duration: 85 minutes
+ Download the file PE_DBI202_.sql and execute it to create the database and the
tables that are already in the file.
+ Students must complete their exams in 2 files: file named PE_DBI202_.sql for
SQL code and word file PE_DBI202.docx containing the ERD for question 1.
1. (2 points) In the picture are two entities extracted from a simplified ERD of a bank.
Complete the ERD according to the given details:
-
Each client can have many accounts.
Each account is of one account type.
Each account has an ID and a balance, which is the amount of money left in the
account.
(Add to the existing diagram in the exam).
Use the diagram below to complete question 1 (you can draw it in MS Word).
FirstName
ld
LastName
Zoom
- FUO
+100%
Client
Name
ld
AccountType
Close
