User Account

All Pages

Creating and populating a database

Assignment Help Basic Computer Science
Reference no: EM131204516

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

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: EM131204516

Questions Cloud

Example of binary bypass and binary choice : What is a real life example of Binary bypass and Binary choice.
Schedule of activities to prepare for training : Continuing with the paper developed in Weeks One, Two, and Three, add an additional 2 to 3 pages (700 to 1,050 words) describing your plans for training employees and preparing them for system changeover. Include the following:
What weaknesses were found in the security screening methods : What weaknesses were found in the security screening methods used prior to the 9-11 attacks?- What other weaknesses/failures were cited as contributing to the 9-11 attacks?
What is the implication of a particular teaching strategy : What is the implication of a particular teaching strategy, technique, or methodology in the learning process of English Language Learners in the classroom?
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..
What club size maximizes total utility produced by the club : Assuming the club chooses G optimally given its member ship; calculate the loss due to membership of a club with suboptimal size.
Database models and legacy systems : Databases evolved from flat file systems. As technology advanced, the limitations of flat files became evident. The database model has evolved to meet the business needs of the time. As the information age evolved, organizations realized there was..
How research questions were supported by your research : Study Results: In 50-100 words, state your research questions, describe how they were supported by your research, and then include visuals (e.g., graphic/charts/diagrams) to illustrate the parts or results of your study.
Describe aspects of your profession in human services field : Describe the aspects of your profession in human services field as the general applications that may apply most or all other humn service profssions.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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