As a database developer at the creative Developers Company (CDC), you got a new project to develop a cloud 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 hall for the selected movie, and 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. 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. Furthermore, each actor plays only one role in the movie and it contains SSN, name, gender and age of the actor. Movie Zone System required backup, securing and checking the internet service provider for their cloud database system after creating it. 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 available seats for each hall should be at least 40 seat. 2. If the customer did not fill in the nationality, fill it with "Jordanian" by default. 3. Do not reverse any movie without specifying its revenue. 4. Do not register any customer with the same email. Assignment activity and guidance Task 1: Design a Cloud-based Relational Database System 1.1 Outline user and system requirements in details based on the Cinema Movie Zone Database Cloud System. 1.2 Formulate the database system by: a- Designing the Entity Relational Model (ERM). In addition, list the enitites, their attributes, and the relationships between tables. b- Desigining the relational database which will include the database schema (fields, data types, and constraints), the mapped tables from the ERM, and identify the primary and foreign keys. 1.3 List what options could be applied for hosting the Cinema Movie Zone Cloud Database System by providing the following : a- Cloud based platforms. b- Cloud hosting security. c- Cloud hosting services. d- Cloud hosting vendors. 1.4 Make an inclusive design full with details using wireframe or any design tool, based on the cloud hosting you chose for the Cinema Movie Zone Cloud Database System. 1.5 Assess the effectiveness of your design related to your user and system requirements. Task 2: Implement the Relational Database System 2.1 Create the Relational Cloud Database System by using an appropriate Database Management System (DBMS). In additon, apply the validation and restrictions mentioned the vocational scenario. As well, build the input and output interfaces for your Cloud Database Management system. 2.2 After creating the Relational Database System, Deploy your relational cloud database system using an appropriate method. 2.3 Perform and apply security to your relational cloud database system. In addition, you need to ensure that your database secure and measurement by having a schedue backup,by representing your work with screenshots and explain how you applied it. 2.4 You need to check and explore the performance and measurements for your cloud database deployment based on your previous work for the cloud database system, by representing your work with screenshots and explain how you applied it. 2.5 At the end of your work, you need to measure the performance of security for your solution with user and system requirements. In addition, criticise the effectiveness for the chosen cloud hosted method. Recommended Resources Please note that the resources listed are examples for you to use as a starting point in your research the list is not definitive. Microsoft Visio Erdplus.com Draw.io AWS Microsoft SQL Server Management Studio Learning Outcomes and Assessment Criteria Pass Merit Distinction LO1 Design a cloud-based relational database system using appropriate design tools and methods for a substantial problem D1 Evaluate the effectiveness of the design in relation to user and system requirements, and the chosen cloud-hosting method. P1 Design a cloud-hosted relational database system using appropriate design tools and techniques, with clear statements of user and system requirements. P2 Identify options for hosting your database in the cloud and ensuring its security. M1 Produce a comprehensive design for a fully functional system with details of the cloud-hosting method chosen. LO2 Develop a fully functional relational database system, based on an existing system design and host it in the cloud. D2 Evaluate the effectiveness and security of the database solution in relation to user and system requirements, effectiveness of cloud-hosting method and suggest improvements. P3 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables using a structured query language. P4 Host the database system in the cloud using a suitable method. M2 Implement a fully functional database system that includes system security and database maintenance. M3 Analyse the performance, latency and accessibility of your cloud-based database.