Ask a question from expert

Ask now

COIT20247 Database Design and Development- Doc

7 Pages620 Words34 Views
   

Added on  2021-06-16

COIT20247 Database Design and Development- Doc

   Added on 2021-06-16

BookmarkShareRelated Documents
COIT20247 DATABASEDESIGN ANDDEVELOPMENT (T12018)Assignment 2Student ID:Module Tutor:Date:Implementation Report
COIT20247 Database Design and Development- Doc_1
IntroductionThe report is summarising the database that is based upon the CQI. The database implementation is completely done in the assignment for the CQI. The mapping from ER diagram to the relational database is built first and then the database equerries and reports are done after inserting the data into tables.NormalizationER Diagram Mapping Functional Dependency PersonPerson (FPersonID, FPersonName, FStreet, FCity, FPostcode, FPersonType)FPersonNameFPersonIDFPersonTypeFPersonIDAll the fields just like person name and person type are depending upon the person IDonly which is working as a primary key in the Person table.Property1 | P a g e
COIT20247 Database Design and Development- Doc_2
Property (FPropertyID, FStreet, FCity, FPostcode, FPersonID)FStreetFPropertyIDFCityFPropertyIDFPostcodeFPropertyIDFPersonIDFPropertyIDAll the fields just are depending upon the person ID only which is working as a primary key in the Person table.NormalisationThird Normalized database is obtained by applying the following rules at all the tables--Create different tables for similar type of data.-Generate primary key in all tables.-All fields should be depended upon the primary key only.-There should be no transitive dependency in any table. Just like Property and Person tables, all the tables are satisfying the above rules. Therefore, complete data is in the third normalized form.(Juniper Networks 2018)(Cambridge University Press 2008)2 | P a g e
COIT20247 Database Design and Development- Doc_3

End of preview

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

Related Documents
COIT20247 Database Design and Development - Doc
|8
|859
|53

COIT20247 Database Design & Development
|7
|643
|52

COIT20247 Database Design and Development - PDF
|8
|767
|87

COIT20247 : Database Design and Development
|7
|607
|75

Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018
|8
|769
|200

COIT20247 - Database Design and Development
|8
|824
|70