I need to solve these questions in an organized way for 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 movie, including its producing 3. Details of each movie, including its producing company name and mobile number. 4. Details of the movie 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. 4.Create simple interfaces to insert, update and delete data in the database, for each entity ou need to apply security to the implemented database by adding a strong assword. Transferable skills and competencies developed 1. Designing a good database system 2. Building an efficient database system 3. Studying user and system requirements 4. Testing the database 1. Requirements analysis skills 2. Designing a good database system 3. Building an efficient database system Vocational scenario: As a database developer at the creative Developers Company (CDC), you got a new project to develop a database system for a Cinema named the Movie Zone. CDC Company conducted a meeting with the Movie As a database developer at the creative Developers Company (CDC), you got a new project to develop a database system for a Cinema named the Movie Zone. CDC Company conducted a meeting with the Movie Zone General Manager and they required a System for their staff to ease and organize the process of movies reservation. The Movie Zone General Manager requires a system that allows the customer to search for a movie, know the genre for the selected movie, reserve a movie and other additional services. To reserve a movie at Movie Zone Company, the customer must have an To reserve a movie at Movie Zone Company, the customer must have an account that has a unique National ID, name (first name, mid name, last name), phone number (one or more), age, gender, address, nationality, and date of birth. Each customer can reserve more than one movie. In addition, many customers can reserve many movies. Each movie is described by movie title, movie id, duration, revenue and year. In Movie Zone Cinema, a movie has one or many genre, each of which is identified by genre id, and genre name. One Genre can be related for ind system requirements, and uggest improvements