logo

Relational Database Design - Assignment

8 Pages517 Words271 Views
   

Added on  2020-05-28

Relational Database Design - Assignment

   Added on 2020-05-28

ShareRelated Documents
Running head: RELATIONAL DATABASE DESIGNRelational Database Design Name of the StudentName of the University
Relational Database Design - Assignment_1
RELATIONAL DATABASE DESIGN1Table of Contents1. Dependency Diagram:.................................................................................................................22. Normalization:.............................................................................................................................23. Relational Schema:......................................................................................................................6Bibliography:...................................................................................................................................7
Relational Database Design - Assignment_2
RELATIONAL DATABASE DESIGN21. Dependency Diagram:Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGradeGRADE REPORT TablePartial DependencyTransitive Dependency Functional DependencyTransitive Dependency Figure 1: Dependency Diagrams Based on Given Table(Source: Created by Author)2. Normalization:1st Normal Form: Every attribute in the database need to have atomic value. Everyattribute in the following table is consist of single value.Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade16830058WilliamsAlburyBITITC114DatabaseSysPeterB104HD16830058WilliamsAlburyBITITC211SysAnalysisJohnB115D543291073BakerWaggaAcctITC200DatabaseMgtDavidH310D543291073BakerWaggaAcctAcc11FundAcctWilliamA120C543291073BakerWaggaAcctMkg21Intro MktMikeA112P
Relational Database Design - Assignment_3

End of preview

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

Related Documents
The Database Design - Doc
|8
|552
|81