The Database Design | Docx

Added on - 28 May 2020

  • 8

    pages

  • 552

    words

  • 4

    views

  • 0

    downloads

Showing pages 1 to 3 of 8 pages
Running head:THE DATABASE DESIGNThe Database DesignName of the StudentName of the University
THE DATABASE DESIGN1Table of ContentsGiven Table:....................................................................................................................................21. Dependency Diagram:.................................................................................................................22. Normalization:.............................................................................................................................33. Relational Schema:......................................................................................................................7Bibliography:...................................................................................................................................8
THE DATABASE DESIGN2Given Table:1. Dependency Diagram:Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGradeGRADE REPORT TablePartial DependencyFunctional DependenciesTransitive DependencyTransitive DependencyFigure 1: Dependency Diagrams(Source: Created by Author)Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade16830058WilliamsAlburyBITITC114DatabaseSysPeterB104HD16830058WilliamsAlburyBITITC211SysAnalysisJohnB115D543291073BakerWaggaAcctITC200DatabaseMgtDavidH310D543291073BakerWaggaAcctAcc11FundAcctWilliamA120C543291073BakerWaggaAcctMkg21Intro MktMikeA112P
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document