Question: A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department, but an instructor can work
A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department, but an instructor can work only in one department. For each department, there is a head, and an instructor can be head of only one department. Each instructor can take any number of courses, and a course can be taken by only one instructor. A student can enroll for any number of courses and each course can have any number of students.
1..create ERD
2.A Work Breakdown Structure (WBS) for the database based on the SDLC phases that details the tasks needed for the database project.
3.A description of three actors (minimum) that will use the system, more can be introduced as needed.
Step by Step Solution
3.41 Rating (151 Votes )
There are 3 Steps involved in it
1 ERD for College Database Entities Department DeptID DeptName HeadID FK Instructor InstructorID Name DeptID FK Title Course CourseID CourseName Instr... View full answer
Get step-by-step solutions from verified subject matter experts
