virtualmv/database management systems

Employee - Carpark (1-1 relationship)

In this page we will look at creating a carpark entity and will show how we link this to an Employee.

Surprisingly a 1-1 relationship requires a bit of manipulation to achieve so has been included after the 1-many and many-many relationships.

The rules for this are

1.Employees can be allocated 0, 1 Carparks for their use.

2.Each Carpark may be allocated to 0 or 1 Employees.

Previously the Employee entity was created so for this example we need to design and create a carpark entity.

Translating the rules and including the entities gives

Now adding the attributes with Primary and foreign keys gives.

Google Sites

Report abuse