TOPIC: Collect one example for mapping of ER model to Relational model

SUPPLIES CONTRACT SYSTEM

ER diagram of a supplies contract system is given below. Suppliers contract with contracters. Contracters supplied orders needed for the projects. Items are made according to the orders.

  • Supplier is uniquely identified by Sno#. It also consist Name & Address. Name consists of Fname & Lame. Address consists of State,City & Street.
  • Contracter is uniquely identified by Contract ID#. It also consists of Name & Phone.
  • Items are uniquely identified by Item No#. It also consists of Item_discription. Item_discription consist of Item size & Quantity.
  • Orders are uniquely identified by Order No. It also consists of Date Completed & Date Required.
  • Projects are uniquely identified by Project No#. It also consist Project Date.

ER DIAGRAM

sumi5

Advertisements