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. A department 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 with thecourse number, but the course number is unique for each department. Students have given names,surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a coursethe 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 they are alsoallowed to drop a semester in that university by taking no courses. Construct an ER diagram usingthe requirements given here. (10) 2. 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. A department 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 with thecourse number, but the course number is unique for each department. Students have given names,surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a coursethe 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 they are alsoallowed to drop a semester in that university by taking no courses. Construct an ER diagram usingthe requirements given here. (10)

Answered: Image /qna-images/answer/4edccc35-1a60-4ef5-a28b-7814f2e684f6.jpg

Answered: You are asked to design a database for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

You are asked to design a database for an University. This particular university has multiple
departments. Each department in that university offers one or more courses to the students. All the
students are part of a certain department and they take courses in that department. A department has
a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a
credit point value, and the year it commenced. A course cannot be identified uniquely with the
course number, but the course number is unique for each department. Students have given names,
surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course
the year and the semester he or she took that particular course is recorded. When he finishes the
course , the grade and total marks are recorded. A student can take multiple courses but they are also
allowed to drop a semester in that university by taking no courses. Construct an ER diagram using
the requirements given here. (10)

2. You are asked to design a database for an University. This particular university has multiple
departments. Each department in that university offers one or more courses to the students. All the
students are part of a certain department and they take courses in that department. A department has
a name, unique number and chairman. The courses have a name, a course number such as '311', a
credit point value, and the year it commenced. A course cannot be identified uniquely with the
course number, but the course number is unique for each department. Students have given names,
surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course
the year and the semester he or she took that particular course is recorded. When he finishes the
course ,
the grade and total marks are recorded. A student can take multiple courses but they are also
allowed to drop a semester in that university by taking no courses. Construct an ER diagram using
the requirements given here. (10)

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions