Assignment On Functional Dependencies In ER Diagram
Added on -2019-09-22
| 7 pages
| 813 words
| 260 views
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 SHOP DATABASE.......................................................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
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan