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

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

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 small RelationsInsertFile.sql for data/rows

Perform the following queries:

SI

Marks

a.

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.

1

2

2

b. Create a new course "CS-001", titled "Weekly Seminar", with 0 credits.

Note: Provide your comment if you are unable to insert those values.

c. Create a section of this course in Fall 2017, with sec_id of 1, and with the location of this section not yet specified.

d. Enroll every student in the Comp. Sei. department in the above section.

c.

Note: Provide your comments on this query (if it does not affect any row)

Delete enrollments in the above section where the student's ID is 12345.

f. 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.

1

1

2

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.

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.

1

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of