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 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 aceuracy of the data cntered, 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 detault. 3. Do not reverse any movie without specifying its duration. 4. Do not register two customers with the same email. Assignment activity and guidance Task1: Designing Database System As a first stage, the first task assigned to you is to design the database system, you are required to perfom the following: 1. Investigate and document at least 10 system and user requirements based on the given seenario. 2. Oatline the database system by designing an appropriate Entity Relationship Diagrarn (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). 4. Check whether the provided design is normalized. If not, normalize the database by removing the anomalies. 5. Design set of simple input and eutput (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. Task 2: Implementing the database system 1. Choose an appropriate database management system (DBMS) 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 helpful information acconding to their needs, perform SQL 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 companies ordered by name, in ascending order. 3. Details of each movie, including its producing company name and mobile number. 4. Details of the movie with the highest revenoe. 2. Consider the user requirements of a cinema manager, analyze and sbow how your implemented system heips the manager extracting the information they need. Therefore, you need to create queries that prevides a jroof that your systcm allows the managers to extract such information. In addition, explain the toults of your queries and show how your queries satisfied the manager's request. 4.Create simple interfaces to insert, update and delete data in the database, for each entity You need to apply security to the implemented database by adding a strong password. Task 3: Evaluating the database system 1. Based on the user and system requirements, measure the implemented database solution by listing each requirement along with where il was met and how it was achieved. In addition, recomenend improvements based on the assessment 2. After implementing the database systern, you need to test it by performing the following: a. Report the test plan that you want to follow by identifying clements of the system that need to be lessed and considering data that should be ared to fully fest the system. b. List the procedures to be ased in testing (white box tosting, Muck box testing) c. Based on the tex plan you have given in the poevious point, chock the system against user and system requirements. In addition, provide relesant test cases (at least 5 test cases) for the database you have implemented. d. Evaluate the effectiveness of your testing, by showing how were your tost cases helpful to find out if the system is correct and oomplete or not. 3. Assess the implemented database by discussing improvements that could be made over the system, keeping its quality attributes like scahahility and maintainability. You are ako required to document your work and generate an organized technical documentation that inclodes system requirements and functionalities, flewchart diagram. user manual, interfaces and so oa
