Your task for this assignment is to complete a database design for the given case studies. Model the system described in the case study and draw a Physical Data Model using MySQL Workbench. Your diagram must conform to the notation used in this subject (object notation = ‘Workbench Simplified’, relationships notation = ‘Crows Foot’, show data types). If you include sub-types, place them inside a Layer with a note explaining their relationship to the super-type. CASE 2Consider the following application domain. A system for circuses includes:• Employees, identified by name and date of birth. Employees are contactable at one or more telephonenumbers. Some employees are performers, while others are administrative staff. Each performer has aspecial skill (e.g. tight-rope walking).• Venues, identified by place. Each venue has a selection of standard circus equipment.• Shows, identified by venue, start-date and end-date. All employees work at one or more shows.• Programs, which can be used at different shows. Each program is suitable for only certain venues.Certain performers are suitable for particular programs.

The ERD has7 entities. The entity are: employees, shows , performers, admin staff , skill , venue,…

Answered: Your task for this assignment is to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Your task for this assignment is to complete a database design for the given case studies. Model the system described in the case study and draw a Physical Data Model using MySQL Workbench. Your diagram must conform to the notation used in this subject (object notation = ‘Workbench Simplified’, relationships notation = ‘Crows Foot’, show data types). If you include sub-types, place them inside a Layer with a note explaining their relationship to the super-type.

CASE 2
Consider the following application domain. A system for circuses includes:
• Employees, identified by name and date of birth. Employees are contactable at one or more telephone
numbers. Some employees are performers, while others are administrative staff. Each performer has a
special skill (e.g. tight-rope walking).
• Venues, identified by place. Each venue has a selection of standard circus equipment.
• Shows, identified by venue, start-date and end-date. All employees work at one or more shows.
• Programs, which can be used at different shows. Each program is suitable for only certain venues.
Certain performers are suitable for particular programs.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions