Please answer theTask 2, I have posted it more than once on the site and all the answers were wrong Suppose you are a database developer at a XYZ data development company, you got a new project to develop a database system. The system is a ticket booking system for attending Jerash Festival. This system includes a set of tickets that contains different set of prices. Each ticket is related to one singer and one theatre. A theatre is related to one singer only, and the theatre belongs to one singer. 

As well, each ticket belongs to a specific category. The tickets are described by the type, price, duration, and singer who will recall the concert and a unique ID. There is many theaters and each theater has an ID, size and name. 

The singers are characterized by name (first name, last name), nationality, Singer ID and band. In addition, this system has users (clients) who can register and create an account to choose their favorite singers to attend their concert. Each user (client) is identified by a unique e-mail and has password, name, country, birthdate and gender. A client can book one or many tickets at the festival. 

The clients need some security applied to the database such as password. In addition, they requested to perform the following operations using the database system: 

1. Registration and deletion of users accounts.
2. Browsing through the system (website) to search the available tickets to the required singer with the prices.
3. Adding, deleting and updating tickets.
4. Updating the users favorite list of singers.
5. System displaying the following:
   • All tickets sorted by type (such as golden ticket, silver ticket and black ticket).
   • All singers and which theaters these singers will recall the concert in.
   • The number of listed singers in ascending order.
   • The number of tickets recorded for each client.
   • All singers, theaters, and tickets all ordered in descending order by singer, ticket type.
   • The clients who have bought the golden ticket more than twice, and if so, how many clients were recorded?

6. Your manager asked you to suggest additional queries that may ease the process of management and produce appropriate management information in order to help the festival manager to manage the festival and help the signers to be at their correct theaters as well help the clients to attend the signers concerts.

In addition, the clients specify a list of rules and restrictions that must be applied to the developed database to ensure the accuracy of the data entered, which are as follows: 

1. Do not include any ticket without specifying its type and price.
2. If the client does not fill ticket type, then fill it with "Black", by default.
3. Each theatre must at least contain one singer.
4. Do not register user with the same email.

Assignment activity and guidance

The main tasks assigned to you are listed below, be sure to document your work in an organized documentation with a detailed description of the features and operations of your system

Task 2: Testing the database system

5. Create a simple interface to insert, update and delete data in the database and implement the validation methods explained in the requirements.

6. Test the system against user and system requirements and provide relevant test cases for the database you have implemented. Mention all the implemented database solution in regards to the user and system requirements, List each requirement in a table along with where it was met and how it was achieved in the implementation phase.

7. Make recommendations and suggestions for improvements in a separate conclusion/recommendations section based on the assessment.

8. Analyze the importance and effectiveness of the testing, how the test data will be meaningful through the testing process.

9. Prepare a fully functional system diagram that represents the steps of data through the system utilizing flowchart diagram.

10. Evaluate any future enhancements and recommendations for improvements to improve efficiency in system.