5) You have to draw an ER diagram for a University
(16 points) (you need the concept of mandatory/nonmandatory/disjoint/overlapping concept for this) Requirements: A person could be an Employee or Alumnus or Student (e.g. could be both like an alumnus and employee) and has certain info like name, address, date of birth, and unique SSN. An alumnus may have multiple degrees from the university, and you have to store that along with the year and major. An employee could perform only one role of staff, faculty, and student assistant with salary information. If staff, there needs to be a position attribute, if faculty, there needs to be a rank attribute. If a student assistant, he could play one role of RA and TA, not both. If RA, he is doing a project, if TA, he is assisting a course. A student can be a student assistant also with major department information. He could be either a graduate (there will be a supervisor name attribute) or an undergraduate student (program attribute) and couldn't be both.
6) For a football team management, you need to draw an ER diagram
(16 points) Requirements: A number of players can form a team. Two teams can play multiple games in many stadiums. A team will have a name, number of winning games, unique team id, and a record of Players. Players will have names, city, salary, multiple contracts, phone number, unique player id, and derived attributes like average score. Players will have dependents (it's an entity, not an attribute, you need to consider the type of this entity). The dependents will have attributes like birthdate. Players can play many games and many games can be performed in a single stadium. The stadium will have a name, city, and unique stadium id. The team will have a name, city, unique team id.
