Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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)
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
icon
Related questions
Question
100%
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
Transcribed Image Text:**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. ---
Transcribed Image Text:--- **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. ---
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS