logo

ITECH 1006 - Assignment On Database Management Systems

12 Pages1416 Words588 Views
   

Database Management Systems (ITECH 1006)

   

Added on  2020-03-04

ITECH 1006 - Assignment On Database Management Systems

   

Database Management Systems (ITECH 1006)

   Added on 2020-03-04

ShareRelated Documents
Running Head: ITECH 1006 - DATABASE MANAGEMENT SYSTEMSITECH 1006 - Database Management Systems[Name of the student][Name of the university]
ITECH 1006 - Assignment On Database Management Systems_1
ITECH 1006 - DATABASE MANAGEMENT SYSTEMS1Table of ContentsER Diagram2Normalization2Data dictionary5Database schema7Bibliography11
ITECH 1006 - Assignment On Database Management Systems_2
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 1st normal 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 3rd normal form.
ITECH 1006 - Assignment On Database Management Systems_3
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 1st normal form, but whenit separated in three different relations as well as all of them contains one primary key than itcould be a 2nd normal form. After that evaluating the functional dependency among theserelations, if any transitive dependency found than that relation is decomposed in 3rd normal form.
ITECH 1006 - Assignment On Database Management Systems_4

End of preview

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

Related Documents
ITECH 1006- Database Management Systems
|10
|1155
|228

Entity Relationship Diagram of TopFit (Source: Created by au
|11
|1283
|188

ITECH 1006 - Database Management Systems FUA
|7
|741
|205

Data Management: The Queensland College database
|8
|1018
|333

ER diagram & Normalization
|9
|1683
|96

Database Designing Experience for Business Entity-Relationship Modelling Module Tutor - Report Declaration
|11
|1108
|78