2. Draw an ER diagram to keep track data about college students, their academic advisors, the clubs they belong to. Use

[answerhappygod]

2 Draw An Er Diagram To Keep Track Data About College Students Their Academic Advisors The Clubs They Belong To Use 1 (280.07 KiB) Viewed 32 times

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. 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.