Limited-time discount for students! | Solutions starting at $6 each

ITECH 1006 - Assignment On Database Management Systems

Added on - 03 Mar 2020

  • ITECH 1006

    Course

  • 12

    Pages

  • 1416

    Words

  • 336

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 12 pages
Running Head: ITECH 1006 -DATABASE MANAGEMENT SYSTEMSITECH 1006 - Database Management Systems[Name of the student][Name of the university]
ITECH 1006 - DATABASE MANAGEMENT SYSTEMS1Table of ContentsER Diagram2Normalization2Data dictionary5Database schema7Bibliography11
ITECH 1006 - DATABASE MANAGEMENT SYSTEMS2ER DiagramFigure 1: Entity Relationship Diagram of TopFit(Source: Created by author)NormalizationThe normalization is a concept of reducing redundancy as well as dependency of data toorganized a database design. In other word, it can be define as splitting large relation into smallerrelation and link using their functional dependency.However, here some entities are in 1stnormal form and also have single column ofprimary key. According to the TopFit gym background study the above entity relationshipdiagram is created, where all tables are decomposed up to 3rdnormal form.
ITECH 1006 - DATABASE MANAGEMENT SYSTEMS3Figure 2: Decomposing relations to eliminate transitive dependency(Source: Created by author)At first a member is associated with the class and staffs, therefore if member, class andstaffs are representing in one relation. This relation can be defining as 1stnormal form, but whenit separated in three different relations as well as all of them contains one primary key than itcould be a 2ndnormal form. After that evaluating the functional dependency among theserelations, if any transitive dependency found than that relation is decomposed in 3rdnormal form.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document