Question: Create an ER diagram and relational data model based on the following scenario - pay attention to the bullet points: A company does not currently

Create an ER diagram and relational data model based on the following scenario - pay attention to the bullet points:

A company does not currently have a centralized database to manage information. Each department manages information internally and shares information with other departments as they see necessary. The departments use Excel spreadsheets to keep their electronic records and keep track of customers, inventory, and prices of items. The company needs a more organized system of information to improve communication and allow departments to share information more easily with one another. The requirements for the company are to be able to manage and account for:

Supplies

-Inventory levels

Suppliers

-Purchase orders

Invoices

Customer orders

-Product type

-Quantity of orders

-Order frequencies for different customers

-Consumer invoices

Main types of office supplies

-Pens / Pencils

-Staplers

-Printers

Main types of office furniture

-Desks

-Chairs

Delivery vans

-Van 1

-Van 2

Delivery drivers

-Driver 1

-Driver 2

Potential clients

-Businesses

-Schools

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!