Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different academic years.CourseInstances(courseCode, studyPeriod, academicYear, instanceId, examiner)courseCode→ courses.courseCodeexaminer → SeniorTeachers.teacherIdCoursePlanning(course, planningNumStudents, seniorHours, assistantHours)course → CourseInstances.instanceId# planningNumStudents is the number of students used for planning course resources# seniorHours is the estimated number of senior teachers’ hours that the course will need.# assistantHours is the estimated number of teaching assistant hours that the course will need. 2024-03-22 DAT475 / DIT930, 2023-20242AssignedHours(courseCode, studyPeriod, academicYear, teacherId, hours)(courseCode, studyPeriod, academicYear) →CourseInstances.(courseCode, studyPeriod, academicYear)ReportedHours(course, teacherId, hours)course → CourseInstances.instanceIdStudents(studentId, name, programme, year, graduated)(programme, year)→ ProgrammeCourses.(programme, academicYear)# year is the academic year in which the student joined the programme.# graduated is a Boolean attribute.Registrations(courseInstance, student, status, grade)course → CourseInstances.instanceIdstudent→ Students. studentId# status is one of: “not started”, “registered”, “completed”, “withdrawn”.# For students who have completed the course, the grade is one of “5”, “4” or “3”.In addition to the E-R diagram, your report should include comments:• Stating any additional assumptions that you have made. For example, keys for therelations are not stated in the task description, and some references (foreign keys)are missing.• Explaining design decisions that you have made. For example, if you considered morethan one way to model a particular part of the domain, explain your choice and whyyou preferred it to the alternative that you considered

Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different academic years.CourseInstances(courseCode, studyPeriod, academicYear, instanceId, examiner)courseCode→ courses.courseCodeexaminer → SeniorTeachers.teacherIdCoursePlanning(course, planningNumStudents, seniorHours, assistantHours)course → CourseInstances.instanceId# planningNumStudents is the number of students used for planning course resources# seniorHours is the estimated number of senior teachers’ hours that the course will need.# assistantHours is the estimated number of teaching assistant hours that the course will need. 2024-03-22 DAT475 / DIT930, 2023-20242AssignedHours(courseCode, studyPeriod, academicYear, teacherId, hours)(courseCode, studyPeriod, academicYear) →CourseInstances.(courseCode, studyPeriod, academicYear)ReportedHours(course, teacherId, hours)course → CourseInstances.instanceIdStudents(studentId, name, programme, year, graduated)(programme, year)→ ProgrammeCourses.(programme, academicYear)# year is the academic year in which the student joined the programme.# graduated is a Boolean attribute.Registrations(courseInstance, student, status, grade)course → CourseInstances.instanceIdstudent→ Students. studentId# status is one of: “not started”, “registered”, “completed”, “withdrawn”.# For students who have completed the course, the grade is one of “5”, “4” or “3”.In addition to the E-R diagram, your report should include comments:• Stating any additional assumptions that you have made. For example, keys for therelations are not stated in the task description, and some references (foreign keys)are missing.• Explaining design decisions that you have made. For example, if you considered morethan one way to model a particular part of the domain, explain your choice and whyyou preferred it to the alternative that you considered

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

See similar textbooks

Related questions

Question

2024-03-22 DAT475 / DIT930, 2023-20242
AssignedHours(courseCode, studyPeriod, academicYear, teacherId, hours)
(courseCode, studyPeriod, academicYear) →
CourseInstances.(courseCode, studyPeriod, academicYear)
ReportedHours(course, teacherId, hours)
course → CourseInstances.instanceId
Students(studentId, name, programme, year, graduated)
(programme, year)→ ProgrammeCourses.(programme, academicYear)
# year is the academic year in which the student joined the programme.
# graduated is a Boolean attribute.
Registrations(courseInstance, student, status, grade)
course → CourseInstances.instanceId
student→ Students. studentId
# status is one of: “not started”, “registered”, “completed”, “withdrawn”.
# For students who have completed the course, the grade is one of “5”, “4” or “3”.
In addition to the E-R diagram, your report should include comments:
• Stating any additional assumptions that you have made. For example, keys for the
relations are not stated in the task description, and some references (foreign keys)
are missing.
• Explaining design decisions that you have made. For example, if you considered more
than one way to model a particular part of the domain, explain your choice and why
you preferred it to the alternative that you considered

Expert Solution

Step by step

Solved in 2 steps with 1 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.