logo

Database Assignment

   

Added on  2019-09-22

7 Pages813 Words260 Views
 | 
 | 
 | 
Student name: 17 October 2016DATABASE ASSIGNMENT 2
Database Assignment_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
Database Assignment_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
Database Assignment_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