Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Gregory Adam owns multiple theatres across South Africa. As a lover of the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develap a database for theatre management. The folowing information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three diferent types of artists that Gregary wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specifie style they major in and the database should also keep track of their height. The database should, furthermore, keep track of each actor's hair colour and their number of years of acting experience. Gregory would like to support musicians by helping to keep track of the albums that they produce. One musician can have many albums and an album may have multiple musicians colaborating on it Each collaboration on an album should have a date. The data that needs to be stored for an abum includes: Title, number of tracks and the price of the album. Given the information above, draw an Extended Entity Relationship Diagram showing the following: • Entities • Altributes, • All key atributes, • Data types for each attribute, and • All relationships between the entities NB: You may use one of the standardised ERD notations.

Gregory Adam owns multiple theatres across South Africa. As a lover of the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develap a database for theatre management. The folowing information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three diferent types of artists that Gregary wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specifie style they major in and the database should also keep track of their height. The database should, furthermore, keep track of each actor's hair colour and their number of years of acting experience. Gregory would like to support musicians by helping to keep track of the albums that they produce. One musician can have many albums and an album may have multiple musicians colaborating on it Each collaboration on an album should have a date. The data that needs to be stored for an abum includes: Title, number of tracks and the price of the album. Given the information above, draw an Extended Entity Relationship Diagram showing the following: • Entities • Altributes, • All key atributes, • Data types for each attribute, and • All relationships between the entities NB: You may use one of the standardised ERD notations.

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
Gregory Adam owns multiple theatres across South Africa. As a lover af the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develop a database for theatre management. The following information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three different types of artists that Gregory wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specific style they major in and the database should also keep track of their height. The database should, furthermore, keep track of each actor's hair colour and their number of years of acting experience. Gregory would like to support musicians by helping to keep track of the albums that they produce. One musician can have many albums and an album may have multiple musicians collaborating on it Each collaboration on an album should have a date. The data that needs to be stored for an album includes: Title, number of tracks and the price of the album. Given the informatilon above, draw an Extended Entity Relationship Diagram showing the following: • Entities, • Atributes, • All key attributes, • Data types for each attribute, and • All relationships between the entities NB: You may use one of the standardised ERD notations.
Transcribed Image Text:Gregory Adam owns multiple theatres across South Africa. As a lover af the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develop a database for theatre management. The following information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three different types of artists that Gregory wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specific style they major in and the database should also keep track of their height. The database should, furthermore, keep track of each actor's hair colour and their number of years of acting experience. Gregory would like to support musicians by helping to keep track of the albums that they produce. One musician can have many albums and an album may have multiple musicians collaborating on it Each collaboration on an album should have a date. The data that needs to be stored for an album includes: Title, number of tracks and the price of the album. Given the informatilon above, draw an Extended Entity Relationship Diagram showing the following: • Entities, • Atributes, • All key attributes, • Data types for each attribute, and • All relationships between the entities NB: You may use one of the standardised ERD notations.
Expert 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