Identify and list the functional dependencies

Assignment Help Computer Engineering

Reference no: EM131986672

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.

Reference no: EM131986672

Questions Cloud

Proximity of a large healthcare organization : You are the owner of a small retirement condominium complex that is within close proximity of a large healthcare organization.

Rate of return-net present value : When using the IRR approach, when can the internal rate of return be determined simply by dividing the initial outlay by the cash flows?

Example of the type of conflict : Describe the source of conflict on your team with an example of the type of conflict, whether relationship, task

The remainder of the bill : Due to rising costs, many individuals are no longer able to pay the remainder of the bill after insurance pays its portion.

Identify and list the functional dependencies : Identify and list the functional dependencies. Create set of 3NF relations using shorthand notation. Be sure to identify primary and foreign keys appropriately.

Improve or maintain health : Explain changes a person could make to improve or maintain their health.

Summarize the implications of harassment : Summarize the implications of harassment in the workplace for employees as well as employers.

Write a short essay on the impact that css has on usability : Write a essay on impact that CSS has on usability and efficiency. Many Web design professionals believe that CSS brings about powerful and efficient design.

Middle-income countries might improve health outcomes : Almost all high-income countries have a national health insurance system. Describe how health systems in low- and middle-income countries might improve health

User Account

All Pages