College Nannies Inc.

1. College Nannies Inc.

2. Presented By: • Kamyl Miller • Joseph Huff • Danny Cordova • Dustin Ware

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

4. 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 6pm Sunday 12:00pm to 6pm

5. Services • Live-in • Full time • Part time • Summer • Parents’ Night Out • After School

6. 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

7. Entities • Customer • Child • Employee • Contact Information • Appointment • Services and Cost • Invoice • Payment

8. 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)

9. 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)