Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started