A Study on Functional Dependency and Relational Schema
7 Pages557 Words237 Views
Added on 2019-11-26
A Study on Functional Dependency and Relational Schema
Added on 2019-11-26
BookmarkShareRelated Documents
Student ID:Student Name:Subject code
Table of ContentsDependency Diagram..................................................................................................................................3Third (3rd) Normal Form..............................................................................................................................4Relational Schema with referential integrity constraints..............................................................................5Entity Relation Diagram..............................................................................................................................6References...................................................................................................................................................7
Dependency DiagramFollowing is the dependency diagram. It depicts or represents the functional dependencies:First Functional Dependency:Prod_codeProd_Name, Prod_price, Purchase_date, Vendor_ID,Vendor_NameIn first functional dependency, Prod_Name, Prod_price, Purchase_date, Vendor_ID andVendor_Name are depend upon Prod_codeSecond Functional Dependency:Prod_code, Inv_No Qty_sold, Inv_DateIn second functional dependency, Qty_sold and Inv_Date are dependent upon Prod_code,and Inv_NoThird Functional Dependency:Vendor_ID Vendor_NameIn third functional dependency, Vendor_Name is dependent upon on Vendor_ID
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Schema Design Using Entity-Relationship Approachlg...
|7
|567
|303
Database Relation Normalization | Assignmentlg...
|7
|837
|276
Entity Relationship Diagram and Schema | Assignmentlg...