Design and draw the ER diagram for the following system.

Saudi Arabia's General Entertainment Authority (GEA) has launched the Oasis Riyadh last January. In this assignment, you are asked to design and draw the E-R model for the Riyadh Oasis ticketing system. The system stores data about concerts and their tickets and stores data about customers.

Data requirements:

For each concert, the system stores: a unique concert id, the performing artists, a unique concert name, a unique 4 letter concert abbreviation (code), concert date, concert time, venue, and seat categories.

All concerts share the same set of seating categories: VIP, golden, silver, and guest. Different concerts set different prices for those categories. In addition, some concerts may offer a subset of the seating categories listed above. For example, a concert may have only golden and silver categories. Also, for each concert-category, the number of maximum allocated seats in that specific category is stored in the system.

For each artist, the system stores his\her unique artist id, name, fee, bank account number, and nationality.

For each venue, the system stores: a unique venue id, a unique venue name, total capacity, and location.

For each customer, the system stores the national id (or iqama id), customer name, phone number, and nationality.

Note that artists and customer ids follow different numbering systems.

For each concert ticket, a ticket number is a composite number that consists of the concert abbreviation code and a sequential number that starts from 1 onwards. An example of a ticket number is ACEN-000348, where ACEN is the code for Acoustic Energy Concert and 000348 is the sequential number of the ticket in the concert. Also, for each ticket, data about the concert, the ticket category, the date the ticket was purchased, and the customer name can be tracked.

Important notes:

1- Make sure that using your suggested design; it would be possible to retrieve the following information:

Given the ticket number, it would be possible to know the concert, the seating category, and the price of the ticket. All tickets bought by a specific customer The concerts held in a specific venue All the artists who performed in a specific venue

2- Follow the best practices in ER design. Optimize your design by avoiding common design pitfalls as you have been taught in the course so far.