Question
ABC is an automotive parts shop company which is planning to develop a database to store data regarding its customers,motor parts and staff. The company
ABC is an automotive parts shop company which is planning to develop a database to store data regarding its customers,motor parts and staff. The company has 12 branches in different towns/cities around Fiji. The company wants to get rid of the manual file system due to possible loss of data, company records not being property organized etc. When a customer arrives at the shop, the friendly staff grets the customer and identifies whether the customer is a new customer or the customer has bought some parts previously. If the customer is new, the details of the customer is noted and stored in the database. The details about the customer that are kept by the company include the customer number (unique for each customer), the customer's name, residential and postal addresses, and home and work phone numbers. A customer can be classified as private or business. Business customers buy most parts from the company so they are eligible for some discount. Private customers can also get discount but it will be less than the business customer. The staff then serves the customer by showing the parts required and gives valuable suggestions to customers as well. The company stores the part number, part description, part price, quantity on hand, quantity on order, etc. When a customer buys part(s), an invoice is issued. For each invoice, the invoice number, invoice date, customer number, customer name, part number(s), part description(s), quantity, price, staff number and name who sold the parts are recorded. For each part, the supplier information, quantity on hand and branch location should also be stored in the database. According to company's policy, a supplier can supply a maximum of 5 different parts only.
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