Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
12
315
DANIELS
TOM
914
CHERRY
KENT
MI 48391
770.75
750
405
WILLIAMS
AL
519
WATSON
402.75
412
16
ELM
1817.5
2000
522
NELSON
MARY
108
PINE
ADA
MI 49441
98.75
567
DINH
TRAN
808
RIDGE
HARPER
MI 48421
402.4
587
GALVEZ
MARA
512
114.6
622
MARTIN
DAN
419
CHIP
1045.75
SALES REPS (ID, NAME(LAST FIRST), ADDRESS, TOTAL COMMISSION, COMMISSION RATE)
JONES
123
MAIN
2150
.05
SMITH
WILLIAM
102
RAYMOND
4912.5
.07
DIAZ
MIGUEL
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
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
BH22 CORNPOPPER
95 HW 3
BT04 GAS GRILL
11 AP 2
BZ66 WASHER
52 AP 3
39.99
CA14 GRIDDLE
78 HW 3
CB03 BIKE
44 SG 1
299.99
CX11 BLENDER
112 HW 3
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.
Based on your understanding of "natural monopolies," do you think the cable industry today should be considered a natural monopoly? Why or why not? (Based on your reading, research and analysis in the textbook, and other relevant sources)
Predict the long-term use of both open source and proprietary software models and explain which software model has more legal implications/issues than the other.
Pick a network address from the list below. Everybody must pick a unique network address and number of subnet. Please reply to the Subnetting Discussion Topic under Week 3 Discussions with your selection. Don't select a network address that..
If no multivalued attributes exist and no partial dependencies exist in a relation, what normal form is the relation?
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a what?
Calculate the net expected value for the project risks and opportunities cited above. How much should you plan for your contingency reserve budget based on the above?
Describing your selected operations research technique. You must explain the technique, assumptions and limitations of method, the kinds of problems
Describe attribute minimization. Explain what would happen if you tried to validate a page containing instances of attribute minimization. Propose a solution to this problem.There are many reasons to validate your Web design. Select one of these reas..
Distinguish between the concepts of convergence, signal strength, and attenuation. Describe basic digital encoding techniques.
Provide a real-life example of a software application that illustrates the different types of adaptors needed to support sequential composition and a real-life example of a software application that illustrates the different types of adaptors need..
Describe in scholarly detail why knowledge management systems would be so important to a modern organization where the organization would initiate.
What interval should be scheduled for maintenance to minimize the overall equivalent annual cost? The interest rate is 8% per year.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd