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

Answer all the questions, and you can upload the Microsoft Access file to drop box or any other site.  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 has started its operation since 2 years ago. As the
number of children in the nursery and kindergarten increases, their manually done

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!