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

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

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: 1. Table : ASSIGNMENT D ASSIGNMENT N NMAON DATE MM EMP MUN AiNO AlON CHO AONHOURI NON CHA 35 42 t00…

A: Explanation In SQL, the SELECT query is used to fetch or retrieve the data from the database table.…

Q: How is the underscore character different from the % character in SQL?

A: Difference between underscore character and % character in SQL:

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: How does the CONCAT_WS function provide advantages over the traditional CONCAT function in SQL?

A: CONCAT_WS function is an SQL function that is used to add two or more strings together with the…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: In the following PL/SQL block, determine the values and data types for each of the following cases:…

A: conclusion:In the nested block:v_customer holds a numeric value of 201 with a data type of…

Q: Write the SQL queries for the following questions and show results. List all the section numbers of…

A: In the structured query language, the query consists of the three clauses that are used to retrieve…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the count of employees…

A: SELECT COUNT(*)FROM employees_tableWHERE department = "Marketing";

Q: plz help with the following use oracle sql or sql live The procedure should satisfy the following…

A: Answer is given below .

Q: What are the advantages of using table-valued parameters in SQL functions

A: Table-valued parameters (TVPs) in SQL are a powerful feature that allows developers to send multiple…

Q: How does the FORMAT function assist in converting date and time values into specific string formats…

A: The FORMAT function in SQL is used to convert date and time values into specific string formats. It…

Q: Code three tests: 1) for a student who has courses 2) for student who does not have courses 3) a…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: How does the PARSE function differ from the TRY_PARSE function in SQL when converting data types?

A: Effective database administration in the world of SQL programming depends on the capacity to alter…

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Question

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
ТЕXTBOOK
UNITS
DEPARTMENT

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Operations used in relational algebra expressions

VIEW

Relational algebra expression and SQL statement

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Please help, I know it's hard but no one else is willing to try and I am lost and spent three days on this so far. Write a query to display the author ID, first and last name for all authors who have ever written a book with the subject Programming. Sort the results by author's last name (Figure P7.106). In the SQL Query do the following Select clause: Display the columns stated in the problem statement From clause: AUTHOR table Where clause: authors who have ever written a book with the subject Programming. (Hint: Subquery) Order by clause: Sort the results by author last name
MICROSOFT SQL SERVER ONLY CURSOR T-SQL Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT.
What use cases are best suited for the CROSS APPLY function in SQL?
Write all the sql code (including create, insert and select)
Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to the state of Florida
ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
Please help with pl/sql block!
How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
In what situations might the SOUNDEX function be useful in SQL when querying text data?
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.