Question: This assignment is about using SQL to write queries for ACCESS. The university database has the following schema. This is intended to be used for

This assignment is about using SQL to write queries for ACCESS.

This assignment is about using SQL to write queries for ACCESS. The

The university database has the following schema. This is intended to be used for a single year and semester. Primary keys are underlined. The relationships between tables are as you know. STUDENT(SSN, SNAME, MAJOR, DOB, ADDRESS) COURSE (CID, CNAME, CREDIT) ENROLLED (SSN, CID, GRADE) FACULTY (SSN, NAME, DOB) TEACHING (FACULTYSSN, CID) PREQ(CID, PREREQUISITECID, PASSINGGRADE) Write each query in SQL: (a) What are the names of students who enrolled in a course without enrolling in that course's prerequisite? (b) What is the most popular major? (c) Retrieve a summary: for each prerequisite course id, show the number of courses that require it as a prerequisite course. (d) What are the names of courses that have at least two prerequisites? (e) What are the names of courses that have less than five students enrolled in? (f) What are the names of faculties who teach a course and also its prerequisite course? (g) Write a series of SQL statements for creating the university database completely. Each statement ends with a semicolon. The statements need to be in a proper order, so that the foreign key referent exists before the foreign key declaration. Please use appropriate data types

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

This assignment is about using SQL to write queries FOR ACCESS. FOR PART D,E,F The university database has the following schema. This is intended to be used for a single year and semester. Primary...

CIS3400 Assignment #3 SQL Due: April 18, 2017 Deliverable: Only PDF document submitted to Blackboard Please note: This assignment is about using SQL to write queries. Late submission or handwriting...

This assignment is about using SQL to write queries. The university database has the following schema. This is intended to be used for a single year and semester. Primary keys are underlined. The...

This assignment is to give you practice using SQL. It uses the university schema shown below. The boxes are entities (tables), the table name is at the top in the blue box, the attributes are shown...

Laboratory Exercise 2 Creating and Using a New Database in Access 2 0 1 0 or higher versions Section B: In this section create a New Music Database in Access 1 0 or higher version, given the...

takes ID course id sec id semester year grade student ID name dept_name tof_cred section course_id sec_id semester year building room_number time_slot_id course course_id title dept_name credits...

Data Model: We need to store information about university management system; The university keeps track of each National ID number students name, student number, current address and phone, address...

introduction to database Limkokwing University of Creative Technology AIDB124/BIDB124 Introduction to Database Faculty : Information & Communication Technology Progam/class Name : INTY1S2, MSEY1S2,...

The percentages of female high-school graduates who enrolled in college are given in the third column of Table 1. (A) Let x represent time (in years) since 1970, and let y represent the corresponding...

Verify the expression given for '2 in the proof of Theorem 6.5.

Brief Exercise 15-18 Calculating the Times-Interest-Earned Ratio Paxton Company provided the following income statement for last year: Sales $87,021,000 Cost of goods sold 62,138,249 Gross margin...

Ertries for Stock Livestres. On donds, and select Stock Scorus Induzsics Inc. buy and als intents as part of its ongoing cash management. The following comment transactions were completed during the...

=+What forms of industrial action are common?

=+If there are disagreements over the meaning or application of the terms of the contract, how are they determined?

=+ Does the government play an active role in negotiations? Strikes and