Problem

Design a Database for Metro Couriers

1. Consider the following set of requirements for Metro Couriers:

a. For each courier, the company keeps track of the courier's name(first name and last name), courier's address,(street, city, state, postal code), courier's driver license, and mobile telephone number.

b. For each motorbike, the company keeps track of a unique motorbike ID number, motorbike license number, and motobike model.

c. A courier can be assigned to more than one motorbike. A motorbike will have multiple couriers but only one courier at a time.

2. Based on these requirements, do the following:

a. Identify and list the entries and attributes of those entities.

b. Identify and list the functional dependencies.

c. Create a set of 3NF relations using the shorthand notation. Be sure to identify all primary and foreign keys appropriately.