I need to solve these questions in order of database
3. Create the relational database which includes: 3.1 List of tables mapped from the ERD 3.2 Database schema which includes the fields, datatypes and constraints (data validation), identifiers (primary keys and foreign keys). 4. Check whether the provided design is normalized. If not, normalize the database by removing the anomalies. 5. Design set of simple input and output (reports) interfaces for the project using Wireframe or any interface-designing tool. 6. Assess and validate your design with respect to given requirements, check whether all requirements are satisfied, show details on how you did your assessment. Task1: Designing Database System As a first stage, the first task assigned to you is to design the database system, you are required to perform the following: 1. Investigate and document at least 10 system and user requirements based on the given scenario. 2. Outline the database system by designing an appropriate Entity Relationship Diagram (ERD) 3. Create the relational database which includes: 3.1.List of tables mapped from the ERD 3.2 Database schema which includes the fields, datatypes and constraints (data validation), identifiers (primary keys and foreign keys). \begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ Unit Learning Outcomes } \\ \hline LO1 & Use an appropriate design tool to design a relational database system for a substantial problem. \\ \hline LO2 & Develop a fully functional relational database system, based on an existing system design. \\ \hline LO3 & Test the system against user and system requirements. \\ \hline LO4 & Produce fechnical and user documentation \\ \hline Transferable skills and competencies developed \\ 1. Designing a good database system \\ 2. Building an efficient database system \\ 3. \\ 4. Studying user and system requirements Testing the database \\ \hline \end{tabular} 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 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 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 more than one movie. Also, Movie Zone deals with a range of 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 more than one movie. Also, Movie Zone deals with a range of production companies and are identified by id, name, address and phone number. The production company produces one or movies, and the film is related to only one production company. There is 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. The revenue of each film must not be less than $100
