90 likes | 167 Views
College Nannies Inc. has been serving Clearlake and Houston for over 10 years, offering certified CPR and First Aid nannies who serve as role models for children. We provide live-in, full-time, part-time, and summer childcare services, as well as Parents’ Night Out and After School care. Contact us for reliable, quality care!
E N D
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 6pm Sunday 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)