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 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
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
Get step-by-step solutions from verified subject matter experts
