C O L O R S Day Care

1. COLORS Day Care Karina Izaguirre Jake Morales Summer 2009

2. Contact Information • Telephone #: 281-692-0105 • Fax #: 281-383-5037 • Email: info@colorsdaycare.com • Website: www.colorsdaycare.com

3. Business Background • Business located in Pearland, Tx • 10 years in business – since 1999 • Average of 60 kids on site • Age Groups: • Birth – less than 1 year • 1 year – less than 3 years • Pre-K – 3 years – less than 5 years • School-age – 5 yrs+

4. Business Needs • Business information is maintained manually vs an electronic database • Needs: • “real time” access to most “up-to-date” customer information • Better management of material needs • Better management of Emergency Contact Information • Better management of Payments

5. Business Solutions • The solution is to create a database which can perform the following functions: • Input customer data in a one-stop data entry screen for quick and easy access to important customer information in response to emergencies and other needs

6. Business Solutions • The solution is to create a database which: • Maintains all inventory of materials needed for each class and usage is tracked and monitored in order to maintain a steady supply of inventory needed and also manage costs more effectively by reducing waste.

7. Business Solutions • The solution is to create a database which can: • Maintain Emergency Contact information for each child to ensure immediate and appropriate notification to that person.

8. Business Solutions • The solution is to create a database which can perform the following functions: • Accounts Receivables: • Produce reports of customers who are overdue on payments • Accounts Payables • Produce reports for payments due to vendors

9. Business Value • The business value of incorporating a database system that performs these functions is as follows: • Reduce time spent tracking data manually, thus reduces costs, thus more profit! • Better management of costs results in more efficient operation and thus more profit! • Better customer service thus more business and more profit! IT MAKES BUSINESS “CENTS”!

10. Special Issues • The database system must be: • User friendly • Cost efficient • Reliable

11. Entities • Child • Class • Materials • Invoice • Employees • Payment

12. Entities and Attributes

13. Local Design (E-R Diagram) Payment M 1 Is made M receives Invoice 1 Enrolls requires M 1 N M Class Materials Child N taught by M Employee

14. Physical Design • Child (ChildID, Lname, Fname, Address, City, State, ZipCode, Telephone, Emergency Contact, Emergency Tel# • Class (ClassID, Enrollment Type, Fee, • Materials (MaterialID, Description, Subcategory, Price) • Invoices (InvoiceID, Enrollment type, Amount Billed, Date Billed, ChildID) • Employees (EmployeeID, Lname, Fname, SSN, Certification ID, Address, City, State, Zip, Telephone, Pay) • Payments (PaymentID, InvoiceID, Amount Paid, Date Paid, Balance Due) • Class-Materials (ClassType, MaterialID) • Employee – Class (Employee ID, Class ID)

15. Entity - Relationships

16. Table 1 – Child Table

17. Table 2 – Materials Table

18. Report 1 -A report that shows all the children sorted by last name and their respective emergency contact name and #

19. Report 2-Invoices Table

20. Form 1 – Child Information Form Can search for each child: ie: Search for Jordan by entering “Jordan” in “filter” box and it brings you to record #4 which is child Michael Jordan. Click on “new record” icon to create a new record for a new child

21. Form 2 –Employee Information Form Can setup a form data entry screen for each entity

22. Query 1 – Query for Diapers from Materials Table Resulting Query Input “Diapers” to query and get the desired results

23. Query 2 – Query for balance due in ascending order

24. Q&ATHANK YOU!