logo

Assignment On Functional Dependencies In ER Diagram

7 Pages813 Words260 Views
   

Added on  2019-09-22

Assignment On Functional Dependencies In ER Diagram

   Added on 2019-09-22

ShareRelated Documents
Student name: 17 October 2016DATABASE ASSIGNMENT 2
Assignment On Functional Dependencies In ER Diagram_1
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
Assignment On Functional Dependencies In ER Diagram_2
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
Assignment On Functional Dependencies In ER Diagram_3

End of preview

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

Related Documents
Database Concepts
|14
|1841
|106

Database Concepts - Study Material and Solved Assignments
|9
|730
|289

Database Design And Development - Assignment
|9
|884
|27

(solved) SQL Queries Assignment
|5
|372
|57

Entity Relationship Modelling Assignment
|17
|2659
|240

Database Implementation Report for CQUnited Property Management System
|8
|932
|250