Illustrate a conceptual design of the database that needs to be built for Golden Gardens by means of an ER Diagram that reflects the dependency diagram produced in Question 1. Show the data types of all attributes in your entities. • You may use any diagramming tool to draw the ER diagram. • DBMS-created diagrams are not allowed. • Allowed notations: Crow's foot, Chen Model and UML
Illustrate a conceptual design of the database that needs to be built for Golden Gardens by means of an ER Diagram that reflects the dependency diagram produced in Question 1. Show the data types of all attributes in your entities. • You may use any diagramming tool to draw the ER diagram. • DBMS-created diagrams are not allowed. • Allowed notations: Crow's foot, Chen Model and UML
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...
Related questions
Question
![1. Illustrate the concept of Normalization by means of a dependency diagram that
shows how the spreadsheet in Figure 1 would look in Third-Normal-Form
You may use any diagramming tool to draw the diagram.
2. Illustrate a conceptual design of the database that needs to be built for Golden
Gardens by means of an ER Diagram that reflects the dependency diagram produced
in Question 1. Show the data types of all attributes in your entities.
You may use any diagramming tool to draw the ER diagram.
DBMS-created diagrams are not allowed.
• Allowed notations: Crow's foot, Chen Model and UML.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F86e848c1-61b9-4813-9106-dd9d1c331554%2F65714f45-a83f-4f1f-9bd8-2bf098ccf997%2Fjtxq2h9_processed.png&w=3840&q=75)
Transcribed Image Text:1. Illustrate the concept of Normalization by means of a dependency diagram that
shows how the spreadsheet in Figure 1 would look in Third-Normal-Form
You may use any diagramming tool to draw the diagram.
2. Illustrate a conceptual design of the database that needs to be built for Golden
Gardens by means of an ER Diagram that reflects the dependency diagram produced
in Question 1. Show the data types of all attributes in your entities.
You may use any diagramming tool to draw the ER diagram.
DBMS-created diagrams are not allowed.
• Allowed notations: Crow's foot, Chen Model and UML.
![JoziCleaners is local cleaning service that is looking to upgrade their current operations by
making use of a database to keep track of the teams, houses, clients and billings of each client
per/week.
Each house is cleaned by one or more teams. A team goes out to a particular house on a certain
day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day,
except the team leader who earns a unique amount.
The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a
spreadsheet in Figure 1 below.
Day
Client
Client Name
Team Members
Team Leader
Leader
Total
Code
ID
Wage
Monday
Aeliana Gebahard
T3
6.
Jaymes Merrickson
R 350
R 850
C10
Alfher Dareia
T1
Geoffrey Glover
R 250
R 750
C8
Felina Diodotus
T2
Elmer Victorson
R 300
R 700
Brutus Sigihild
Sigibert Quirinus
Brutus Sigihild
C9
T4
Norris Mamadou
R 400
R1 000
Tuesday
CS
T3
Jaymes Merrickson
R 350
R 850
C9
T2
5
Elmer Victorson
R 300
R 700
Alfher Dareia
Duncan Gardyner
Geoffrey Glover
C10
T5
5
R450
R 850
C7
Servius Ambrosia
T1
6.
R 250
R750
C10
Alfher Dareia
T2
Elmer Victorson
R 300
R 700
Wednesd
ay
C10
Alfher Dareia
T3
6.
Jaymes Merrickson
R 350
R850
C1
Nikolaos Gallus
T4
7
Norris Mamadou
R 400
R1 000
C3
Amalia Prochoros
T2
5
Elmer Victorson
R 300
R 700
C8
Felina Diodotus
T3
Jaymes Merrickson R 350
R 850
Thursday C2
Hariwini Agrippa
T4
7
Norris Mamadou
R 400
R1 000
C9
Brutus Sigihild
T2
Elmer Victorson
R 300
R 700
CS
Sigibert Quirinus
T2
5
Elmer Victorson
R 300
R 700
C6
Artemisia Hippolytos T3
6.
Jaymes Merrickson
R 350
R850
Friday
C8
Felina Diodotus
T2
5
Elmer Victorson
R 300
R 700
Geoffrey Glover
Geoffrey Glover
C4
Aeliana Gebahard
T1
6.
R 250
R 750
C9
Brutus Sigihild
T1
R 250
R 750
Servius Ambrosia
T4
7
Norris Mamadou
R 400
R1 000
C2
Hariwini Agrippa
T3
6
Jaymes Merrickson
R 350
R850
Figure 1: JoziCleaners' report](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F86e848c1-61b9-4813-9106-dd9d1c331554%2F65714f45-a83f-4f1f-9bd8-2bf098ccf997%2F3h3rvb_processed.png&w=3840&q=75)
Transcribed Image Text:JoziCleaners is local cleaning service that is looking to upgrade their current operations by
making use of a database to keep track of the teams, houses, clients and billings of each client
per/week.
Each house is cleaned by one or more teams. A team goes out to a particular house on a certain
day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day,
except the team leader who earns a unique amount.
The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a
spreadsheet in Figure 1 below.
Day
Client
Client Name
Team Members
Team Leader
Leader
Total
Code
ID
Wage
Monday
Aeliana Gebahard
T3
6.
Jaymes Merrickson
R 350
R 850
C10
Alfher Dareia
T1
Geoffrey Glover
R 250
R 750
C8
Felina Diodotus
T2
Elmer Victorson
R 300
R 700
Brutus Sigihild
Sigibert Quirinus
Brutus Sigihild
C9
T4
Norris Mamadou
R 400
R1 000
Tuesday
CS
T3
Jaymes Merrickson
R 350
R 850
C9
T2
5
Elmer Victorson
R 300
R 700
Alfher Dareia
Duncan Gardyner
Geoffrey Glover
C10
T5
5
R450
R 850
C7
Servius Ambrosia
T1
6.
R 250
R750
C10
Alfher Dareia
T2
Elmer Victorson
R 300
R 700
Wednesd
ay
C10
Alfher Dareia
T3
6.
Jaymes Merrickson
R 350
R850
C1
Nikolaos Gallus
T4
7
Norris Mamadou
R 400
R1 000
C3
Amalia Prochoros
T2
5
Elmer Victorson
R 300
R 700
C8
Felina Diodotus
T3
Jaymes Merrickson R 350
R 850
Thursday C2
Hariwini Agrippa
T4
7
Norris Mamadou
R 400
R1 000
C9
Brutus Sigihild
T2
Elmer Victorson
R 300
R 700
CS
Sigibert Quirinus
T2
5
Elmer Victorson
R 300
R 700
C6
Artemisia Hippolytos T3
6.
Jaymes Merrickson
R 350
R850
Friday
C8
Felina Diodotus
T2
5
Elmer Victorson
R 300
R 700
Geoffrey Glover
Geoffrey Glover
C4
Aeliana Gebahard
T1
6.
R 250
R 750
C9
Brutus Sigihild
T1
R 250
R 750
Servius Ambrosia
T4
7
Norris Mamadou
R 400
R1 000
C2
Hariwini Agrippa
T3
6
Jaymes Merrickson
R 350
R850
Figure 1: JoziCleaners' report
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY