Wheels & Tyres Inc. is a leading Australian producer of high-quality tyres. There are several types of tyres that the company produces: (1) for automotive industry, (2) for plane construction, (3) for agricultural machinery. With the passage of time a small family-owned company grew up into one of the largest producers in Australasian region. With growth of the company the functional areas also started to expand and included such as: (1) procurement, (2) manufacturing, (3) ordering, (4) sales, (5) admin/accounting. The document flow was expanding сcorrespondingly, therefore, higher level of automation in the internal company’s system become a must. All the accounting and financial documentation were processed in three separate computer applications (order filling, invoicing and payroll). The next step in automation was to shift towards a database approach. Currently Wheels & Tyres Inc. has a company-wide database with which all the other applications are interacting. Overall economic growth in the country has led to increase in car purchases and consequently the demand for tyres was constantly increasing. When the new order for tyres is placed, the packaged tyres are delivered to the customer and invoice is issued. The existing applications cover order filling, invoicing, accounts receivable and payable, inventory control and payroll. The data in the system is organized around entities including customers, orders and invoices. The key challenge that Wheels & Tyers Inc. is facing right now is to develop the application that suits the full spectrum of company’s needs. Questions (Please do it sincerely) Prepare a context diagram for the new system.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Wheels & Tyres Inc. is a leading Australian producer of high-quality tyres. There are several types of tyres that the company produces: (1) for automotive industry, (2) for plane construction, (3) for agricultural machinery. With the passage of time a small family-owned company grew up into one of the largest producers in Australasian region. With growth of the company the functional areas also started to expand and included such as: (1) procurement, (2) manufacturing, (3) ordering, (4) sales, (5) admin/accounting.

The document flow was expanding сcorrespondingly, therefore, higher level of automation in the internal company’s system become a must. All the accounting and financial documentation were processed in three separate computer applications (order filling, invoicing and payroll). The next step in automation was to shift towards a database approach. Currently Wheels & Tyres Inc. has a company-wide database with which all the other applications are interacting.

Overall economic growth in the country has led to increase in car purchases and consequently the demand for tyres was constantly increasing. When the new order for tyres is placed, the packaged tyres are delivered to the customer and invoice is issued. The existing applications cover order filling, invoicing, accounts receivable and payable, inventory control and payroll. The data in the system is organized around entities including customers, orders and invoices.

The key challenge that Wheels & Tyers Inc. is facing right now is to develop the application that suits the full spectrum of company’s needs.

Questions (Please do it sincerely)

  1. Prepare a context diagram for the new system.
  2. Prepare DFD: level 0, depicting at least 3 processes within the system
  3. Using additional, open source information, develop at least one use case diagram for the system
  4. Based on the use case diagram develop at least 1 use case following the template: use case title, primary actor, level, stakeholders, precondition, minimal guarantee, success guarantee, trigger, main success scenario.
  5. Which approach will you choose for data modeling (bottom-up or top-down). Explain briefly why.
  6. Which installation type will you choose for the system. Briefly explain your choice.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Data Recovery Approaches
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.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education