In: Computer Science
Creating a Database Design
Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document.
Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:
Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.
The following relationship diagram may be created based on the information provided in the question for the college requirements. It is a limited one and contains only those entities mentioned in the resquirement.In the diagram, each student can take one or more courses he wishes to. Each course is taught by a teacher(instructor). Again, a teacher can teach more than one courses and we have a foreign key constraint of the course_id with both the student and the teacher table. Each student gives various exams during his semester but one student can appear in an exam for once only. The exam_name is the primary key in the exam table. All the other primary keys are also underlined in the diagram.
Diagram: