Please help me do this senario relationships analysis for the senario below. I have attached them below. Please leave you email as well so if I like your work I can contact you on it. 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. Relationship Analysis• Relationship name: PARENT_ENTITY relationship name CHILD_ENTITY (the name is a verb or verb phrase 3rd singular)• Relationship type with explanation• Relationship strength with explanation• Entities participation in the relationship with explanations• Any special cardinality as needed, or state there is no special cardinality.• Foreign key used for representation.

Two entities are mentioned for the relationship analysis: PARENT_ENTITY and CHILD_ENTITY The…

Answered: Relationship Analysis • Relationship…

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

Related questions

Question

100%

Please help me do this senario relationships analysis for the senario below. I have attached them below. Please leave you email as well so if I like your work I can contact you on it.

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 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 dass 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 kindergarted. 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 highes degree (e.g. BS, MS, MA, ... - a maximum five characters code) and the area of the degree (at
most 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.

Relationship Analysis
• Relationship name: PARENT_ENTITY relationship name CHILD_ENTITY (the name is a verb or verb phrase 3rd singular)
• Relationship type with explanation
• Relationship strength with explanation
• Entities participation in the relationship with explanations
• Any special cardinality as needed, or state there is no special cardinality.
• Foreign key used for representation.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS