I urgently need assistance with the following attached assignment.
I urgently need assistance with the following attached assignment.
Application: Creating and Populating a DatabaseSuppose you have a small retail store and decide to create a database to track sales. Youhave information about recent sales that you want to use for testing the database. View all orpart of theMySQL tutorial on Lynda.comto learn how to install and create a database inMySQL. If necessary, install MySQL on your computer. Then, create the tables for tracking thesales in the database shown below. Include all the constraints you consider necessary tomaintain 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 I124ADAMSSALLY481 OAKLANSINGMI 49224818.75256SAMUELSANN215 PETEGRANTMI 4921921.5311CHARLESDON48 COLLEGEIRAMI 49034825.75315DANIELSTOM914 CHERRYKENTMI 48391770.75405WILLIAMSAL519 WATSONGRANTMI 49219402.75412ADAMSSALLY16 ELMLANSINGMI 492241817.5522NELSONMARY108 PINEADAMI 4944198.75567DINHTRAN808 RIDGEHARPERMI 48421402.4587GALVEZMARA512 PINEADAMI 49441114.6622MARTINDAN419 CHIPGRANTMI 492191045.75
SALES REPS (ID, NAME(LAST FIRST), ADDRESS, TOTAL COMMISSION, COMMISSION RATE)3JONESMARY123 MAINGRANTMI 492192150.056SMITHWILLIAM102 RAYMONDADAMI 494414912.5.0712DIAZMIGUEL419 HARPERLANSINGMI 492242150.05ORDERS (ID, ORDER DATE, CUSTOMER, SHIPPING DATE)12489 02-JUL-11 124 22-JUL-1112491 02-JUL-11 311 22-JUL-1112494 04-JUL-11 315 12-JUL-1112495 04-JUL-11 256 22-AUG-1112498 05-JUL-11 52212500 05-JUL-11 124 22-AUG-1112504 05-JUL-11 522ORDER LINES (ORDER ID, PART ID, NUMBER ORDERED, QUOTED PRICE)12489 AX12 1121.95
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
