Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Having trouble with SQL DDL.  What is the name of the faculty member whose ID is 1123?

/in /by

Having trouble with SQL DDL.  What is the name of the faculty member whose ID is 1123?

  • What is the smallest section number used in the FALL-2014 semester?
  • How many students are enrolled in Section 3117 of FALL-2014?
  • Create an SQL command that will modify the name of course CMIS 320 from Relational Database to Relational Database Concepts and Applications
  • Write a command that will remove Barry from the Student table
  • Write statement to add an attribute, Class to the Student table?

Homework 4Given the relaTons below, create the database tables using SQL DDL(Data DefniTon Language).Assume the Following a±ribute data types:StudentID (integer, primary key)StudentName (25 characters)²acultyID (integer, primary key)²acultyName (25 characters)CourseID (8 characters, primary key)DateQualifed (date)SecTonNo (integer, primary key)Semester (7 characters)S³UDEN³ (StudentID, StudentName)StudentIDStudentName38214Alvaro54907Le±erman66324³roy70542Myra……….²ACUL³Y (²acultyID, ²acultyName)²acultyID²acultyName1123Cooper4237Burgess5115MayQUALI²IED (²acultyID, CourseID, DateQualifed)²acultyIDCourseIDDateQualifed1123CMIS 1029/20141123CMIS 1709/20144237CMIS 4209/20124237CMIS 3209/20135115CMIS 1029/20115115CMIS 1709/2011……….SEC³ION (SecTonNo, Semester, CourseIDSecTonNoSemesterCourseID3115²ALL-2014CMIS 3203116²ALL-2014CMIS 3203117²ALL-2014CMIS 1023118²ALL-2014CMIS 420
Background image of page 1
View the Answer
……..COURSE (CourseID, CourseName)CourseIDCourseNameCMIS 320Relatonal DaTabaseCMIS 102AlgoriThm DesignCMIS 420Advance Relatonal DaTabaseCMIS 170InTroducton To XMLCMSC 100InTro To CompuTer Science……..……….REGIS±RA±ION (STudenTID,SectonNo, SemesTer)STudenTID,SectonNoSemesTer382143117FALL-2014549073117FALL-2014549073118FALL-2014663243116FALL-2014…..Afer creatng The Tables above, wriTe SQL sTaTemenTs To answer The ²ollowing questons.SubmiT your work as a TexT ³le conTaining The 6 SQLsTaTemenTs.a)WhaT is The name o² The ²aculTy member whose ID is 1123?b)WhaT is The smallesT secton number used in The FALL-2014 semesTer?c)How many sTudenTs are enrolled in Secton 3117 o² FALL-2014?d)CreaTe an SQL command ThaT will modi²y The name o² course CMIS 320 ²rom Relatonal DaTabase To Relatonal DaTabase ConcepTs andApplicatonse)WriTe a command ThaT will remove Barry ²rom The STudenT Table²)WriTe sTaTemenT To add an a´ribuTe, Class To The STudenT Table?
Background image of page 2

Show

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"