Please! can you help me doing Entity Analysis for this scenario. I have attached another screenshot to followup with data Happy Learning (this is a fictional scenario)A private kindergarten, Happy Learning, wants to build a database to manage their operations. You were assigned to create an initial design based on the following customerdescription of their operations.There are 3 age levels in the kindergarten (turtles, foxes and monkeys). At each level there 3 classes (red, blue and green). For a class we keep a code based on the initial ofgroup color and level (e.g. RT for red turtles, GF for green foxes). Each class has a room number and a phone number (with the format (999) 999-9999). Also, each class has amaximum capacity (between 25 and 29). For some classes we will keep brief directions to the class location in the building (less than 130 characters).For a student we will keep the name (first, last, middle each less than 25 characters), any nickname (less than 20 characters), date of birth, address, and the dass in which thestudent is currently enrolled. We will process students based on their first and last name, or nickname, if present. We will process the address based on the city (less than 15characters), zipcode-5 and street (less than 35 characters) to identify recruiting areas.For each student we will keep information about one or more parents (or caretakers). A parent may have several students enrolled in the kindergarted. For a parent (orcaretaker) we will keep the name (first, last, middle), home phone number, mobile phone number, work phone number, (same format as above), the personal email (lessthan 30 characters) and relationship to the child (e.g. father, mother, grandfather). At least one type of phone is required, but some parents may not provide all types ofphone numbers. Some parents do not provide emails. We will process parents based on their last name.Each class has a teacher assigned. A teacher is assigned to one or more classes. For a teacher we keep the name (first, middle, last), home phone number, work email,personal email (with the format as above),the graduated college and their highes degree (e.g. BS, MS, MA, ... - a maximum five characters code) and the area of the degree (atmost 25 characters). All the teachers must have at least bachelor degree. We will process teachers based on their first and last name, phone, email. The format for the name,phone, email as described above. Entities AnalysisYou must analyze the entities identified including the bridges:1 Entity name• Entity description (a short paragraph)I An attribute table, with one row for each attribute and with the following columns:o Attribute nameo Attribute domain and size, e.g. CHAR(10). INT, VARCHAR(30)o Simple/Composite (without explanations)o Single/Multi Value (without explanations)o Required/Optional (without explanations)o Unique/Duplicated (without explanations)• The selected primary key and its type (simple//composite/surrogate).D Any foreign key specifying the referenced primary key and entity.

Question

Accepted Answer

entity name:class level
description:the class level entity acts as a base class for the classes…