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...

Extracted 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.