Topic: masters in public health…………………………………… 1 answer below »

Topic: masters in public health…………………………………… 1 answer below ».

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.comto 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 MI49224 818.75 1000 3 256 SAMUELS ANN 215 PETE GRANT MI49219 21.5 1500 6 311 CHARLES DON 48 COLLEGE IRA MI49034 825.75 1000 12 315 DANIELS TOM 914 CHERRY KENT MI48391 770.75 750 6 405 WILLIAMS AL 519 WATSON GRANT MI49219 402.75 1500 12 412 ADAMS SALLY 16 ELM LANSING MI49224 1817.5 2000 3 522 NELSON MARY 108 PINE ADA MI49441 98.75 1500 12 567 DINH TRAN 808 RIDGE HARPER MI48421 402.4 750 6 587 GALVEZ MARA 512 PINE ADA MI49441 114.6 1000 6 622 MARTIN DAN 419 CHIP GRANT MI49219 1045.75 1000 3 SALES REPS (ID, NAME(LAST FIRST), ADDRESS, TOTAL COMMISSION, COMMISSION RATE) 3 JONES MARY 123 MAIN GRANT MI49219 2150 .05 6 SMITH WILLIAM 102 RAYMOND ADA MI49441 4912.5 .07 12 DIAZ MIGUEL 419 HARPER LANSING MI49224 2150 .05 ORDERS(ID, ORDER DATE, CUSTOMER, SHIPPING DATE) 1248902-JUL-1112422-JUL-11 1249102-JUL-1131122-JUL-11 1249404-JUL-1131512-JUL-11 1249504-JUL-1125622-AUG-11 1249805-JUL-11522 1250005-JUL-1112422-AUG-11 1250405-JUL-11522 ORDER LINES (ORDER ID, PART ID, NUMBER ORDERED, QUOTED PRICE) 12489AX1211 21.95

 

. WITH nursingessayswriters.com AND GET AN AMAZING DISCOUNT!

The post Topic: masters in public health…………………………………… 1 answer below » first appeared on nursingessayswriters.com.


Topic: masters in public health…………………………………… 1 answer below » was first posted on September 18, 2020 at 3:11 pm.

©2019 “nursingessayswriters.com”. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at ukbestwriting@gmail.com

 

“Are you looking for this answer? We can Help click Order Now”

The post Topic: masters in public health…………………………………… 1 answer below » first appeared on Nursing Essays Writers.


 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

The post Topic: masters in public health…………………………………… 1 answer below » first appeared on nursing writers.

Topic: masters in public health…………………………………… 1 answer below »

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *