logo

Database Design Assignment | Modifying a Database Design

5 Pages719 Words318 Views
   

Added on  2020-05-16

Database Design Assignment | Modifying a Database Design

   Added on 2020-05-16

ShareRelated Documents
Running head: MODIFYING A DATABASE DESIGNModifying a Database Design Name of the StudentName of the University
Database Design Assignment | Modifying a Database Design_1
MODIFYING A DATABASE DESIGN11. Modified Diagram:StudentCampusCourseRoomsInstrutorInstrutor_PhoneInstrutor_EmailInstrutor_EmailCourseInstrutor_PhoneInstrutor_EmailStudent IDPKFirstNameLastNameAddressCityStateZipCodeBirth_DateCreditsCampusIDFKCourseIDFKCampusIDPKTypeLoactionCourseIDPKNameSessionRoomIDFKRoomIDPKNumberFloorCampusIDFKInstructorIDPKFirstNameLastNameAddressCityZipInstructorIDFKPKPhoneNumberPKTypeInstructorIDFKPKEmailAddressPKTypeInstructorIDFKPKCourseIDFKPKGenderBirth_DateStart_DateGenderDepartmentSectionsQuarters_OfferedCourseIDFKPKGradeStudent IDFKPKInstructorIDFKPKPhoneNumberPKTypeInstructorIDFKPKEmailAddressPKTypeFigure 1: The Modified ERD of College (Source: Created by Author)2. Design Summary:The final ERD is consisted of eleven entities. The student table is consisting of all therelevant entities like, name, address, contact number, address, GPA, birthdate and many more.The CampusID is the foreign key of the campus table. Each of the student will be associated witha single campus so the one-to-many relation between campus and student. In the previousdiagram, the student table was consisting of courseID as the foreign key. In the modifieddiagram, a different table has been created to hold the studentID, courseID and grade. Thisdefines that the database holds the grade of the students after completion of each course. Thisallows the database to store the grades for different courses for each of the student without anyanomalies. The phone numbers will be stored in a different table so that more than one mobile
Database Design Assignment | Modifying a Database Design_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Assignment | Database Management Assignment
|13
|2424
|64

DATABASE CONCEPTS CHALLENGE UK
|34
|5584
|38

The Database Design - Doc
|8
|552
|81

Database Design
|30
|2273
|61

Database Design for College: ER Diagram, Summary, and Implementation Plan
|5
|1073
|165

Database Modelling: Assignment
|12
|2283
|241