DP Review II grp 6 - Relational Schema 9....

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Click icon to add picture GloSolar IEOR 115 Database Design Project Review 2 Group 6
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Revised EER Diagram
Background image of page 2
QUERIES Which sales representative has turned the most “lead customers” to “paying customers”? Which advertisement medium has referred the most customers? Which 5 territories have the lowest representation of customers? What advertising mediums can be used to reach these customers? What are the monthly, quarterly, yearly revenue, expenses, and profit? How efficient is our process? (calculating the time
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Relational Schema 1. Person(Person_id , Last_Name, First_Name, MI, Address, Phone_Number, Email_Address) A. Employee(Person_id1 , SSN, Salary, Birth_Date, Date_of_Hire) a) SalesRepresentative(Employee_id1a , SSN1a) b) CustomerServiceRepresentative(Employee_id1a , SSN1a) B. Customer(Person_id1 , Territory_id9, AdvertisementMedium_id7, SalesRep _id1ai, Employee _id1a, Referral_Customer_id1b ) 1. PayingCustomer(Person_id1 ) 2. LeadCustomer(Person_id1a ) 2. WorksIn(Employee_id1a, Department_id5 ) 3. Order(Employee_id1a, Order_id , Project_id4, Time_Stamp, Amount, Payment_Method,
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Relational Schema 9. Territory(Territory_id , Name, City, County) 10. ResponsibleFor(Project_id4, Employee_id1a ) 11. MarketSurvey(MarketSurvey_id , Time_Stamp, Customer_id1b) 12. Monitoring_System(Project_id4, Monitoring_System_id ) 13. System_Maintenance(Project_id4, System_Maintenance_id ) 14. WorkOn(Project_id4, Contractor_id15 , Commission, Contract_Document) 15. BuildingPermit(Building_Permit_id, Project_id4 , Permit_Document) 16. Uses_Medium(Advertisement_id8, AdvertisingMedium7 ) Relational Schema 17. SystemDesign(System_Design_id , Project_id4, Customer_id1b) A. Design_Questionnaire(System_Design_id17 , Design_Questionairre_id , Employee_id1a) B. Cut_Sheet(System_Design_id17 , Cut_Sheet_id ) C. Electrical_Line_Drawing(System_Design_id1 7 , Electrical_Line_Drawing_id ) D. RoofPlan(System_Design_id17 , Roof_Plan_id ) E. ShadeAnalysis(System_Design_id17 , Shade_Analysis id ) 18. EmployeeCreatesSystemDesign(System_Desig n_id24 , Employee_id1a) Click icon to add picture Q&A...
View Full Document

Page1 / 7

DP Review II grp 6 - Relational Schema 9....

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online