The following figure is part of a university database. LNAME and FNAME stands for last name and first name, respectively. Both CNUM and CNO stand for course number. CNAME stands for course name. Specify the following queries in both relational algebra expression and SQL state- ments: 1) List the names and majors of all students who live in the city of Fullerton. 2) List the course number (CNUM), course name (CNAME) and number of units (UNITS) of each course that the student "Mary Willson" has enrolled. 3) For the course number "CPSC332", list the names of the studens who enrolled in the course. 4) For the students who live in in the city of either Fullerton or Brea, count the number of students in each city. 5) List the names of all students who live in Fullerton and do not enroll in any courses. STUDENT SSN FNAME LNAME DBIRTH ADRRESS CITY MAJOR ENROLL SNO CNO GRADE COURSE CNUM CNAME ТЕХТВOOK UNITS DEPARTMENT

The following figure is part of a university database. LNAME and FNAME stands for last name and first name, respectively. Both CNUM and CNO stand for course number. CNAME stands for course name. Specify the following queries in both relational algebra expression and SQL state- ments: 1) List the names and majors of all students who live in the city of Fullerton. 2) List the course number (CNUM), course name (CNAME) and number of units (UNITS) of each course that the student "Mary Willson" has enrolled. 3) For the course number "CPSC332", list the names of the studens who enrolled in the course. 4) For the students who live in in the city of either Fullerton or Brea, count the number of students in each city. 5) List the names of all students who live in Fullerton and do not enroll in any courses. STUDENT SSN FNAME LNAME DBIRTH ADRRESS CITY MAJOR ENROLL SNO CNO GRADE COURSE CNUM CNAME ТЕХТВOOK UNITS DEPARTMENT

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Task 4: The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column. Task: Find all travels where an above average discount was applied. (SQL Database Test)
Determine which types of books are currently available in the current inventory. Each category should only be included once.
73/quizzes/3522244/take You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are developing a new marketing campaign and need to know where the customers who purchase these products live. Develop a query to include these attributes in this order: the product name, the sales ship-to country, and the number of cities that each product has been shipped to. Use the AS keyword to temporarily rename the ship-to country attribute as "Country," the product name as "Product," and name the aggregate column as "Number of Cities." You want to include only coffee and espresso products. Add restrictions to the query output in this order: product names that include the pattern "coffee" and product names that end with the pattern "espresso." Sort the query output by "Product" and then by “Number of Cities." The output of this query will become the Coffee Products report. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the…
Query: List the IDs of the tutors who are currently tutoring more than one student
Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors' telephone number and address On this day in the suburbs of the city
How are the column heading labels in a result table changed?
Please summarise data input field selection criteria. What conditions would allow breaking these rules?
where 'Where clause' used ?
List the employee’s first and last name and the department name he/she does NOT belong topurchasing, shipping, or sales departments. Use Not operator.
Which clause of a SQL Select statement is required if we want to display aggregate data by category such as total population by state, department, etc.? Question 40 options: 1) GROUP BY 2) ORDER BY 3) WHERE 4) FROM 5) SELECT
note: using bootstrap, need to create the section Fetured Bikes 2021 Best bike collection
Create a list of all number data types. SQL