Database project数据库项目.pdf

database design project ieor 115: final presentation team #6 Alicia Zecherle Ami Bigit Ben Lewis Khoa Tran Kimberly Lam Mana Nabati Morgan Fabian Steven Belding our client: Rachel Malsin founder of PROJECT: JUICE EER Diagram project overview relational schema project overview 1. Person(PersonID, Lname, Fname, MI, Street, City, State, Zip, Telephone, Email) 1 2. Customer(CID , Customer_Type, Group_Name, Bdate, Gender, Company, County, Tax_Rate, Note) 1 3. Employee(EID , SSN, Bdate, Job_Title, Salary, Hourly_Wage) 1 4. Facility_ Owner(FOID , Company_Name) 1 5. Potential_Customer(ContactID , Place_of_Contact, Date_Of_Contact, Company_Name, SamplingEvent20) 1 6. Vendor_Contact(ContactID , Job_Title, Company_Name) 1 7. Investor(InvID , Company_Name) 1 8. Other_Person(ContactID , Description) 2 31 3 9. Order(OID, Date_Placed, Time_Placed, CID , Input_Type, TID , Recieved_By ) 10. Facility(FacilityID, Name, Street, City, State, Zip, Telephone, Facility_Type)