User Account

All Pages

Assignment increase text size

Assignment Help Basic Computer Science
Reference no: EM13656518

Assignment Increase text size
Decrease text size
Print Page

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.

Reference no: EM13656518

Questions Cloud

Explain the difference between bounded : Explain the difference between bounded and unbounded media, and provide examples of each that are commonly found in homes, schools, or area businesses.
Estimate the value of the mean spending : Normal distribution on the population to estimate the value of the mean spending per day - estimate for the mean amount spent per day by a family of four visiting Niagara Falls.
A future space station in orbit about the earth : A future space station in orbit about the earth is being powered by an electromagnetic bean from the earth. The beam has a cross-sectional area of 135m2 and transmits and average power of 1.20*104W. What is the intensity of this beam, the maximum val..
Explain how erp meets the needs of the stakeholders : Explain how ERP meets the needs of the Stakeholders
Assignment increase text size : Assignment Increase text size
Describe is the focal length of the second lens : Object O1 is 15.2 cm to the left of a converging lens with a 11.8-cm focal length. A second lens is positioned 10.0 cm to the right of the first lens and is observed to form a virtual image at the position of the original object O1.
A transparent oil with index of refraction : A transparent oil with index of refraction 1.29 spills on the surface of water (index of refraction 1.33), producing a maximum of reflection with generally incident red light (wavelength 700 nm in air). Assuming the maximum occurs in the first order;..
What is the price elasticity of demand compares : What is the price elasticity of demand compares the percent change in quantity demanded relative to the percent change in price - this is done by taking the change in quantity demanded by the change in price.
Windows operating system : Windows operating system

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Create a customer experience strategy

Include components of customer service model reognized within your text. How would you use them to create a customer experience strategy?

  Write a program that uses an arraylist of parameter type

For example, if "elmore" is the search target then any contact where the first name, last name, phone number, or email address contains "elmore" should be returned for display or deletion. Use a "for each" loop to iterate through the ArrayList.

  Explain what occurs if instruction going through pipeline-lb

Consider processor with six stages: IF(instruction fetch), DA(instruction decode), CO(calculate operands addresses), FO(fetch operands), EX(instruction execution), WB(write results). Explain briefly what occurs in each stage when instruction going ..

  Design a combinational circuit

Design a combinational circuit that accepts a 4-bit number and output a 3-bit binary number that approximates the square root of the number

  How is the principle of inclusion and exclusion related

How is the principle of inclusion and exclusion related to the rules for manipulation and simplification of logic predicates you learned in Ch. 2

  What u think about the article database fight funding cuts

What u think about the article Database fight funding cuts

  What takes place during the coding activity of the

what occurs during the coding activity of the development phase? what best practices should a development manager use

  Explain implications of copyrights on usage of web site

Study and explain copyright implications associated to Web site development. Write down minimum of 350 words explaining the implications of copyrights on usage of content on Web site.

  Write a constraint for policy using pandey

The method willaccept returns 1 if the named process will accept messages, and 0 otherwise. Write a constraint for this policy using Pandey and Hashii's policy constraint language as described in the first example in Section 4.5.1.

  The smallest of several nonnegative integers

Write a Javascript that finds the smallest of several nonnegative integers. Assume that the first value read specifies the number of values to be input from the user.

  Explaining minor or major virus threats

Write down two recent virus threats, are they minor or major threats? What software would you utilize to remove these threats?

  Write a mips program that will alter an array of 100 doubles

Write a MIPS program that will alter an array of 100 doubles. No input or output is required. We will assume somebody else did it. Your program modifies the elements in the array as described

Free Assignment Quote

Assured A++ Grade

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd