Hello. I am doing some Database Management work and need some help with some questions. Thank you in advance!

1.)For the following ER diagram. The business rules that are interpreted are

a.)Each person can be either a staff or student(or something else), but not both

b.)Each person must be either a staff or a student, but not both

c.)Each person can be either a staff or a student(or something else) or both

d.)Each person must be either a staff or a student, or both

---------------------------------------------------------------------------------------------------------------------------

2.)For the following ER diagram. The business rules that are interpreted are

a.)A person can be an Academic staff, a General staff, an Undergraduate Student or a Postgraduate Student. This person cannot be any combination of the above and cannot be anything else

b.)A person can be Academic staff, a General staff, an Undergraduate Student or a Postgraduate student. This person can be any combination of the above and cannot be anything else.

c.)A person can be Academic staff, a General Staff, an Undergraduate Student or a Postgraduate Student. This person cannot be any combination of the above and can also be anything else.

d.)A person can be an Academic staff, a General staff, an Undergraduate Student or a Postgraduate Student. This person can be any combination of the above and can be anything else.

---------------------------------------------------------------------------------------------------------------------------

3.) Create an ER diagram for the following

a.)A department may employ any number of persons. A person must be employed by, at most, one department.

b.)A manager manages, at most, one department. A department is managed by exactly one manager.

c.)A team consists of many players (and at least one). A player plays for exactly one team.

d.)A team consists of 5 to 10 players. A player plays for exactly one team.

e.)A lecturer teaches, at most, one course. A course is taught by exactly one lecturer.

f.)A Book in the library may have multiple copies.

g.)A vehicle, which is a land-vehicle or water-vehicle, can be an ocean-vessel, a river-raft, a rail-vehicle or a road-vehicle. If it is a rail-vehicle it cannot be a road-vehicle at the same time. Other options may also exist.

------------------------------------------------------------------------------------------------------------------

4.) Based on the relational schema that you created for question 8 and only for table BOOK(f). Complete (as many rows as needed) the following table for the Physical schema design.

Person Student Staff