Information Systems Design

Dec 29th, 2014
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.


Created a context diagram in Microsoft Word or Visio.


Created an ERD.


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


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




Tutor Answer

(Top Tutor) johnalia
School: University of Maryland

Studypool has helped 1,244,100 students

Review from student
" Excellent job "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 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