1. Write SQL commands for the following: a. Create two different forms of the IN
ID: 3550909 • Letter: 1
Question
1. Write SQL commands for the following:
a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table.
b. Now write a command that will remove Lopez from the Student table.
c. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.
2. 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?
3. 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?
Use only standard SQL (as in Chapter 6 in the text) to answer these questions. Do not use Microsoft SQL or any other not 100% compliant standard SQL.
Write SQL commands for the following: Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. Now write a command that will remove Lopez from the Student table. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases. Write SQL queries to answer the following questions: Which students have an ID number that is less than 50000? What is the name of the faculty member whose ID is 4756? What is the smallest section number used in the first semester of 2008? Write SQL queries to answer the following questions: How many students are enrolled in Section 2714 in the first semester of 2008? Which faculty members have qualified to teach a course since 1993? List the faculty ID, course, and date of qualification?Explanation / Answer
1 ) a ) insert into student values("65798","Lopez")
b ) remove from student where StudentName=Lopez
c) update course
set courseName=Introduction to Relational Databases where courseID=ISM 4212
2 ) select studentName from student where studentID < 50000
select facultyName from faculty where facultyID=4756
select min(SectionNO) from SECTION where semester=1-2008
3) select count(*) from SECTION where SectionNO=2714 and semester=1-2008
SELECT Qualified.facultyID, Qualified.CourseID,Qualified.DateQualified from QUALIFIED where QUALIFIED.DateQualified>1993
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.