Assignment On Functional Dependencies In ER Diagram

Added on - 22 Sep 2019

  • 7

    Pages

  • 813

    Words

  • 148

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
Student name:17 October 2016DATABASE ASSIGNMENT 2
ContentsQUESTION 1: RELATIONAL MODEL............................................................................................2QUESTION 3.1, 3.2, 3.3..................................................................................................................2FUNCTIONAL DEPENDENCIES..................................................................................................2ER DIAGRAM VIDEO MASTER VIDEO SHOPDATABASE.......................................................3SQL COMMANDS..............................................................................................................................4RESEARCH QUESTION....................................................................................................................61|P a g e
QUESTION 1: RELATIONAL MODELQUESTION 3.1, 3.2, 3.3The tables in the relational schema modelled from the ER, are as follows:1.TestReport (test,prodID*,result)2.Product (prodID, prodName)3.Order (orderNo, orderDate)4.Part (partID, partName)5.Supplier (suppName, suppPhoneNo, suppAddr)6.MadeUp (partID*,prodID*)7.OnOrd (partID*, quantity)8.Supply (suppName*,partID*)9.OrdSupp (suppName*,orderNo*, quote, managerName)FUNCTIONAL DEPENDENCIESThe functional dependencies in the ER diagram are:1.test, prodID -> result2.prodID -> prodName3.orderNo -> orderDate4.partID -> partName5.suppName -> suppPhoneNo6.suppPhoneNo -> suppAddr7.partID -> quantity8.suppName, orderNo -> quote2|P a g e
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