Entities Description
•
•
Client: Contains personal information about each client, including Id (of the
client), FirstName, LastName.
Account Type: Stores information about each type of account, including Id (of
the type) and Name.
Account: Contains information about each account, including account Id and
account balance.
2. (2 points) From the complete ERD in question 1, write SQL statements to create
the table(s) corresponding to the entity(ies) added to the diagram. Insert 5 appropriate
data rows into each newly created table.
Notice: The balance of an account has up to 15 digits including 2 digits after the decimal
point and has a default value of 0. Suppose that the currency is USD.
3. (2 points) Write a stored procedure to withdraw money from an account. In order
for a withdrawal to be successful, the amount to be withdrawn must be a positive
number, the account ID must be valid and the balance of the account must not be lower
than the amount to be withdrawn. In case any criterion above is violated, rollback and/or
raise an error.
Zoom
- FUO
4. (2 points) Create a table - NotificationEmails (Id, Recipient, Subject, Content). Add
+ 100%
Close
