Question: Create a database with your last name and the last two digit of your student number. (Example, your last name is Green and your

Create a database with your last name and the last two digit of your student number. (Example, your last name

Create a database with your last name and the last two digit of your student number. (Example, your last name is Green and your student number is 112231 means your database name will be green31) 1. Use import tool to import DDL.sql 2. If there is an interruption in importing step-1, then import DDLdrop.sql, else more to step-3 3. Import smallRelations InsertFile.sql for data/rows Perform the following queries: SI a. 5. Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate names in the result. Create a new course "CS-001", titled "Weekly Seminar", with 0 credits. Note: Provide your comment if you are unable to insert those values. Create a section of this course in Fall 2017, with sec_id of 1, and with the location of this section not yet specified. Note: Provide your comments on this query (if it does not affect any row) d. Enroll every student in the Comp. Sci. department in the above section. Delete enrollments in the above section where the student's ID is 12345. e. f. C. Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course? Note: Provide your comment on deletion of primary key in this case. g. Delete all takes tuples corresponding to any section of any course with the word "advanced" as a part of the title; ignore case when matching the word with the title. Marks 1 2 2 1 1 2 1 Submission Information: Create a .sql file with your FirstName_LastName_A1.sql that will contain all your queries. Please add your name and student number as a comment at the top of the file. Upload the completed file in the Assignment-1 dropbox.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

sql CREATE DATABASE yourLastNameyourStudentNumber USE yourLastNameyourStudentNumber Import DDLsql SOURCE DDLsql Import smallRelationsInsertFilesql for ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!