Document on Relational Database Design

Added on - 28 May 2020

  • 8

    pages

  • 517

    words

  • 8

    views

  • 0

    downloads

Showing pages 1 to 3 of 8 pages
Running head:RELATIONAL DATABASE DESIGNRelational Database DesignName of the StudentName of the University
RELATIONAL DATABASE DESIGN1Table of Contents1. Dependency Diagram:.................................................................................................................22. Normalization:.............................................................................................................................23. Relational Schema:......................................................................................................................6Bibliography:...................................................................................................................................7
RELATIONAL DATABASE DESIGN21. Dependency Diagram:Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGradeGRADE REPORT TablePartial DependencyTransitive DependencyFunctional DependencyTransitive DependencyFigure 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
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