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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter3: Creating Tables

Section: Chapter Questions

Problem 4SCG

See similar textbooks

Similar questions

My update button does not work, when i press edit to update data. i get an unidentified index. Plz help! EDIT_PRODUCT.PHP <?php // Get the product data $category_id = $_POST['category_id']; $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $product_id = $_POST['productID']; // Validate inputs if (empty($code) || empty($name) || empty($price)) { $error = "Invalid product data. Check all fields are try again."; include('error.php'); } else { // If valid, add the product to the database require_once('database.php'); $query = "UPDATE products SET categoryID = $category_id, productCode = $code, productName = $name, listPrice = $price WHERE productID = $product_id"; $db->exec($query); // Display the Product List page include('index.php'); } EDIT_PRODUCT_FORM.PHP <?php // get post values $product_id = $_POST['product_id']; // This is the drop down menu next to 'Category:' require('database.php'); $query = 'SELECT * FROM categories ORDER BY…
You will be using the Colonial Adventure Tours database. List the trip name of each trip that has the type Hiking and that has Harley Devon as a guide.
You will need to add a CREATE DATABASE and USE database statement at the beginning of the script in the file of the Sample Database in order for SQL Script in the Sample Database to execute/run correctly If you discover any ambiguity between the written Metadata and the actual table definitions, the path that I recommend is to use the SHOW TABLES Statement and the DESCRIBE Table Statement to eliminate any ambiguity between the written Metadata and the actual Metadata. CustOrders.sql download Aggregation Part of the Exercise . Select the maximum price of any orders in the items_ordered table. Hint: Select the maximum price only. . Select the average price of all of the orders that were purchased in the month of Dec. . Return the total number of rows in the orders table? . For all of the tents that were ordered in the orders table, what is the price of the lowest tent? Hint: Your query should return the price only. Group By Exercises . How many people are…
You have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would your create for the table?
CREATE TABLE test( test_id INTEGER PRIMARY KEY, test_name varchar2 (255) ,t_date DATE, t_result varchar2(255));ALTER TABLE test ADD (t_time varchar2(1));INSERT INTO test values ('5454','corona','monday','11:15PM','positive'); (6567,'corona','sunday','10:50AM','negative');
Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day
You are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the database and table objects exactly as depicted below.STUDENTSSTUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEYSTUDENT_NAME VARCHAR(40) NOT NULLSTUDENT_SURNAME VARCHAR(40) NOT NULLMODULESMODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYMODULE_NAME VARCHAR(40) NOT NULLMODULE_CREDIT SMALLINT NOT NULLSTUDENT_MODULESSTUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES STUDENTS(STUDENT_ID)MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES MODULES(MODULE_ID)LECTURERSLECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEYLECTURER_NAME VARCHAR(40) NOT NULLLECTURER_SURNAME VARCHAR(40) NOT NULL LECTURER_MODULESMODULE_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES MODULES(MODULE_ID)LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCES
Write an anonymous block which updates the .Physician table.(As you can not update the .Physician Table, you will have to create your own table based on the structure and contents of the Physician Table). Use named parameters to get values for Phys_ID, Phys_name, Phys_phone, and Phys_speciality. If the value for Phys_ID is in the Physician Table, Update the values of the remaining columns. If the Phys_ID is not in the Physician Table, INSERT a row into the Physician Table with those values. - Hint: Use variables for each of the columns above and assign a named parameter to each of them. Then use the variable in the rest of the block. - Write a simple driver to test the block with a Phys_ID that is in the Physician Table and a Phys_ID that is not in the Physician Table. Physician Table Phys_ID Phys_Name Phys_Phone Phys_Specialty ----------- ------------------------…
The view V_PAT_ADT_LOCATION_HX returns one row of information per bed stay. The column ADT_DEPARTMENT_ID is the ID of the bed's department. The column ADT_DEPARTMENT_NAME is that department's name. Two distinct departments can potentially share the same name. Which of the following queries would return exactly one row per department and display the name of the department? A. SELECT ADT_DEPARTMENT_ID, MIN(ADT_DEPARTMENT_NAME) FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID B. SELECT MIN(ADT_DEPARTMENT_ID), ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID C. SELECT 'ADT_DEPARTMENT_ID', ADT_DEPARTMENT_NAME FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID D. SELECT ADT_DEPARTMENT_ID, 'ADT_DEPARTMENT_NAME' FROM V_PAT_ADT_LOCATION_HX GROUP BY ADT_DEPARTMENT_ID
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form. LOCATION (LOCATION_NUM, LOCATION_NAME, (UNIT_NUM, SQR_FT, BDRMS, BATHS, CONDO_FEE))

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science