PPT Slide

DB design example

S (S#,SNAME,STATUS,CITY)

P (P#,PNAME,COLOR,WEIGHT)

J (PROJ#,PROJNAME,CITY)

O (S#,P#,PROJ#,QTY)

Product

Supplier

Project

a supplier

can provide

a product

can have

project

can use

product can

be part of

a supplier

can supply

a project

can have

many

many

many

many

many

many

Previous slide

Back to first slide

View graphic version