Question

You are asked to design a database for an University. This particular university has multipledepartments. Each department in that university offers one or more courses to the students. All thestudents are part of a certain department and they take courses in that department. Adepartment hasa name, unique number and chairman. The courses have a name, a course number such as ‘311’ , acredit point value, and the year it commenced. A course cannot be identified uniquely withthecourse number, but the course number is unique for each department. Students have givennames, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes acoursethe year and the semester he or she took that particular course is recorded. When he finishes thecourse , the grade and total marks are recorded. A student can take multiple courses but theyarealsoallowed to drop a semester in that university by taking no courses. Construct an ERdiagramusingthe requirements given here.​

Answer 1

Explanation:

Scribd will begin operating the SlideShare business on December 1, 2020

As of this date, Scribd will manage your SlideShare account and any content you may have on SlideShare, and Scribd's General Terms of Use and Privacy Policy will apply. If you wish to opt out, please close your SlideShare account. Learn more