Problem #1
1. Figure below shows an EER diagram for a simplified credit card environment. There are two
types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges
with merchants.
You are to complete the following:
1. Develop a relational schema, including the referential integrity arrows.
2. Show the functional dependencies by drawing the arrows as indicated in the chapter and as
we did in our in-class exercises.
1
Problem #2
2. Figure below includes an ER diagram describing a car racing league.
You are to complete the following:
1. Develop a relational schema, including the referential integrity arrows.
2. Show the functional dependencies by drawing the arrows as indicated in the chapter and as
we did in our in-class exercises.
General guidelines
1. Hard copy of the assignment to be submitted on the due date before beginning of the class.
Refer syllabus.
2. Please do NOT forget to write your name in the submission.
3. Please write legibly so that I can evaluate your answer.
4. You may discuss with your classmates; however the final submitted work has to be your
own.
2