Data Design

Computer Solutions of the Southeast is a company that specializes in providing computer solutions to small business owners in the southeast. The company has many computer technicians that are assigned to provide services to customers. It is your job to create a database management system for the company.

Background

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