Pay
Foriegn Key in ER diagram

Foriegn Key in ER diagram

Customers

customer_nr <PK>

phone_nr

name

address

Product

product_code <PK>

price

type

manufacure

Stock

product_code <PF>

stop_nr <PF>

type

manufacure

Shops

shop_nr <PK>

address

name

Sales_details

product _codeFK <PF>

sales_nrFK <PF>

quantity

Sales

sales_nr <PK>

customer_nr <FK>

staff_nr <FK>

shop_nr <FK>

date

sum_total

Vendors

staff_nr <PK>

name

Foriegn Key in ER diagram

88
0
2
publish time: 2020-10-12
Charlotte

Foreign key is a field in a table that uniquely identifies a row in another table or same table. In this foreign key in ER diagram example, the foreign key is marked as FK

See More Related Templates