Question: Answer all the questions, and you can upload the Microsoft Access file to drop box or any other site. Introduction Smart Baby Nursery and Kindergarten
Introduction Smart Baby Nursery and Kindergarten has started its operation since 2 years ago. As the number of children in the nursery and kindergarten increases, their manually done management system is no longer sufficient to support their operation. Thus, they need a computerized database system, which wl help them to store the following information: a. The personal particulars of every child, which include ID, name, birth certification number, age, parents contact information, health condition, entry date and any other relevant information. b. The personal particulars of the staffs, which include staff ID name, IC number, contact information, date started working and any other relevant information. e. Each staff is assigned to take care of maximum 10 children in every year d. The learning subjects offered are learning the Letters, Learning the Numbers, Drawing and Music. The system should be able to keep track of the children's performance for each of the subject taken. e. Monthly fee is charged and amount paid, payment due (if any), due date and payment date must be recorded properly in the system. Your task is to carry out the following exercises. Draw the E-R Diagram to show the relationship between the entities and attributes. Include the entity integrity & referential integrity in your data model. Create the tables required and set the appropriate data type, field size, format and input mask as required. Justify your design. Set up the default relationships between the three tables ensuring that you enforce referential integrity with no cascade options Enter 10 sample data for each of the tables created (30 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
