Reference no: EM131240121
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
|
|
Discuss a company that does an effective job of utilizing
: Construct a 2-3 page paper, based on the four characteristics of a product with potential for sustainable competitive advantage and based on the research you conducted; identify and discuss a company that does an effective job of utilizing these r..
|
|
How many armbands need to be grabbedsome of the players deci
: How many armbands need to be grabbed in order to assure that one of the teams has at least seven players?
|
|
Bound on the number of times heap
: (a) Argue that the algorithm above (1) outputs numbers in increasing order, (2) doesnot output any number twice, (3) only outputs humble numbers, and (4) outputs all of thefirst n humble numbers. (b) Derive an exact (i.e., no O-notation) bound on ..
|
|
What if the three flavors have to be different
: Four teams are attending a local Ultimate Frisbee meet. If each team plays each other team exactly once, how many games are played?
|
|
Delete a database table
: Create a trigger that will display warning message, "please consult with DBA first before delete a database table", when user attempting to delete it
|
|
Are the 4ps no longer relevant
: Are the 4Ps no longer relevant? If they are, are they only relevant to certain industries, channels, or products? Which ones? Are the 4Cs able to replace the 4Ps in every business environment?
|
|
Keys to designing a successful data communications network
: What are the keys to designing a successful data communications network? - How does the traditional approach to network design differ from the building-block approach?
|
|
Prepare all general journal entries for the two bonds issued
: Prepare all general journal entries for the 2 bonds issued and any interest accruals and payments for the fiscal year 2016. What is the carrying amount on the December 31, 2016 Balance Sheet for 4A. and 4B?
|
|
Describe the key parts of the technology design step
: Describe the key parts of the technology design step. - How can a network design tool help in network design? - On what should the design plan be based?
|