Database

1. Choose an appropriate database management system (DBMS) to design the required database system based on the relational database you designed in the first task. Also, implement the validation methods mentioned in the scenario. Also, consider the validations methods inside the interfaces such as using the drop-down list. 2. The system should provide the user with helpful information according to their needs, perform SQL queries over your implemented database that retrieves the following information (this question will be graded by observation). 1. Female customer's information, including national ID, name, phone number. 2. Details of production companies ordered by name, in ascending order. 3. Details of each movic, including its producing company name and mobile number. 4. Details of the movic with the highest revenue. 2. Consider the user requirements of a cinema manager, analyze and show how your implemented system helps the manager extracting the information they need. Therefore, you need to create queries that provides a proof that your system allows the managers to extract such information. In addition, explain the results of your queries and show how your queries satisfied the manager's request