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: The following figure is part of a university database. LNAME and FNAME stands for last name and…

A: Since you have posted a question with multiple sub-parts, according to the company's policy we will…

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: es in relational algebra. Find the username of users who are from ‘Muscat’. Find the IDs of pictures…

A: 1. Find the username of users who are from ‘Muscat’ SELECT username FROM users where place='Muscat'…

Q: Write queries in SQL to answer each of the following questions:…

A: Below are the required queries: As per our company guidelines we are supposed to answer only first 3…

Q: Write queries in SQL to answer each of the following questions: 1. Find all students in Comp.…

A: SQL is a standard language for storing, manipulating and retrieving data in databases.

Q: Develop a SQL code: The resort manager wants to know the details of the guest who brought their pet…

A: Here have to determine about SQL query for given problem statement.

Q: 12. Display the name, job, and salary for all employees whose job is Clerk or Analyst and their…

A: Use in operator to check for multiple values and not in to exclude values. Use all operator where…

Q: SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: Obtain the…

A: Note: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly repost…

Q: Write queries in SQL to answer each of the following questions:…

A: Ques 1. Find all instructors in Finance department who have taught some course in 2008. Tables…