logo

Database Management Systems - Assignment

6 Pages324 Words168 Views
   

Charles Sturt University

   

Database Management Systems (ITECH 1006)

   

Added on  2020-03-02

About This Document

In this document, we will discuss Normalisation theory and techniques. Also, we cover a dependency diagram to show the functional dependencies in the relation, the referential integrity constraints and a relational schema for 3NF relations.

Database Management Systems - Assignment

   

Charles Sturt University

   

Database Management Systems (ITECH 1006)

   Added on 2020-03-02

ShareRelated Documents
1Running head: DATABASE MANAGEMENT SYSTEMSDATA BASE MANAGEMENT SYSTEMS
Database Management Systems - Assignment_1
2DATABASE MANAGEMENT SYSTEMSAssessment 2NormalizationThe given table is already in First Normal Form since it does not contain any repeating groups[ CITATION Cze17 \l 1033 ]. We therefore create the dependency diagram showing the functional dependencies in the presented relation.Prod_codeProd_NameInv_noProd_priceInv_DatePurchase_dateQuantity_SoldVendor_IdVendor_NamePKTDFDPDPDDecomposing it into a set of 3NF relations, we first move to 2NF from the given 1NF by having INVOICE, in its optimal form.Inv_NoInv_DatePurchase_DateWe are going to be left with PRODUCTS as shown below:
Database Management Systems - Assignment_2
3DATABASE MANAGEMENT SYSTEMSProd_codeProd_NameQuantity_soldProd_priceVendor_IDVendor_NameIt is clear that the dependency between Vendor_ID and Vendor_Name is a Transitive dependency. To have our relation fully decomposed to 3NF, we need to eliminate the transitive dependency[ CITATION Zai98 \l 1033 ]. We will create a relation for the transitive dependency.This will end up to PRODUCTS which is in 3NF.Prod_codeProd_NameProduct_priceQuantity_SoldThe created relation VENDORS is as below:Vendor_IDVendor_NameThe Relational Schema for the 3NF relations will be as follows:
Database Management Systems - Assignment_3

End of preview

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

Related Documents
Assessment on Database Management System
|5
|388
|262

Database Schema Design Using Entity-Relationship Approach
|7
|567
|303

A Study on Functional Dependency and Relational Schema
|7
|557
|237

Database Relation Normalization | Assignment
|7
|837
|276

Entity Relationship Diagram and Schema | Assignment
|5
|141
|54

Report On Normalization | Dependency Diagram | 3NF
|6
|173
|137