organizer is a subclass

complete both excerise 7 and 8 please

just draw it by hand

Exercise 7 Consider a University Database System, which stores information about the Student Clubs identified by ClubName, President and NumofMembers. Sports team identified by the TeamName, Coach and the SportsName. Department identified by the DeptName and OfficeNum. An Organizer identified by OrganizerID may be a team or a department, or a club. Each Organizer entity instance is a member of one of these superclasses, so Sponsor is a subclass of the union of Team, Dept, Club. Not every Club, Team, or Dept must be an Organizer. An Organizer holds one or many CampusWide Events. However, an event must be organized by one organizer. CampusWide Events are identified by EventName, Date and time. CampusWideEvents can be of two types: Concerts and Fair. A Concert has a performer, and a Fair can also be described by Theme and Charity. Draw an EER Diagram for the above scenario, showing cardinality and participation for all relationships. Exercise 8 Extend the University Database System described in Exercise 7 by adding the following superclasses and subclasses entities and the relationships. The University System stores information about the Students, identified by Id, FirstName, LastName, Major and CrHrsCompleted. It also stores information about Faculty identified by Id, FirstName, LastName, and Rank. A Faculty works in one Department. A Department has many Faculty. A Faculty may chair one Department. A Department must have only one Chairperson. A Faculty may moderate many Clubs. A Club is moderated by One Faculty- Students can be categorized as Undergraduate and Graduate Students Graduate Students is also described by Specialization. He/She publish one or more ResearchArticle. A ResearchArticle is identified as ArtNo, Title, Journal, TotalPages. A research Article is published by one or many Students. Undergraduate Students has an attribute Academiclevel. A Ungraduate Student entity can be categorized based on the CrHrsCompleted into four subclasses Freshman, Sophomore, Junior, Senior. A Student entity can also be categorized Hosteler or a DayScholar sub classes. A Hosteler has roomNo and BuildingNo. A DayScholar has Address. A student may play a maximum of 3 Teams. A Student belongs to zero or many Club. A club has many students. A Student majors in one Department. A Department can have many students