90 likes | 167 Views
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.
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)