Running Head:ABC MANUFACTURING COMPANY
Creating a CRM Database
6/3/19
1
ABC MANUFACTURING COMPANY
We have a database called CRM. It contains 8 tables which are
✓ Customers
✓ Employees
✓ Offices
✓ Orderdetails
✓ Orders
✓ Payments
✓ Productlines
✓ products
Inside the model we have the following relationships
The model has the following relationships and entities:
Productlines has one to one relations with products table
Orderdetails has one to one relations with orders
Employees have one to many relations with customers table.
2
ABC MANUFACTURING COMPANY
3
The database is organized into different tables. Each table has a name, and table
values. We keep track of orders, customers, products etc. We store each customer’s, name,
address, city, state, postal code and phone number. Each orders are classified into order
number, order date, status, customer number based on their function. We also keep track of the
direct supervision of each employee. We We also maintain each office code, city phone, state
country etc. and relationship to the employee. We keep track of each payment by customer
number, check number payment date and amount. Each products may engage several order
details. A customer many have several orders, but each order has only one customer. An
employee is assigned to one department but may work on several projects. The department for
which the employee works does not necessarily control the projects that the employee works
on. We keep track of the items sold per week
ABC MANUFACTURING COMPANY
4
ABC MANUFACTURING COMPANY
5
References
Weiss, M. A. (1999). Data structures and algorithm analysis in Java (Vol. 2). Reading, MA,
USA: Addison-Wesley.
VVEISS, M. A. (2002). Data structures and problem solving using Java.
Alur, R., Černý, P., Madhusudan, P., & Nam, W. (2005). Synthesis of interface specifications
for Java classes. ACM SIGPLAN Notices, 40(1), 98-109.
Purchase answer to see full
attachment