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

166
0
4
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

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA