Reference no: EM13974129
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)
|
|
STUDENT (StudentID, StudentName)
|
|
StudentID
|
StudentName
|
|
38214
|
Alvaro
|
|
54907
|
Letterman
|
|
66324
|
Troy
|
|
70542
|
Myra
|
|
..........
|
|
|
FACULTY (FacultyID, FacultyName)
|
|
FacultyID
|
FacultyName
|
|
1123
|
Cooper
|
|
4237
|
Burgess
|
|
5115
|
May
|
|
........
|
|
|
COURSE (CourseID, CourseName)
|
|
CourseID
|
CourseName
|
|
CMIS 320
|
Relational Database
|
|
CMIS 102
|
Algorithm Design
|
|
CMIS 420
|
Advance Relational Database
|
|
CMIS 170
|
Introduction to XML
|
|
CMSC 100
|
Intro to Computer Science
|
|
........
|
|
|
|
QUALIFIED (FacultyID, CourseID, DateQualified)
|
|
FacultyID
|
CourseID
|
DateQualified
|
|
1123
|
CMIS 102
|
9/2014
|
|
1123
|
CMIS 170
|
9/2014
|
|
4237
|
CMIS 420
|
9/2012
|
|
4237
|
CMIS 320
|
9/2013
|
|
5115
|
CMIS 102
|
9/2011
|
|
5115
|
CMIS 170
|
9/2011
|
|
..........
|
|
|
|
SECTION (SectionNo, Semester, CourseID
|
|
SectionNo
|
Semester
|
CourseID
|
|
3115
|
FALL-2014
|
CMIS 320
|
|
3116
|
FALL-2014
|
CMIS 320
|
|
3117
|
FALL-2014
|
CMIS 102
|
|
3118
|
FALL-2014
|
CMIS 420
|
|
..........
|
|
|
|
REGISTRATION (StudentID, SectionNo, Semester)
|
|
StudentID,
|
SectionNo
|
Semester
|
|
38214
|
3117
|
FALL-2014
|
|
54907
|
3117
|
FALL-2014
|
|
54907
|
3118
|
FALL-2014
|
|
66324
|
3116
|
FALL-2014
|
|
.....
|
|
|
|
|
|
|
|
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?
|
Should you be allowed to hackback against a cyber attacker
: "should you be allowed to hackback against a cyber attacker under some circumstances, and if so, what circumstances?"
|
|
What are the essential elements needing attention
: Introduction to the Situation: Briefly describe the situation and identify the primary issues contributing to the coaching scenario. What are the essential elements needing attention? Using a coaching perspective, identify the problem as clearly a..
|
|
What are some tips for developing and using the bis describe
: How does the business intelligence system (BIS) at CKE add value to the business? What are some tips for developing and using the BIS described in this case?
|
|
Journal entry to record flyer bad debt expense
: Prepare the journal entry to record Flyer's bad debt expense for 2015. 2.. Now assume that Flyer estimates bad debt expense as 10% of accounts receivable. Prepare the journal entry to record Flyer's bad debt expense for 2015. 3.
|
|
Write a command that will remove barry from student table
: What is the smallest section number used in the FALL-2014 semester?
|
|
Determine what the optimal level of output is for the firm
: Determine what the optimal level of output is for the firm and the firm's profit if fixed costs are expected to be $4.0 million.
|
|
Computing the financing activity
: In the Cash Flow column, indicate whether the item is an operating activity (OA), investing activity (IA), or financing activity (FA). Use NA to indicate that an element is not affected by the event. (Enter any decreases to account balances and ca..
|
|
Article review - a phenomenology of the integration of faith
: Article- A PHENOMENOLOGY OF THE INTEGRATION OF FAITH AND LEARNING. Provide atitle page in currentAPA format including only your name, the paper title (referring to the article title), and the institutional affiliation
|
|
Division of net income
: PFW Co. reports net income of $76,900. Partner salary allowances are Pitts $16,130, Filbert $3,110, and Witten $6,500. Indicate the division of net income to each partner, assuming the income ratio is 50 : 30 : 20, respectively.
|