Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

s a database developer at the creative Developers Company (CDC), you got a new project to develop a cloud database system for a Cinema named

s 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. Designing the Entity Relational Model (ERM). Desigining the relational database which will include the database schema (fields, data types, and constraints)

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inductive Databases And Constraint Based Data Mining

Authors: Saso Dzeroski ,Bart Goethals ,Pance Panov

2010th Edition

1489982175, 978-1489982179

More Books

Students also viewed these Databases questions