PPT Slide

DB Design concepts:

how to represent entities and relations

Flat files

DB tables

graphical

relational notation

P#

PNAME

COLOR

WEIGHT

PROJ#

PROJNAME

S#

QTY

PROJ#

...

S#

SNAME

STATUS

CITY

S#

SNAME

STATUS

CITY

PNAME

CITY

S#

S (

S#,

SNAME,STATUS,CITY)

P (

P#

,PNAME,COLOR,WEIGHT)

J (

PROJ#

,PROJNAME,CITY)

O (

S#,P#,PROJ#

,QTY)

S

P

J

O

P#

COLOR

WEIGHT

PROJNAME

PROJ#

QTY

P#

PROJ#

FIELDS:

keys and atributes

primary and foreign keys

Previous slide

Next slide

Back to first slide

View graphic version