Description
Create scripts of SQL statements for the following situations:
- Add a minimum of five clients, three sales people, ten contacts, and at least one contact summary for each client to your database that you created in W3 Assignment 2. Every sales person must have at least one client.
- Query your database to produce all the clients for one of the sales people that are assigned to multiple clients.
- Produce a full client list by sales person.
- Add a contact summary to one of your clients, then modify it, and then delete it.
Unformatted Attachment Preview
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
Purchase answer to see full attachment
Explanation & Answer:
1 Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Nice! Really impressed with the quality.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
