Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
sql CREATE DATABASE yourLastNameyourStudentNumber USE yourLastNameyourStudentNumber Import DDLsql SOURCE DDLsql Import smallRelationsInsertFilesql for ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started