Write a query or queries to print the table description

Assignment Help Database Management System

Reference no: EM131201499

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 the MySQL 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

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.

Attachment:- Assignment.rar

Reference no: EM131201499

Questions Cloud

Is the leader inspiring or uninspiring : Take on the role of a member of an organization's Board of Directors and critically examine the CEO profile from the biographic articles you created in Assignment 1. Then, post a brief summary of your article. Address the following in your summary..

Legal issues in information security and incident response : The news media often publicizes cyber crime activities. Discuss one of the cyber crimes you have heard about, explaining the crime along with how it was discovered and investigated? What was the outcome? If the investigation is ongoing, based on t..

It auditing and security risk management : At this point, you have a pretty clear understanding that although PVSS has a desire to do things in sound and secure fashion, it is not able to consolidate efforts and focus its attention in appropriate places.

Calculate the motor speed : A 200V dc motor is loaded by a constant torque of 10 NM. The armature resistance of the motor is 2Ω, and the field constant Kφ=2.5V s. Calculate the motor speed.

Write a query or queries to print the table description : 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. Write a query or queries to print the table description and the contents o..

Discuss any other concerns about the web developer : Describe the ethical issues involved in this situation. Discuss any other concerns about the web developer/consultant's strategies. Explain some recommendations that you would make to the shelter.

Problem regarding the complement value : What is the numeric range of a 16-bit two's complement value? A 16-bit excess notation value? A 16-bit unsigned binary value?

Draw up a list of all the expenses the business : Draw up a list of all the expenses the business would incur and indicate the source of the information you would need to calculate the figures for the forecast cash outflows of the business.

Question-internet service provider : Question: Internet Service Provider An Internet service provider has three different subscription packages for its customers: Package A: $9.95 per month for 10 hours access. Additional hours are $2.00 per hour

Reviews

len1201499

9/10/2016 5:39:31 AM

The written report is 1-2 pages long. It is free of spelling mistakes and grammatical errors, uses complete sentences, and follows the APA style. Description of Constraints- This part of the report describes the constraints created. Necessity of Constraints-This part of the report describes the necessity of each constraint including foreign key, primary key, unique, not null and check.

Write a Review

Required(*) Message

User Account

All Pages