Reference no: EM133196292
1. Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints.
a. A Bank has a name, address, and a unique 5-digit code.
b. Each bank has several branches. Each branch has a branch number that is unique among the branches of the bank it belongs to (but may be the same as a branch for a different bank). Each branch has a location.
c. Each branch maintains its own set of accounts. An account has a unique account number, a type (such as checking or savings) and a current balance. An account may be shared between more than one customers.
d. Each customer may have several accounts. A customer has a name, a social security number, an address, and a list of phone numbers where they may be reached.
2. Draw an ER diagram to keep track data about college students, their academic advisors, the clubs they belong to. Use cardinality ratio and participation constraints to indicate the relationship constraints.
a. Each student has a name, unique id, and a major, phone number, and address. Assume each student is assigned to one faculty as academic advisor and one advisor advises many students.
b. Each faculty has a unique number, name, and office location. Student can belong to any number of clubs.
c. A club has a unique name, budget, meeting day and meeting time. The club must have some student members in order to exist, and clubs can sponsor any number of activities.
d. Each activity has a unique id, type, date, time, and location. Each activity is sponsored by exactly one club. Each club is moderated by one faculty. A faculty may moderate more than one clubs.