You should include data about customers, computer technicians, services available, and the jobs that are performed. Identify the data fields that should be included in the database, and decide how the fields will be logically separated into tables.

Tasks

Draw an ERD to show the type of relationship that exists between the tables.

List each table and indicate which fields belong to each table.

Specify which field is the primary key in each table.

Specify which field is the foreign key, where appropriate, to show how the tables are related through the primary key-foreign key relationship.

Suggest a type of code that can be used as the primary key (unique identifier) for each of the tables in the database. Give an example of each.