Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise# 1: [10 Marks] You are asked to create a database for the university administration. They describe that they want the following objects in their
Exercise# 1: [10 Marks] You are asked to create a database for the university administration. They describe that they want the following objects in their system: Course having title, number, and quarter Student having name and year of study Teaching Assistant having name and contract PhD Student having name and thesis topic Lecturer having name and position They also describe the relationships between these objects: Each course is taught by a lecturer and a teaching assistant. Students follow a number of courses. Each PhD student is associated with a lecturer who is his supervisor. Keep in mind that both PhD students and teaching assistants are students. (a) Create an E/R diagram capturing the objects and relationships described above. Describe all constraints. Please use the notation for E/R diagrams introduced in the course book. (b) Transfer the E/R diagram from (a) to the relational model. Describe the process you have made
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started