Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 10 Weeks Ago, 5 Days Ago |
Questions Answered: | 4870 |
Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
I need a paper to be writed,2 pages,double spaced.Below is the requirement.I need this paper by September 12.Thank you
Â
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 | Â |
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.
Submit your assignment in the online classroom by Day 7.
Use this rubric to estimate your grade on the assignment.
-----------