Question: Wright Technical Institute is a small, privately owned computer software training school. The steady growth of the business has convinced the owners that they should

 Wright Technical Institute is a small, privately owned computer software training

school. The steady growth of the business has convinced the owners that

Wright Technical Institute is a small, privately owned computer software training school. The steady growth of the business has convinced the owners that they should implement a relational database system to replace the spreadsheet-based record keeping system currently being used. The main business functions to be addressed include the tracking of: 1) Personnel training qualifications and teaching assignments, 2) Courses offered, 3) Class offerings of the courses, and 4) Clients of the business who enroll in the classes. Suggested Reports Monthly schedule of classes Class roster that includes course name, a listing of clients name and address enrolled in each class. Listing of trainers qualified to teach each course. Given the above suggested reports and the following Tables, do the following: (Use MySQL or MS/ACCESS) 1. Write necessary commands to create those tables and all necessary constraints (primary key, foreign key, etc.) that are required to do the above reports. **Tables needed are CLIENT, ENROLLMENT, CLASS, TRAINER, QUALIFICATION, and COURSE** Then, write necessary commands to create above 3 reports

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create the necessary tables and constraints using MySQL follow these steps Step 1 Define Tables CLIENT Table sql CREATE TABLE CLIENT ClientNo INT P... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!