1. Identify all entities:

E.g.

EntityX

2. Identify special attributes:

• Composite attributes:

E.g.

AttributeX(subattributeX1, subattributeX2, ), AttributeY(, )

• Derived attributes:

3. Initial translation to relational schemas for all identified entities:

TIPS: Remember to indicate PK in correct way.

4. Identify cardinality ratios of all relationships:

E.g.

• Many-to-Many:

EntityX : EntityY

• One-to-Many:

• One-to-One:

5. Update relational schemas translation (add extra relation or attribute) with foreign key, according to cardinality:

First write the schema for EntityX, then in a new line indicate its FK references the PK of an existed Entity Y:

E.g.

EntityX (, AttributeX)

Foreign key AttributeX references EntityY (PK_Y)

• Many-to-many relationships:
• One-to-many relationships:
• One-to-one relationship

6. Update relational schemas translation (add extra relation or attribute) with foreign key, according to special attributes:

• Multi-valued attributes:

7. Repeat above steps if necessary.

8. List final relational schema (after finish Updating according to all situations):

Video videoNo {PK} title category| dailyRental cost actor (1..*] director 1..1 Has 1..1 Has 1.. 0.* VideoCopy copyNo {PK} status 1..* Own 1..1 Branch branchNo {PK} address street city state zip phoneNum Staff staffNo {PK} name position salary 1..1 1..1 1..5 Manage 1..1 Include Register Registration registrationDate 0.2 0..* VideoRental rentalNo {PK} dateOut dateReturned /totalRental 0..* Request Member memberNo {PK} name 1..1 address street city state zip