Case Study: ACE Sport Database Mr. Harris has a shop selling sport apparels and his forecasts for this year 2022 in the planning indicate that his sales will be quite high, so he will be very busy generating all the products for the orders. As a result, he needs an IT team who can help him to develop a database that can effectively handle the orders that come into the shop. Specifically, he would like the database system to have a function that could keep track all the orders, to allow users to enter data into the database using a well-designed user interface, to print the required reports and to inquire certain information for decision making. As an IT people, you and your team have been hired to assist ACE Sport company in managing the shop’s orders. They will be giving you a partially completed order database called “ACE.accdb” for your further development of the database. The current order database contains “Order Line Item” table only. After a discussion with your team members, the team decides to develop the database by completing the following tasks With examples from this database assignment, explain the importance of making an accurate and effective decision making for this apparel ordering company and discuss how this database management system can assist in making effective decision. Discuss your answers.

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 7P
icon
Related questions
Question

Case Study: ACE Sport Database

Mr. Harris has a shop selling sport apparels and his forecasts for this year 2022 in the planning indicate that his sales will be quite high, so he will be very busy generating all the products for the orders. As a result, he needs an IT team who can help him to develop a database that can effectively handle the orders that come into the shop. Specifically, he would like the database system to have a function that could keep track all the orders, to allow users to enter data into the database using a well-designed user interface, to print the required reports and to inquire certain information for decision making.

As an IT people, you and your team have been hired to assist ACE Sport company in managing the shop’s orders. They will be giving you a partially completed order database called “ACE.accdb” for your further development of the database. The current order database contains “Order Line Item” table only. After a discussion with your team members, the team decides to develop the database by completing the following tasks

With examples from this database assignment, explain the importance of making an accurate and effective decision making for this apparel ordering company and discuss how this database management system can assist in making effective decision.

Discuss your answers.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Dataset
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning