How to Create Database using MySQL Workbench and XAMPP Server? 10 Minutes Full Tutorial Video

Get Database Homework Help Online or Database Assignment Help online from Database Expert.
Contact Us:
WhatsApp: +91 - EIGHT - FIVE - NINE - ONE - FIVE - TWO - TWO - FOUR - FIVE - SIX

The assessment is carried out on an individual level, and it is crucial that every student diligently follows the guidelines specified in the following sections. The topic is divided into two separate parts, and the ultimate outcomes depend on the given Assessment Scenario. The assigned assignment entails the analysis, design, and development of the database.

The final database must be implemented in any relational Database Management System (DBMS) of your choice. The assignment is comprised of two distinct components:
Part 1: Database design, optimization, and implementation - report (Learning Outcome 1)
Part 2: Demonstration of key design and implementation – video demo + source code/scripts (Learning Outcome 2)

Functional Requirements
1. Data Retrieval Functional Requirements
Based on the provided scenario, here are some data extraction functions your implementation should support for your database:
Retrieve Production Companies' Information:
• Get a list of all production companies in the European region.
• Retrieve specific details for a given production company, including its name, address, ZIP code, city, nation, organization type, number of employees, and net value.

Retrieve Shareholder Information:
• Obtain a list of shareholders for a particular production company.
• Retrieve details of a specific shareholder, encompassing essential information such as place of birth, name, personal telephone number, national insurance number, and passport number, among others.

Retrieve Employee Information:
• Get a list of all employees working for a specific production company.
• Retrieve details of a specific employee, including employee identification number, given name, surname, middle name (if available), date of birth, commencement date, contact information (telephone numbers and email address), and department affiliation.

Retrieve Compensation Information:
• Retrieve compensation details for crew members (actors, directors, and others), including hourly pay and bonuses.
• Obtain compensation details for staff members, including monthly wage, working hours, and department affiliation.

Retrieve Film Information:
• Get a list of all films produced by a particular production company.
• Retrieve details of a specific film, including its unique code, title, year of first release, and crew members involved (with their respective roles).

Grant Information:
• Retrieve a list of grants received by production companies, including the grant title, funding organization, maximum monetary value, and proposal submission deadline.
• Obtain details of a specific grant application, including the application date, desired amount, and the outcome (successful or unsuccessful).

2. Data Manipulation Functional Requirements
The function categories outlined above will help you extract valuable information from your database to support various research and analysis tasks related to movie production companies in Europe.

However, you should also provide the Add/Update/Delete functions for all those categories for adding new information, modifying existing information or removing the existing information from the database.