Puan Sara is the owner and founder of Careris Child Education Centre in Klang Valley. Currently,...

Transcribed Image Text:

Puan Sara is the owner and founder of Careris Child Education Centre in Klang Valley. Currently, the centre offers Igra', Arabic language, archery, and computer lessons to children of various ages, including toddlers, preschoolers, and middle childhood. A parent or guardian may register their children for the class offered, but each child is only associated with one parent or guardian. A student can enroll in multiple classes, and a single class can have many students. Careris Child Education Centre currently uses the Microsoft Excel to manage its financial transactions, such as recording monthly payments received from parents and the Microsoft Word application is used to manage students' registrations and records. She has always had difficulty locating detailed records of her students' and parents' information. As a result, she realised that she needed a one-stop databased system for student registration to effectively manage all of the detail records and transactions. Required: a. Advise Puan Sara on the following aspects of designing a student registration database. i. Entity Relationship Diagram for the student registration database showing all entities and their relationships. Puan Sara is the owner and founder of Careris Child Education Centre in Klang Valley. Currently, the centre offers Igra', Arabic language, archery, and computer lessons to children of various ages, including toddlers, preschoolers, and middle childhood. A parent or guardian may register their children for the class offered, but each child is only associated with one parent or guardian. A student can enroll in multiple classes, and a single class can have many students. Careris Child Education Centre currently uses the Microsoft Excel to manage its financial transactions, such as recording monthly payments received from parents and the Microsoft Word application is used to manage students' registrations and records. She has always had difficulty locating detailed records of her students' and parents' information. As a result, she realised that she needed a one-stop databased system for student registration to effectively manage all of the detail records and transactions. Required: a. Advise Puan Sara on the following aspects of designing a student registration database. i. Entity Relationship Diagram for the student registration database showing all entities and their relationships.

Answer rating: 100% (QA)

1 Schema Cuverdian Id GuardianTable Gordia Name Total fess pail Related to Student Nona ... View the full answer