Consider the following environment of a university. There are academic departments. Each department has a chairperson. Each
Question:
Consider the following environment of a university. There are academic departments. Each department has a chairperson. Each department offers a set of courses. Some courses are currently offered. Some courses need prerequisites. An offering of a course is called a class or class section. Some courses have multiple class sections. A class is taught by a professor. It meets at a particular location. Some classes are scheduled in lab rooms that have a certain number of stations/seats. University staff are in charge of lab management. Not all departments offer the summer courses. Each professor is assigned to a single department and has a rank. Each student has an academic status (undergraduate, graduate, non-degree). The university requires GMAT or GRE scores for graduate students. Each student is currently enrolled in a number of classes. Some undergraduate students are in double majors. Some students are performing better because they are hard working. Students' financial aid depends on their academic performance. Graduate students can have individual faculty as their advisor in writing their thesis. Students may join some clubs registered in university. Some clubs are free, but some require fees. The university also needs to keep track of club memberships.
3a. Draw an ER model showing the entities, attributes and the relationships in the environment. Indicate the identifiers (keys) of all entities (including weak entities). Indicate some attributes for all entities. For each relationship, indicate the cardinalities (maximum and minimum)
3b. Which part of the above description you cannot represent in your E/R model?
3c. Convert the ER model into a set of tables. Clearly indicate the primary key and foreign key (if there is any) in each table.