Create tables: Faculty, Course, Student, Qualified and Registration.11 ed (fig 7-16) or (fig 7-25) 12 ed.
1. Insert data into those tables.
2. Write queries for a, b and c.
Write and run following SQL queries on the tables you created above:
List the course names and all sections that are available to students.
List the total number of students registered in the school.
List the names of the students who are enrolled in two or more courses.
List the Faculty names and courses that are most popular for students.
Create a trigger that will display warning message, "please consult with DBA first before delete a database table", when user attempting to delete it
STUDENT(StudentID, StudentName)
|
StudentID
|
StudentName
|
|
38214
|
Letersky
|
|
54907
|
Altvater
|
|
66324
|
Aiken
|
|
70542
|
Marra
|
QUALIFIED (FacultyID ,CourseID, DateQualified)
|
FacultyID
|
Course ID
|
Date Qualified
|
|
2143
|
ISM 3112
|
9/1988
|
|
2143
|
ISM 3113
|
9/1988
|
|
3467
|
ISM 4212
|
9/1995
|
|
3467
|
ISM 4390
|
9/1996
|
|
4796
|
ISM 3113
|
9/1996
|
|
4756
|
ISM 3112
|
9/1991
|
FACULTY (FacultyID , FacultyName
|
FacultyID
|
Faculty Name
|
|
2143
|
Birkin
|
|
3467
|
Berndt
|
|
4756
|
Collins
|
SECTION(Section No, Semester,CourseID)
|
SectionNo
|
Semester
|
CourseID
|
|
2712
|
I-2008
|
ISM 3113
|
|
2713
|
I-2008
|
ISM 3113
|
|
2714
|
I-2008
|
ISM 4212
|
|
2715
|
I-2008
|
ISM 4930
|
COURSE ( CourseID,Course Name)
|
CourseID
|
CourseName
|
|
ISM3113
|
Syst Analysis
|
|
ISM 3112
|
Syst Design
|
|
ISM 4212
|
Database
|
|
ISM 4930
|
Networking
|
REGISTRATION (StudentID , Section NoSemester)
|
StudentID
|
SectionNo
|
Semester
|
|
38214
|
2714
|
I-2008
|
|
54907
|
2714
|
I-2008
|
|
54907
|
2715
|
I-2008
|
|
66324
|
2713
|
I-2008
|