1. Identify all entities: (E.g.EntityX)
2. Identify special attributes:
   1. Composite attributes: (E.g. AttributeX(subattributeX1, subattributeX2, ), AttributeY(, ) )
   2. 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:

• 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