Write a query or queries to print the table description

Assignment Help Database Management System

Reference no: EM131225488

Application: Creating and Populating a Database

Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. View all or part of theMySQL tutorial on Lynda.com to learn how to install and create a database in MySQL. If necessary, install MySQL on your computer. Then, create the tables for tracking the sales in the database shown below. Include all the constraints you consider necessary to maintain the integrity of the database. Then, for each named table, insert the listed data.

CUSTOMERS (ID, NAME(LAST FIRST), ADDRESS, CURRENT BALANCE, CREDIT LIMIT, SALES REP ID)
124	ADAMS	SALLY	481	OAK	LANSING	MI 49224	818.75	1000	3
256	SAMUELS	ANN	215	PETE	GRANT	MI 49219	21.5	1500	6
311	CHARLES	DON	48	COLLEGE	IRA	MI 49034	825.75	1000	12
315	DANIELS	TOM	914	CHERRY	KENT	MI 48391	770.75	750	6
405	WILLIAMS	AL	519	WATSON	GRANT	MI 49219	402.75	1500	12
412	ADAMS	SALLY	16	ELM	LANSING	MI 49224	1817.5	2000	3
522	NELSON	MARY	108	PINE	ADA	MI 49441	98.75	1500	12
567	DINH	TRAN	808	RIDGE	HARPER	MI 48421	402.4	750	6
587	GALVEZ	MARA	512	PINE	ADA	MI 49441	114.6	1000	6
622	MARTIN	DAN	419	CHIP	GRANT	MI 49219	1045.75	1000	3

SALES REPS (ID, NAME(LAST FIRST), ADDRESS, TOTAL COMMISSION, COMMISSION RATE)
3	JONES	MARY	123	MAIN	GRANT	MI 49219	2150	.05
6	SMITH	WILLIAM	102	RAYMOND	ADA	MI 49441	4912.5	.07
12	DIAZ	MIGUEL	419	HARPER	LANSING	MI 49224	2150	.05

ORDERS(ID, ORDER DATE, CUSTOMER, SHIPPING DATE)

12489 02-JUL-11 124 22-JUL-11

12491 02-JUL-11 311 22-JUL-11

12494 04-JUL-11 315 12-JUL-11

12495 04-JUL-11 256 22-AUG-11

12498 05-JUL-11 522

12500 05-JUL-11 124 22-AUG-11

12504 05-JUL-11 522

ORDER LINES (ORDER ID, PART ID, NUMBER ORDERED, QUOTED PRICE)
12489 AX12 11	21.95
12491 BT04 1	149.99
12491 BZ66 1	399.99
12494 CB03 4	279.99
12495 CX11 2	22.95
12498 AZ52 2	12.95
12500 BT04 1	149.99
12504 CZ81 2	325.99

PARTS (PART ID, PART DESCRIPTION, UNITS ON HAND, CLASS, WAREHOUSE NUMBER, UNIT PRICE)
AX12 IRON	104 HW 3	24.95
AZ52 DARTBOARD	20 SG 2	12.95
BH22 CORNPOPPER	95 HW 3	24.95
BT04 GAS GRILL	11 AP 2	149.99
BZ66 WASHER	52 AP 3	39.99
CA14 GRIDDLE	78 HW 3	39.99
CB03 BIKE	44 SG 1	299.99
CX11 BLENDER	112 HW 3	22.95
CZ81 TREADMILL	68 SG 2	349.95

Requirement for the paper:

Write a query or queries to print the table description and the contents of each table, and copy and paste the results to a file called sales.

Write a 1- to 2-page paper describing each constraint you created and why it is necessary.

Reference no: EM131225488

Questions Cloud

Investment strategy of the edithvale retirement fund : Self-Managed Super Funds Case Study. Please provide a review of the current structure and investment strategy of the Edithvale Retirement Fund. Comment on any compliance issues that the fund might currently have and your recommendation on how they ..

How could the process be made reversible : Heat in the amount of 150 kJ is transferred directly from a hot reservoir at TH= 550 K to two cooler reservoirs at T1 = 350 K and T2 = 250 K.

Purchase health insurance : Why or why not? Assuming that she does decide to purchase health insurance, which of the three policies would you recommend and why?

Determine the transresistance transfer function : Find (i) the quiescent drain current IDQ and (ii) the small-signal transistor parameters. - Determine the transresistance transfer function Az f = vo/is.

Write a query or queries to print the table description : Write a query or queries to print the table description and the contents of each table, and copy and paste the results to a file called sales. Write a 1- to 2-page paper describing each constraint you created and why it is necessary.

Firm-wide weighted average cost of capital : Suppose a firm has several divisions, each with a unique area of business. What role does the firm-wide weighted average cost of capital play when determining a project's cost of capital in a given division?

Discuss the special considerations for pitching a blogger : Describe your follow-up plan. Discuss the special considerations for pitching a blogger.

Compute the 16 bit hash for the 32 bit message : 06-20008 Cryptography - Compute the 16 bit hash for the 32 bit message given as hexadecimal number 0xFAB1756E and Show that this modified version is not IND-CPA-secure.

Create preventative control for sungrafix video game company : Create Preventative Controls for SunGrafix, a video game design company. In some cases, the outage impacts identified in the BIA may be mitigated or eliminated through preventive measures that deter, detect, and/or reduce impacts to the system.

User Account

All Pages