Ask a question from expert

Ask now

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
A Study on Functional Dependency and Relational Schema_1
Table of ContentsDependency Diagram..................................................................................................................................3Third (3rd) Normal Form..............................................................................................................................4Relational Schema with referential integrity constraints..............................................................................5Entity Relation Diagram..............................................................................................................................6References...................................................................................................................................................7
A Study on Functional Dependency and Relational Schema_2
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
A Study on Functional Dependency and Relational Schema_3

End of preview

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

Related Documents
Database Schema Design Using Entity-Relationship Approach
|7
|567
|303

Database Relation Normalization | Assignment
|7
|837
|276

Entity Relationship Diagram and Schema | Assignment
|5
|141
|54

Database Management Systems - Assignment
|6
|324
|168

Assessment on Database Management System
|5
|388
|262

Database Normalization and 3NF Relations
|9
|947
|25