oAssignment:-

STUDENT	    STUDID		STUNAME		MAJOR		CREDITS
		      S1001		 Smith, Tom		History		   90
		      S1010		 Burns, Edward		Art		   63
		      S1015		 Jones, Mary	                Math		   42
		      S1002		 Chin, Ann		Math		   36
		      S1020		 Rivers, Jane		CSC	                   15
		      S1013		 McCarthy, Owen		Math		   09  

FACULTY	    FACID		FACNAME		DEPT			   RANK
		      F101		 Adams		Art			   Professor
		      F202		 Smith			History	               Associate
		      F105		 Tanaka	            CSC			   Instructor
		      F110		 Byrne			Math			   Assistant
		      F221		 Smith			CSC			   Professor

CLASS	    COURSE#		FACID		SCHED		    ROOM
		      ART103A		 F101			NWF9			   H221
		      CSC201A		 F105			TUTHF10	               M110
		      MTH101B		 F110	            	MTUTH9		   H225
		      HST205A		 F202			MWF11		   H221
		      MTH103C		 F110			MWF11		   H225
		      CSC203A		 F105			MTHF12		   M110

ENROLL	    COURSE#		STUID			GRADE		   
		      ART103A		 S1001			    A		   
		      CSC201A		 S1020			    B	               
		      CSC201A		 S1002            		    F		   
		      ART103A		 S1010				   	   
		      ART103A	 	 S1002  		    	    D		   
		      MTH101B		 S1020			    A		   
		      HST205A		 S1001			    C
		      MTH103C		 S1010	
		      MTH103C		 S1002  		    	    B		 

Above Example has the following conceptual schema:-
STUDENT (STUID, STUNAME, MAJOR, CREDITS)
FACULTY (FACID, FACNAME, DEPT, RANK)
CLASS (COURSE#, FACID, SCHED, ROOM)
ENROLL (COURSE#, STUID, GRADE)

Q1. Display only the STUNAME, STUID and CREDITS Column.
Q2. Get all information about CSC faculty.
Q3. Get the course number of all courses in which students are enrolled.
Q4. Get the course number of all courses in which students are enrolled but do not displays duplicate course.
Q5. Get all information about all students.
Q6. Get names and ID’s of all faculty members, arranged in alphabetical order by name.
Q7. Get names of all math majors who have more than 30 credits.
Q8. Find IDs and names of all students taking ART103A.
Q9. Find IDs and names of all students taking ART103A arrange in order by STUID.
Q10. Find course numbers and the names and majors of all students enrolled in the courses taught by 
         faculty member F110.
Q11. Get a list of all courses that meet in the same room, with their schedules and room numbers.
Q12. Find all combinations of students and faculty where the student’s major is different from the 
         Faculty member’s department.
Q13. Find the numbers of all the courses taught by Byrne of the Math Department.
Q14. Find the names and IDs of all faculty members who teach a class in room H221.
Q15. Get an alphabetical list of names and IDs of all students in any class taught by F110.
Q16. Find the names of all students enrolled in CSC201A.
Q17. Find the names of all students who are not enrolled in CSC201A.
Q18. Get the IDs of all faculty who are assigned to the History Department at either main campus
          Or the branch campus.
Q19. Find the total number of students enrolled in ART103A.
Q20. Find the number of departments that have faculty in them.
Q21. Find the average number of credits student have.
Q22. Find the student with the largest number of credits.
Q23. Find the ID of the student(s) with the highest grade in any course.
Q24. Find names and IDs of students who have less than the average number of credit.
Q24. Assuming that each course is three credits, list, for each student, the number of courses that he or she 
         has completed.
Q25. For each course, show the number of students enrolled.
Q26. Find all courses in which fewer than three students are enrolled.
Q27. Get details of all MTH courses.
Q28.  Find the STUID and COURSE# of all students whose grade in that course is missing.
Q29.  Change the major of S1020 to Music.
Q30.  Change Tanaka’s department to MIS and rank to Assistant.
Q31.  To insert a null value into a field that already has an actual value, we must use the form. 
Q32.  Change grades of all students in CSC201A to A.
Q33.  Give all students three extra credits.
Q34.  Change the room to B220 for all courses taught by Tanaka.
Q35.  Insert a new faculty record with ID of F330, name of jones,department of CSC,and rank of Instructor.
Q36.  Insert a new student record with ID of S1031, name of Maria Bono, 0 credits, and no major.
Q37.  Create and fill a new table that shows each course and the number of students enrolled in it.
Q38.  Erase the record of student S1020.
Q39.  Erase all enrollment records for student S1020.
Q40. Erase all the class records.
Q41. Erase all enrollment records for Owen McCarthy.
Q42. To create a view for a user who needs to see IDs and names of all history majors.
Q43. To obtain a table of all courses with their schedules and rooms.
Q44. Assume that a user needs a table containing the IDs and names of all students in course CSC101.
Q45. If we want a view of ENROLL that gives COURSE# and the number of students enrolled in each 
         Class 

Exercises

1.	Write the commands needed to create the FACULTY and CLASS tables for the examples used in 
this chapter.

Use the following tables and write

2.	Get the names of all workers in the accounting department.
3.	Get an alphabetical list of names of all workers assigned to project P12.
4.	Get details of the project with the highest budget.
5.	Get the names and departments of all workers on project P20.
6.	Get an alphabetical list of names and corresponding ratings of all workers on any project that is 
Managed by Jones.
7.	Create a view that has the project number and manager of each project,along with the IDs and names
Of all workers assigned to it.
8.	Using the view created in Ex 7,find the project number and project manager of all projects to which 
Employee E101 is assigned.

9.	Add a new worker named Jack Smith with ID of 101 to the sale department.
10.	Change the hours that employee