Stylish Shoes started operations as a small retailer of high-end footwear in Christchurch. Over the years, the business has expanded its network with branches across all major towns in the South Island. Although much has changed since the business started, one aspect that has not altered much is its documentation process, which uses a file system. An extract from the Stylish Shoes Sales file is presented below: Cust_name Cust_address Cust_phone Salesperson Shoe_mod Shoe_value Date Britney Micaw Michelle Burford 2 Abberley Cres 6 Fairway Drive 03 1234 5678 Tim VZ4717 $129.90 20-Jul-21 03 9876 4321 Cох DF3966 $79.50 30-Jul-21 Phillipa Musick 8 Akaroa Street 03 5678 3456 Miller WE9447 $150.30 4-Aug-21 Devine Smith 3 Glade Avenue 03 2376 1048 Jeffrey XC8187 $145.50 6-Aug-21 There has been a change of management at the company, and the new Sales Manager Hannah King is keen to move the company's sales documentation from a master file to a database system. To convince the senior management team of the importance of using a database system, she needs to provide evidence of the limitations of a file system as well as the benefits a database system can offer. Required: You have been contacted by Hannah for your help with the following: Explain how a relational database system works AND discuss TWO problems that could be associated with large tables like those used by Stylish Shoes under a file-based legacy system. Link the problems you discuss to the Stylish Shoes example to help Hannah make her case for changing to a dotobocO Cuctom
Stylish Shoes started operations as a small retailer of high-end footwear in Christchurch. Over the years, the business has expanded its network with branches across all major towns in the South Island. Although much has changed since the business started, one aspect that has not altered much is its documentation process, which uses a file system. An extract from the Stylish Shoes Sales file is presented below: Cust_name Cust_address Cust_phone Salesperson Shoe_mod Shoe_value Date Britney Micaw Michelle Burford 2 Abberley Cres 6 Fairway Drive 03 1234 5678 Tim VZ4717 $129.90 20-Jul-21 03 9876 4321 Cох DF3966 $79.50 30-Jul-21 Phillipa Musick 8 Akaroa Street 03 5678 3456 Miller WE9447 $150.30 4-Aug-21 Devine Smith 3 Glade Avenue 03 2376 1048 Jeffrey XC8187 $145.50 6-Aug-21 There has been a change of management at the company, and the new Sales Manager Hannah King is keen to move the company's sales documentation from a master file to a database system. To convince the senior management team of the importance of using a database system, she needs to provide evidence of the limitations of a file system as well as the benefits a database system can offer. Required: You have been contacted by Hannah for your help with the following: Explain how a relational database system works AND discuss TWO problems that could be associated with large tables like those used by Stylish Shoes under a file-based legacy system. Link the problems you discuss to the Stylish Shoes example to help Hannah make her case for changing to a dotobocO Cuctom
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
answer question in photo pls

Transcribed Image Text:Stylish Shoes started operations as a small retailer of high-end footwear in Christchurch. Over the years, the business has expanded its network with
branches across all major towns in the South Island. Although much has changed since the business started, one aspect that has not altered much is
its documentation process, which uses a file system.
An extract from the Stylish Shoes Sales file is presented below:
Cust_name
Cust_address
Cust_phone
Salesperson
Shoe_mod
Shoe_value
Date
Britney Micaw
2 Abberley Cres
03 1234 5678
Tim
VZ4717
$129.90
20-Jul-21
Michelle Burford
6 Fairway Drive
03 9876 4321
Сох
DF3966
$79.50
30-Jul-21
Phillipa Musick
8 Akaroa Street
03 5678 3456
Miller
WE9447
$150.30
4-Aug-21
Devine Smith
3 Glade Avenue
03 2376 1048
Jeffrey
ХC8187
$145.50
6-Aug-21
There has been a change of management at the company, and the new Sales Manager Hannah King is keen to move the company's sales
documentation from a master file to a database system. To convince the senior management team of the importance of using a database system, she
needs to provide evidence of the limitations of a file system as well as the benefits a database system can offer.
Required:
You have been contacted by Hannah for your help with the following:
Explain how a relational database system works AND discuss TWO problems that could be associated with large tables like those used by Stylish
Shoes under a file-based legacy system. Link the problems you discuss to the Stylish Shoes example to help Hannah make her case for changing to a
database system.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY