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

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 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.

Explanation / Answer

Creation of tables:

CLIENT table:

CREATE TABLE CLIENT (
Client_No int NOT NULL,
First Name varchar2(255),
Last Name varchar2(255),
Street varchar2(255),
City varchar2(255),
State varchar2(255),
Zip number,
Phone number,
Initiated Date DATE,
PRIMARY KEY (Client_No),
);

ENROLLEMENT table:

CLIENT table:

CREATE TABLEENROLLMENT (
Client_No int NOT NULL,
Rference_No int NOT NULL,
Date/Time DATE,
Fee paid int,
PRIMARY KEY (Client_No),
FOREIGN KEY (Client_No) REFERENCES CLIENT(Client_No)
);

CLASS table:

CREATE TABLE CLASS (
Reference_No int NOT NULL,
Start Date DATE,
Room No int NOT NULL,
Employee No int NOT NULL,
Course_code int,
PRIMARY KEY (Reference_No),
FOREIGN KEY (Room No) REFERENCES Room(Room No)
);

TRAINER table:

CREATE TABLE TRAINER (
Employee_No int NOT NULL,
First Name varchar2(255),
Last Name varchar2(255),
Street varchar2(255),
City varchar2(255),
State varchar2(255),
Zip number,
Phone number,
Email varchar2(255),
PRIMARY KEY ( Employee_No),

);

QUALIFICATION table:

CREATE TABLE QUALIFICATION (
Employee No int NOT NULL,
Course_code int,
Date DATE,
PRIMARY KEY ( Employee No),
FOREIGN KEY ( Employee No) REFERENCES TRAINER( Employee No),
FOREIGN KEY (Course_code) REFERENCES COURSE( Course_code),
);

COURSE table:

CREATE TABLE COURSE (
Course_code int,
Course Name varchar2(255),
Length varchar2(255),
Fee int,
Required PC Type varchar2(255),
ISBN varchar2(255),
PRIMARY KEY (Course_code),

);

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.