Answered step by step
Verified Expert Solution
Link Copied!

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

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus Concepts Through Functions A Unit Circle Approach To Trigonometry

Authors: Michael Sullivan

5th Edition

0137945139, 9780137945139

More Books

Students also viewed these Databases questions

Question

=+LO 8-2 Describe social media and community marketing objectives.

Answered: 1 week ago

Question

(1) Construct a truth table for the following: (x+y)(x+y)

Answered: 1 week ago

Question

In Problems 8596, simplify each expression. (2 1 ) 3

Answered: 1 week ago

Question

Explain the difference between design and operational decisions.

Answered: 1 week ago