You need to create the Store Sales database using the scripts under the Course Resources. Using the Store Sales database, create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, stat and zip code for each customer. Look at the attached sample output and match your results. Name Location Zip John Brown 123 Main Street Charlotte, NC 28226 Cynthia Green 345 Salem Drive Waxhaw, NC 28173 Steve White 6006 Bollar Court Charlotte, NC 28277 Gail Black 4000 Woodfox Road Monroe, NC 28110 28226 80119 Doreen Blue 5677 Seth Drive Charlotte, NC Sean Egen 1290 Zenby Drive Denver, co 6 rowa selected

You need to create the Store Sales database using the scripts under the Course Resources. Using the Store Sales database, create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, stat and zip code for each customer. Look at the attached sample output and match your results. Name Location Zip John Brown 123 Main Street Charlotte, NC 28226 Cynthia Green 345 Salem Drive Waxhaw, NC 28173 Steve White 6006 Bollar Court Charlotte, NC 28277 Gail Black 4000 Woodfox Road Monroe, NC 28110 28226 80119 Doreen Blue 5677 Seth Drive Charlotte, NC Sean Egen 1290 Zenby Drive Denver, co 6 rowa selected

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 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
Project 4 : Working On University Data Set Project: Working on university dataset Industry: Education Problem Statement: How to improve the teaching process of a university Topics: In this PL SQL project you have the Student and Staff data in tables. You will create the Course table and insert data into it. Then you will join the three tables and analyze the data. This includes coming up with all the courses with corresponding students and the teachers associated. Then finally you will create a detailed report on the teaching structure and ways to improve it. Highlights Inserting data into the table and joining tables Querying the data for various conditions Prepping the data for analysis.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
The Reporting and Analysis Department has a database containing tables that hold summarized data to make report generation simpler and more efficient. They want to schedule some jobs to run nightly to update summary tables. Create two procedures to update the following tables (assuming that existing data in the tables is deleted before these procedures run): Create the PROD_SALES_SUM_SP procedure to update the BB_PROD_SALES table, which holds total sales dollars and total sales quantity by product ID, month, and year. The order date should be used for the month and year information. Create the SHOP_SALES_SUM_SP procedure to update the BB_SHOP_SALES table, which holds total dollar sales by shopper ID. The total should include only product amounts—no shipping or tax amounts. The BB_SHOP_SALES and BB_PROD_SALES tables have already been created. Use the DESCRIBE command to review their table structures. Run pl/sql block to execute and present results for both procedures.
The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…
Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name, balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin