Question1:

Use SQL to define the following view:

StudentID StudentName

38214 Letersky

54907 Altvater

54907 Altvater

66324 Aiken

Q2:

Write SQL data definition commands for each of the following

queries:

a. How would you add an attribute, Class, to the Student

table?

b. How would you change the FacultyName field from

25 characters to 40 characters?

Question3:

Write SQL commands for the following:

a. Create an SQL command that will modify the name of

course ISM 4212 from Database to Java.

b. Use the INSERT command to add a student with a student ID of 65798 and last name Lopez and class Java to the Student table.

Question4:

Write SQL queries to answer the following questions:

a. Which students have an ID number that is less than 50000?

b. What is the name of the faculty member whose ID is 4756?

c. What is the smallest section number used in the first

semester of 2008?

Question5:

Write SQL queries to answer the following questions:

a. How many students are enrolled in Section 2714 in the

first semester of 2008?

b. Which faculty members have qualified to teach a

course since 1993? List the faculty ID, course, and date

of qualification.

Question6:

8. Write SQL queries to answer the following questions:

a. Which students are enrolled in Java and Networking?

(Hint: Use SectionNo for each class so you can determine

the answer from the Registration table by itself.)

b. Which instructors cannot teach both Syst Analysis and

Syst Design?

Question7:

Write SQL queries to answer the following questions:

a. What are the courses included in the Section table? List

each course only once.

b. List all students in alphabetical order by StudentName.

c. List the students who are enrolled in each course in

Semester I, 2008. Group the students by the sections in

which they are enrolled.

d. List the courses available. Group them by courseID.