Private consulting company (Gunzip Consulting) with 5 employees needing to keep track of their massive client database as well as employee data.
Client and employee tables with tables that link to those individuals with unique personID to store things like phone numbers, addresses, history, and other data to track clients.
Client Relationship Database
Goes to different clients and meets with them and their teams to develop solutions that our consulting team can help them on. All purpose!
Tables in DB
- PERSON(PersonID,CompanyID,FirstName,LastName,PersonType,Gender)
- PHONE(PersonID,ContactNumber,PhoneType)
- EMAIL(PersonID,EmailAddress,EmailType)
- ADDRESS(PersonID,AddressLine1,AddressLine2,AddressLine3,City,State,Zip,AddressType)
- COMPANY(CompanyID,CompanyName)
- WEBSITE(PersonID,WebsiteTitle,WebsiteURL,WebsiteType)
- This has a lot of problems....
Relations?
- Person can have many phones,emails,addresses,companies?
- Company can have many people.
- Address can belong to more than one person.
- Phone and email can belong to only one person (or can it...couples?corporate general email?)