Wait Lerarning Oulcumes L.01 problent. druign. I.xit Prodace techakcal and wer tevineaturin Tranferxlle shilly and cumpetencles developed 1. Designing a good drtabuse system 2. Fluilding an elficicmi database system 3. Sesdying uset and syzhem requirtments 4. Testing the darahase 1. Roguirements analysis skills 2. Designing a gocd 4vabarse systern 3. Building an eflicicnt database system Vocational scemarias As a database developer at the creative Developers Coenpuny (CDC) you got a new project to develop a database system for a Cinema numed the Movic Zone. CDC Company conducted a mecting with the Mosic Zone General Manager and they required a System for their staff to case and organiae the process of movies reservation. The Movie Zone General Manager requines a systen that allows the cussomit to search for a movic, know the gcnite for the selected movic, rescrve a movie and other additional services. To reserve a movie at Movie Zone Company, the customser 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, nationaliry, and dute 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, movic id, daration, revenue and year. In Movie Zone Cinema, a movie has one or many gense, each of which is identified by genire id, and genre name. Ooe Genre can be related for more than one movic. Also. Movie. Zone deals with a range of prodoction companies and are identified by id, name, address and phone number. The production company produces one or more 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 2. If the customer did not fill in the nationality fill it with "Jordanian" by default. 3. Do not reverse any movie withoul specifying its daration. 4. Do not register two customers with the same email. Assienment actisity and guidance Task1: Designing Database System As a first stage, the first task assigned to yoe is so design the database system, you are required vo perform the following 1. Investigate and document at least 10 system and aser requirements based on the given scenario. Task1: Designing Database System As a first stage, the first task assigned to you is so devign the database system, you are required to perform the following: 1. Investigane and document at least 10 syshen and user requinements based on the given scenario. 2. Outline the database systera by designies an appropriate Entity Relationship Duggrams (ERD) 3. Create the relational database which inclodes: 3.1 L.ist of tables mapped froen the ERD 3.2 Database schema w tuich inclodes the ficlds, datarypes and constraints (data validation), identifers (frimary keys and fivreigs keys). 4. Check whether the provided design is sormalirnd. If not, normalize the database by removing the anomalies. 5. Design set of simple input and eutput (roports) interfaces for the project using Wireframe or any interface-designing toel. 6. Assess and validale your design with tespect to given requirements, check whether all fequirements are satisfied. show details on how yoe did your assessment. Task 2: Implementing the database system 1. Choose an eppropriate database management system (DEMS) 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 helphul information according to their needs, perform SOL 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 coenganies ordered by name, in ascending order. 3. Details of cach movic, including its preducing compasy nanc and mobile number. 4. Details of the movic with the kiphest revenwe