Question: 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
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 1-user and system requirements in details based on the Cinema Movie Zone Database Cloud System
2-Designing the Entity Relational Model (ERM). In addition, list the enitites, their attributes, and the relationships between tables.
3-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.
4-
what options could be applied for hosting the Cinema Movie Zone Cloud Database System by providing the following :
Cloud based platforms.
Cloud hosting security.
Cloud hosting services.
Cloud hosting vendors
5-
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.
6-Assess the effectiveness of your design related to your user and system requirements
7-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.
8-After creating the Relational Database System, Deploy your relational cloud database system using an appropriate method. please i need full answer for this quastion
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
