Observe the HAPPY INSURANCE DATABASE: This database will be used for the following questions citing tables...
Observe the HAPPY INSURANCE DATABASE:
This database will be used for the following questions citing
tables from the HAPPY INSURANCE database.
Write an SQL query for the HAPPY INSURANCE database that will retrieve the name of each agent that has a rating lower than 100, as well as, whose name starts with an “A”.
Homework Answers
For given statement, SQL query will be like this:
Select Name
From Agent
Where agent.rating<100 and agent.name = 'a%';
Add Answer to:
Observe the HAPPY INSURANCE DATABASE:
This database will be used for the following questions citing
tables...
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y dat...
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...
7. Using the provided schema of a Purchase Order Administration database, write the following queries in...
7. Using the provided schema of a Purchase Order Administration database, write the following queries in SQL. (In the schema, bold attributes are primary keys and italicized attributes are foreign keys.) SUPPLIER (SUPNR, SUPNAME, SUPADDRESS, SUPCITY, SUPSTATUS) SUPPLIES (SUPNR, PRODNR, PURCHASE_PRICE, DELIV_PERIOD) PRODUCT (PRODNR, PRODNAME, PRODTYPE, AVAILABLE_QUANTITY) PO_LINE (PONR, PRODNR, QUANTITY) PURCHASE_ORDER (PONR, PODATE, SUPNR) 7d) Write a nested SQL query to retrieve the supplier number, supplier name, and supplier status of each supplier who has a higher supplier status...
A state-wide land tax assessment database has two tables: LandParcel that stores a set of land...
A state-wide land tax assessment database has two tables: LandParcel that stores a set of land parcels, and ZoningTypes that stores a set of zoning codes and zoning types. The LandParcel table has 5 columns: ParcelNumb as text indicating each parcel's unique number defined by the State, Zoning as an integer number indicating the numerical code of a zoning type and each land parcel belongs to one zoning type, Owner First Name and Owner Last Name as text indicating the...
Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables...
Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables and include both one-to-many and many-to-many relationships. Be sure to include some numeric and/or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your database with at least 30 records in the main table(s), and whatever is needed in related tables. Submit the following: • a short description of the purpose of the database and what the...
Part II: Group-by and subqueries The following questions use the Spy and Sailors database. Write the...
Part II: Group-by and subqueries The following questions use the Spy and Sailors database. Write the SQL for the following queries. 1) List the sailor id and name for each sailor who has reserved two different red boats. Make sure that each sailor id/name is listed at most once. You must use group by/having. 2) List the missions and their status for each team. 3) For each country in agent, list the country and the count of agents in the...
The goal is to write several SQL queries that will answer questions over the database used...
The goal is to write several SQL queries that will answer questions over the database used by the imaginary Sierra Peak Climbing Club (SPCC), an organization whose members climb the mountain peaks of California’s Sierra Nevada mountain range. The database maintained by the SPCC has four tables: PEAK (NAME, ELEV, DIFF, MAP, REGION) CLIMBER (NAME, SEX) PARTICIPATED (TRIP_ID, NAME) CLIMBED (TRIP_ID, PEAK, WHEN_CLIMBED) The database tables have the following semantics: • PEAK gives information about the mountain peaks that the...
The goal is to write several SQL queries that will answer questions over the database used...
The goal is to write several SQL queries that will answer questions over the database used by the imaginary Sierra Peak Climbing Club (SPCC), an organization whose members climb the mountain peaks of California’s Sierra Nevada mountain range. The database maintained by the SPCC has four tables: PEAK (NAME, ELEV, DIFF, MAP, REGION) CLIMBER (NAME, SEX) PARTICIPATED (TRIP_ID, NAME) CLIMBED (TRIP_ID, PEAK, WHEN_CLIMBED) The database tables have the following semantics: • PEAK gives information about the mountain peaks that the...
Create the database and tables for the database. Show all SQL statements. Include primary and foreign...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
The Ch07_ConstructCo database stores data for a consultingcompany that tracks all charges to projects. The...
The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch07_ConstructCo database are shown in Figure P7.1.Note that the ASSIGNMENT table in Figure P7.1 stores the JOB_CHG_HOUR values as an attribute (ASSIGN_CHG_HR) to maintain historical accuracy of the data. The JOB_CHG_HOUR values are likely to change over time. In fact, a JOB_CHG_ HOUR change will be...
Consider the following database and answer the questions below. a) Write the SQL statement the displays...
Consider the following database and answer the questions below. a) Write the SQL statement the displays the names of the students who have enrolled in the Database Systems course b) Write the SQL statement that displays a list of the students whose names start with 'S' c) Write the SQL statement that displays the Student ID, Student Name, Course ID, and Grade for students that passed at least one course with a grade better than B+ (i.e. A-, A, and...
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...
A state-wide land tax assessment database has two tables: LandParcel that stores a set of land parcels, and ZoningTypes that stores a set of zoning codes and zoning types. The LandParcel table has 5 columns: ParcelNumb as text indicating each parcel's unique number defined by the State, Zoning as an integer number indicating the numerical code of a zoning type and each land parcel belongs to one zoning type, Owner First Name and Owner Last Name as text indicating the...
Create the database and tables
for the database. Show all SQL statements. Include primary and
foreign keys. Insert data into each table. Show select statements
and display the output of each table. Note:Student’s name must be
inserted into table as part of the data! Perform the SQL below:
Query one table and use WHERE to filter the results. The SELECT
clause should have a column list, not an asterisk (*). State the
purpose of the query; show the query and...
Consider the following database and answer the questions below. a) Write the SQL statement the displays the names of the students who have enrolled in the Database Systems course b) Write the SQL statement that displays a list of the students whose names start with 'S' c) Write the SQL statement that displays the Student ID, Student Name, Course ID, and Grade for students that passed at least one course with a grade better than B+ (i.e. A-, A, and...
Most questions answered within 3 hours.
-
A smoke detector system uses two devices, A and B. If smoke is
present, the probability...
asked 44 minutes ago -
Your division head has assigned another important project to you
and your team. This project is...
asked 9 minutes ago -
Under normal use conditions, the Mean Time To Failure of a
heating coil can be modeled...
asked 1 hour ago -
Consider the probability that fewer than 34 out of 116 CDs will
be defective. Assume the...
asked 24 minutes ago -
4J Manufacturing Company uses a job order cost accounting system
and keeps perpetual inventory records. Prepare...
asked 13 minutes ago -
Please write code in C++
using recursive function
Write a program that computes the sequence of...
asked 11 minutes ago -
What is 345 as an unsigned decimal number? It is 34
with subscript of 5. Not...
asked 28 minutes ago -
I've been struggling with these homework questions. Any help
would be greatly appreciated
1. For the...
asked 26 minutes ago -
Read the In-Depth Integrative Case 1.2 (Pharmaceutical
Companies, Intellectual Property, and the Global AIDS Epidemic) in...
asked 25 minutes ago -
Consider a mass-spring system. The spring has a spring constant
of 2.27e+3 N/m. On the end...
asked 31 minutes ago -
People are most likely to believe their ancestors play an active
role in their lives in...
asked 1 hour ago -
A student holds a ruler by one end (x=0 where the student holds
it). The student...
asked 1 hour ago