Homework 4

Homework 4

Given the relations below, create the database tables using SQL DDL  (Data Definition Language).  Assume the following attribute data types:

StudentID (integer, primary key)

StudentName (25 characters)

FacultyID (integer, primary key)

FacultyName (25 characters)

CourseID (8 characters, primary key)

DateQualified (date)

SectionNo (integer, primary key)

Semester (7 characters)

After creating the tables above, write SQL statements to answer the following questions.  Submit your work as a text file containing the 6 SQL statements.

a)      What is the name of the faculty member whose ID is 1123?

b)      What is the smallest section number used in the FALL-2014 semester?

c)       How many students are enrolled in Section 3117 of FALL-2014?

d)      Create an SQL command that will modify the name of course CMIS 320 from Relational Database to Relational Database Concepts and Applications

e)      Write a command that will remove Barry from the Student table

f)       Write statement to add an attribute, Class to the Student table?