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 customer description of their operations.There are 3 age levels in the kindergarten (turtles, foxes, and monkeys). At each level, there are 3 classes (red, blue, and green). For a class, we keep a code based on the initial of group 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 a maximum 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 class in which the student 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 15 characters), 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 kindergarten. For a parent (or caretaker), we will keep the name (first, last, middle), home phone number, mobile phone number, work phone number (same format as above), the personal email (less than 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 of phone 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 highest degree (e.g. BS, MS, MA, ... - a maximum of five characters code) and the area of the degree (at most 25 characters). All the teachers must have at least a ---**Entities Analysis**You must analyze the entities identified, including the bridges, following these guidelines:1. **Entity Name**2. **Entity Description** (a short paragraph)3. **An Attribute Table**, with one row for each attribute and with the following columns: - **Attribute Name** - **Attribute Domain and Size**, e.g., CHAR(10), INT, VARCHAR(30) - **Simple/Composite** (without explanations) - **Single/Multi Value** (without explanations) - **Required/Optional** (without explanations) - **Unique/Duplicated** (without explanations)4. **The Selected Primary Key and Its Type** (simple/composite/surrogate)5. **Any Foreign Key** specifying the referenced primary key and entity.---

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

You must analyze the entities identified including the bridges: • Entity name • Entity description (a short paragraph) • An attribute table, with one row for each attribute and with the following columns: o Attribute name o Attribute domain and size, e.g. CHAR(10), INT, VARCHAR(30) o Simple/Composite (without explanations)

You must analyze the entities identified including the bridges: • Entity name • Entity description (a short paragraph) • An attribute table, with one row for each attribute and with the following columns: o Attribute name o Attribute domain and size, e.g. CHAR(10), INT, VARCHAR(30) o Simple/Composite (without explanations)

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
Merge normalized relations from separate userviews into a consolidated set of well-structuredrelations.
Suppose the date treatment performed was not entered. What procedures are required to handle the missing data?
Your task is to break this up into a list of "normalized" tables that you describe using the text-based "relational notation". You will need to break this example into as many separate tables as you feel is appropriate to remove all modification anomalies. Please submit your relational notations in an ordinary word document along with the sample data in a "grid". I'm expecting to see both PK and FK notations in your submission. Note: I'm not asking for a database... I'm asking for a list of tables in relational notation plus the sample data in rows/columns. Part One: Use text-based relational notation to describe each table/field Note: I am not yet requiring you to solve the "multi-column" problem Show PK and FK (use Microsoft Word's underline and italics tools) Part Two: Create a "grid" for each table with the all of the rows/columns of data for that table after normalization (to include PKs/FKs) Make sure you don't have any duplicate rows in your "grid" Note: You can just do…
using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role.
I have tried but not able. Please respondAn employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly? Can someone help me with this problem?.
Structural and data independence: what's the difference?
Question 2 and 3 only please and thank you so much