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
Get step-by-step solutions from verified subject matter experts
