Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Given the relations below, create the database tables using SQL DDL (Data Definition Language). Assume the following attribute data types:
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)
DateQualified
9/2014
9/2012
9/2013
9/2011
SECTION (SectionNo, Semester, CourseID
SectionNo
Semester
3115
FALL-2014
3116
3117
3118
REGISTRATION (StudentID, SectionNo, Semester)
StudentID,
.....
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?
Write a perl subroutine for temperature conversion named ' convert_temp '. It should be able to handle both Fahrenheit to Celsius conversions as well as Celsius to Fahrenheit conversions.
Alter the Employee table to establish a foreign key between Employees and Departments.
A good IT professional is able to be versatile in SQL programming styles. Identify at least two possible advantages of utilizing PL/SQL instead of standard SQL Syntax.
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
Learning Objectives: The purpose of Project 3 is to enable the students to gain extensive experience with using SQL to design and query databases.
Make sure the number of units for each package is numeric, and is not negative.
Write an SQL DROP statements that will drop the all tables. Add these statements to the appropriate location within the script file - Write a SQL CREATE TABLE statement to create the ALLOCATION table. Add the SQL statement to the appropriate locati..
Prepare the SQL query for each of given requirements. Convert requirement to logic, then to SQL. Illustrate the names of all products which have been sold.
One of the method of preventing SQL injection is by using prepared Statements in PHP. Using that concept write a snippet you would use to add users to a MySQL database from a web-form.
Create a new database in SQL Server and run the following CREATE TABLE commands. Note that you must run the CREATE TABLE statements in the order presented (and load the data in the order presented) to avoid conflicts resulting from foreign key con..
Create a program that enters first and a second number. The first and second number that will be entered should be computed in halves, quarter, double, and square.
Find certain Governors General of Australia. Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date o..
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd