COLLEGE NANNIES INC.

Presented By: Kamyl Miller Joseph Huff Danny Cordova Dustin Ware

CONTACT INFORMATION Address: 1234 main st Houston, TX 77077 Phone: 1-800-nannies Email: colegenannies@sbcglobal.net Website: www.collegenannies.net Owner: Michaela Jones

BACKGROUND INFO In business, serving the Clearlake and

Houston area for over 10 years. All nannies certified in CPR and First Aid Provide role models for children Open Monday – Saturday 8:00am to

6pmSunday 12:00pm to 6pm

SERVICES Live-in Full time Part time Summer Parents’ Night Out After School

BUSINESS NEEDS Better management of payments,

invoice system Updated contact information of

customers and employees Up to date scheduling system System that allows employees to look at

schedule over internet Transfer paper files into electronic files

ENTITIES Customer Child Employee Contact Information Appointment Services and Cost Invoice Payment

ENTITIES AND ATTRIBUTES Customer (customer ID, child ID(s), last

name, first name, address, city, state, zip code, contact info ID)

Child (child ID, last name, first name, age, gender, special care, employee ID)

Employee (employee ID, last name, first name, certifications, address, city, state, zip code)

Contact Information (contact info ID, home phone, cell phone, work phone, emergency contact number)

ENTITIES AND ATTRIBUTES CONT. Appointment (customer ID, employee

ID, service ID, address, date, time) Services and Cost (service ID, service

type, cost) Invoice (invoice ID, amount billed,

customer ID, service ID) Payment (payment ID, invoice ID,

amount paid, payment type, date paid, balance due)