logo

Database Schema Design Using Entity-Relationship Approach

7 Pages567 Words303 Views
   

Added on  2020-02-24

Database Schema Design Using Entity-Relationship Approach

   Added on 2020-02-24

ShareRelated Documents
Student IDNameSubject code
Database Schema Design Using Entity-Relationship Approach_1
Table of ContentsDependency Diagram..................................................................................................................................3Third (3rd) Normal Form Relations..............................................................................................................4Relational Schema with referential integrity constraints..............................................................................5Entity Relation Diagram..............................................................................................................................6References...................................................................................................................................................7
Database Schema Design Using Entity-Relationship Approach_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 the above mentioned scenario, Prod_Name, Prod_price, Purchase_date, Vendor_IDand Vendor_Name are dependent (functionally) on Prod_codeSecond Functional Dependency:Prod_code, Inv_No Qty_sold, Inv_DateIn the above mentioned scenario, Qty_sold and Inv_Date are dependent (functionally) onProd_code, and Inv_NoThird Functional Dependency:Vendor_ID Vendor_NameIn the above mentioned scenario, Vendor_Name is dependent (functionally) onVendor_ID
Database Schema Design Using Entity-Relationship Approach_3

End of preview

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

Related Documents
A Study on Functional Dependency and Relational Schema
|7
|557
|237

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