Database Systems
Given the following relation schemes:
Teacher = [CourseN, Quarter,TeacherName]
Course = [CourseN,CourseName, Nunit)
Student = [studentName, CourseN, Quarter]
LocationNTime = [CourseN, Quarter , DayTime, RoomN]
//Examples of DayTime: M2:00AM, W4:50PM, and T8:00PM. Note that DayTime is represented as a string.
Express the following queries by SQL statements and test them using any appropriate data. Take screenshots of the result, please let me know what program you use and please show all answers in complete form.
1. List the name of every teacher (distinct names) who teaches in RoomN 34 in Winter2011.
2. List CourseN, CourseName, and TeacherName of every course meets on Monday PM.
3. List the name of every teacher who taught at least one course in RroomN 723.
4. List the CourseN, Quarter, RoomN and DayTime of every course taught by Karen Reed in the Spring 2005.
5. List the CourseN and TeacherName of every course taken by the student Ron Smith or by the student David Weidman.
6. List the CourseN and Quarter of every course taught by Karen Reed and met or meets in RoomN 713.
7. List the name of every teacher who has taught the same course at least two times.
8. List the name of every teacher( distinct names) who has taught at least two different courses in the same or different quarters.
9. List the CourseN, CourseName, and Quarter which meets or met at least two times a week.
10. List the CourseN and CourseName of every course with number of units > 4.
11. List every course number and students name who has taken the course at least twice.
12. Use * to list the CourseN, CourseName, Nunit, Quarter, TeacherName of every
course sorted by CourseN ascending, CourseName descending.
13. List the CourseN and Quarter of every course taught by two different instructors in the same quarter ordered by the CourseN in descending order.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
