Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Linda owns a small boutique, Linda's Fashion Hub in Melbourne. Linda's Fashion Hub has always used a manual system to manage their inventory and sales.

Linda owns a small boutique, "Linda's Fashion Hub" in Melbourne. "Linda's Fashion Hub" has always used a manual system to manage their inventory and sales. When a customer buys an outfit, the salesperson notes down the customer details and the outfit details in a register. The outfit is then packed and handed over to the customer. As the boutique started gaining popularity, Linda faced challenges in managing the inventory and sales. The manual system was not efficient and led to discrepancies in inventory. Customers often complained about outfits being unavailable even when the register showed them in stock. To streamline operations, Linda decided to implement a database system. She wants a database to manage "Linda's Fashion Hub" inventory, customer details, employee details, and sales records. The inventory should include details like outfit type (dress, top, skirt, etc.), designer, size, price, and stock status. To foster customer loyalty, Linda wants to store customers' names, phone numbers, email addresses, and purchase records. "Linda's Fashion Hub" employs salespersons, inventory managers, and cashiers. The database should capture every employee's name, ID, date of joining, hourly wage, and role. Your task is to design a database that encompasses employee details, customer information, outfit inventory, and

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Project Management

Authors: Kathy Schwalbe

6th Edition

978-111122175, 1133172393, 9780324786927, 1111221758, 9781133172390, 324786921, 978-1133153726

More Books

Students also viewed these General Management questions