CSCI515-1.3a Workshop 1: Use It

1. Your company is concerned there is a problem with the data in one of the database tables. They want you to look at the data and determine if there is a problem. They have stressed it is important to have correct data as it is used for making decisions, and as a basis for reports for various departments.
A:

2. You are registering for a technology conference which includes the following:
A:

3. Use the following business rules to assign name to the tables on the ERD:
A:

4. Add the ends to the relations on the Crows Foot ERD for the business rules of the XYZ Company’s motor pool (a motor pool typically is a group of vehicles that are temporary assigned to employees to drive for business purposes):
A:

Leave a Reply

Your email address will not be published. Required fields are marked *