This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: what products were having which problems, what kind of problems they are having, how many times the same problems occur, how many customers are reporting problems, which employees worked what case, and what managers review what case. The company would like to be able to gain the following types of information from the database: 1) How many cases an employee has worked on 2) See which managers have reviewed which employees 3) What cases a certain product is having 4) Show how many times a problem occurs 5) Find an employee with same area code E/R Diagram CASE RESOLVE REVEIW REPORT INVOLV MANAGER EMPLOYEE CUSTOMER PRODUCT...
View Full Document
- Spring '08
- database systems Project, E/R Diagram PRODUCT