1D0-541 Exam Dumps : CIW v5 Database Design Specialist

It is the primary key for an entity.

It uniquely identifies every instance of an entity.

One or more keys are joined together to form a composite key.

One or more keys may be used to form a primary key.

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key BUILDING RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key RESIDENT

BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING ForeignKey BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID Foreign Key

Building_ID references BUILDING(Building_ID)

The intersection oftwo relations

ACartesian product of two relations

Arestricted Cartesian product of two relations

The Cartesian product oftwo union-compatible relations