Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please state the following for the above scenario: 1. Business Rules that you can identify for the ABC Company. 2. Entity Relationship Diagram (ERD) for

image text in transcribedimage text in transcribed

Please state the following for the above scenario:

1. Business Rules that you can identify for the ABC Company.

2. Entity Relationship Diagram (ERD) for the ABC Company

Scenario 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 properly organized etc When a customer arrives at the shop, the friendly staff greets 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

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_2

Step: 3

blur-text-image_3

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

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions