Information Systems Design

Dec 29th, 2014
SKTFaker
Category:
Business & Finance
Price: $40 USD

Question description

Cassandra’s Cookie Company needs an application to take orders for the cookies they sell. They sell 3 different kinds of cookies: oatmeal raisin, chocolate chip, and sugar cookies. The application needs to store customer information as well as customer orders. 

First, create a project plan that includes budget, schedule, and scope. Who are the actors in the system? You may use assumed or hypothetical data to construct the plan. Next, create a context diagram using Microsoft Word or Visio to show customers ordering cookies. Create an ERD (entity-relationship diagram) for the system in Microsoft Word or Visio. Finally, use MS Access to design a customer database. Include the following information in the Customer table:

  • Customer ID (Use auto number as the primary key.)
  • Customer Last Name, Customer First Name, and Customer Middle Initial
  • Street Address 1
  • Street Address 2
  • City, State, and Zip
  • Phone
  • E-mail Address

Also create an Orders table to keep track of the customer orders. Include the Customer ID and the type and quantity of cookie ordered.

To design the database:

  • Design an MS Access input form for data input.
  • Use the input form to enter the data of 10 imaginary customers into the database.
  • Develop a report to print the data of the customers.
  • Develop a query to sort the customers by their last name.

Submit the project plan, context diagram, and Access database in a zipped folder.

Assignment 2 Grading Criteria

Maximum Points

Created a project plan for Cassandra’s Cookie Company with all required components.

20

Created a context diagram in Microsoft Word or Visio.

10

Created an ERD.

10

Created a database with all tables, keys, fields, relationships, report, and input form.

20

Writing and Presentation Components:
Organization (10)
Style (10)
Usage and Mechanics (15)
APA Elements (15)

20

Total:

80


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Duke University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

7 Reviews


Summary
Quality
Communication
On Time
Value
kpcutie
Dec 2nd, 2016
" Excellent job "
Hemapathy
Nov 18th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Nov 5th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Oct 27th, 2016
" Goes above and beyond expectations ! "
ashleyisgod
Oct 13th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Oct 4th, 2016
" Excellent work as usual "
Molly_Moon
Sep 21st, 2016
" AMAZING as always! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors