Now that you have created your relational database for each focus question, add some data, at least ten records each. Ensure you have created the necessary relationships and identify them. Create at least two queries (you may have more depending on your question and data) for each question to help you analyze or answer the focus question. Include the details about each query by writing a paragraph explaining what the query to provide and how this relates to the question.

Focus Question 1: Crowdfunding Impact on Independent Filmmaking

Explanation:

This question seeks to understand how crowdfunding has influenced independent filmmakers' ability to fund their projects and navigate financial constraints.

Fact Table: Film Projects

• This fact table will contain information about individual film projects that have used crowdfunding for funding. It will include details like project ID, title, budget, and other project-specific data.

Dimension Tables:

1. Crowdfunding Platform (with statistics)

This dimension table stores data related to crowdfunding platforms, including statistics such as the number of film projects funded, success rates, and platform-specific information. It is linked to the fact table through the crowdfunding platform ID.

1. Independent Filmmaker (with case study data)

This dimension table contains information about independent filmmakers who have used crowdfunding for their projects. It includes filmmaker ID, name, background, and case study data that provides insights into their crowdfunding experiences. It is linked to the fact table through the filmmaker ID.

1. Film Industry Reports

This dimension table stores data from industry reports on the role of crowdfunding in the film industry. It includes report ID, publication date, key findings, and relevant statistics. This table is linked to the fact table through references to specific reports.

Primary Keys:

• Film Project ID (Fact Table): A unique identifier for each film project.
• Crowdfunding Platform ID: A unique identifier for each crowdfunding platform.
• Independent Filmmaker ID: A unique identifier for each independent filmmaker.

Foreign Keys:

• Crowdfunding Platform ID (Fact Table -> Crowdfunding Platform): Links the film project to the crowdfunding platform used.
• Independent Filmmaker ID (Fact Table -> Independent Filmmaker): Links the film project to the independent filmmaker who initiated it.

Relationships:

• Many-to-One: Crowdfunding Platform to Film Projects
• Many-to-One: Independent Filmmaker to Film Projects

Explanation:

By connecting data about film projects, crowdfunding platforms, independent filmmakers, and industry reports, you can analyze the impact of crowdfunding on independent filmmaking. You can track the success of crowdfunding campaigns, identify trends, and assess how these advancements help overcome financial constraints.

ERD:

Film Projects ---< Crowdfunding Platform >--- Crowdfunding Platform

|

V

Independent Filmmaker

|

V

Film Industry Reports

Focus Question 2: Director's Cuts and Regulatory Constraints

Explanation:

This question aims to identify films that encountered regulatory constraints and took alternative content approaches, such as releasing director's cuts or unrated versions, and analyze the impact on reception and profitability.

Fact Table: Films

• This fact table contains information about individual films, including details such as film ID, title, release date, and other film-specific data.

Dimension Tables:

1. Content Alterations (e.g., Director's Cuts, Unrated Versions)

This dimension table stores data related to content alterations made to films, including information about director's cuts, unrated versions, or other changes made due to regulatory constraints. It is linked to the fact table through the content alterations ID.

1. Box Office and Streaming Data

This dimension table contains data on box office revenue and streaming revenue for films. It includes details like revenue figures, release dates, and distribution channels. It is linked to the fact table through the box office data ID.

1. Audience and Critic Reviews

This dimension table stores audience and critic reviews for films, both before and after content alterations. It includes review IDs, review content, and ratings. It is linked to the fact table through the review ID.

Primary Keys:

• Film ID (Fact Table): A unique identifier for each film.
• Content Alterations ID: A unique identifier for each content alteration entry.
• Box Office Data ID: A unique identifier for each box office and streaming data entry.
• Review ID: A unique identifier for each review entry.

Foreign Keys:

• Content Alterations ID (Fact Table -> Content Alterations): Links each film to its content alterations.
• Box Office Data ID (Fact Table -> Box Office and Streaming Data): Links each film to its revenue data.
• Review ID (Fact Table -> Audience and Critic Reviews): Links each film to its reviews.

Relationships:

• Many-to-One: Content Alterations to Films
• Many-to-One: Box Office and Streaming Data to Films
• Many-to-One: Audience and Critic Reviews to Films

Explanation:

This data structure allows you to identify films that underwent content alterations due to regulatory constraints, track their financial performance, and analyze changes in audience and critic reception.

ERD:

Films ------------- < Content Alterations >------------- Content Alterations

| |

V V

Box Office Data Audience and Critic Reviews

Focus Question 3: Technology Partnerships in Filmmaking

Explanation:

This question explores how partnerships with tech companies impact filmmakers by providing access to advanced technology and managing production costs.

Fact Table: Filmmaking Partnerships

• This fact table contains information about partnerships between filmmakers or production companies and technology companies. It includes details like partnership ID, date, and partnership-specific data.

Dimension Tables:

1. Filmmakers or Production Companies (with tech partnership data)

This dimension table contains information about filmmakers or production companies that have partnered with tech companies. It includes IDs, names, and details about the partnerships. It is linked to the fact table through the filmmaker/production company ID.

1. Financial Reports or Case Studies

This dimension table stores financial reports or case studies on the impact of technology partnerships on film production costs and outcomes. It includes report IDs, data, and findings. It is linked to the fact table through references to specific reports.

1. Technology Adoption Research

This dimension table contains data from research on the adoption of new technology in the film industry. It includes research IDs, publication dates, and key findings. It is linked to the fact table through references to specific research.

Primary Keys:

• Filmmaking Partnership ID (Fact Table): A unique identifier for each partnership entry.
• Filmmaker/Production Company ID: A unique identifier for each filmmaker or production company.
• Financial Report/Case Study ID: A unique identifier for each financial report or case study entry.
• Technology Adoption Research ID: A unique identifier for each research entry.

Foreign Keys:

• Filmmaker/Production Company ID (Fact Table -> Filmmakers or Production Companies): Links each partnership to the involved filmmaker/production company.
• Financial Report/Case Study ID (Fact Table -> Financial Reports or Case Studies): Links each partnership to relevant financial reports or case studies.
• Technology Adoption Research ID (Fact Table -> Technology Adoption Research): Links each partnership to relevant technology adoption research.

Relationships:

• Many-to-One: Filmmakers or Production Companies to Filmmaking Partnerships
• Many-to-One: Financial Reports or Case Studies to Filmmaking Partnerships
• Many-to-One: Technology Adoption Research to Filmmaking Partnerships

Explanation:

This data structure allows you to analyze the impact of technology partnerships on film production, cost management, and the adoption of new technologies in the industry.

ERD:

Filmmaking Partnerships ------------< Filmmakers or Production Companies >------- Filmmakers or Production Companies

| |

V V

Financial Reports or Case Studies Technology Adoption Research

Changing Landscape of Movie Distribution

Explanation:

This question explores changes in movie distribution, particularly with the rise of streaming platforms, and how these changes impact revenue collection.

Fact Table: Films

Dimension Tables:

1. Distribution Channels (e.g., Theaters, Streaming, DVD/Blu-ray)
2. Industry Reports
3. Filmmaker/Studio Statements

Primary Keys:

• Film ID (Fact Table)
• Distribution Channel ID
• Industry Report ID
• Filmmaker/Studio Statement ID

Foreign Keys:

• Distribution Channel ID (Fact Table -> Distribution Channels)
• Industry Report ID (Fact Table -> Industry Reports)
• Filmmaker/Studio Statement ID (Fact Table -> Filmmaker/Studio Statements)

Relationships:

• Many-to-One: Distribution Channels to Films
• Many-to-One: Industry Reports to Films
• Many-to-One: Filmmaker/Studio Statements to Films

Explanation:

This data structure allows you to analyze how changes in movie distribution channels affect revenue collection, as well as how filmmakers and studios adapt to the evolving landscape.

ERD:

Films ---------------< Distribution Channels >------- Distribution Channels

| |

V V

Industry Reports Filmmaker/Studio Statements

The key data elements and relationships:

Focus Question 1: Crowdfunding Impact on Independent Filmmaking

• Data Elements: Film Projects, Crowdfunding Platform Stats, Independent Filmmaker Info, Film Industry Reports
• Relationships: Many-to-One between Film Projects and Crowdfunding Platform, Many-to-One between Film Projects and Independent Filmmaker.

Focus Question 2: Director's Cuts and Regulatory Constraints

• Data Elements: Films, Content Alterations, Box Office and Streaming Data, Audience and Critic Reviews
• Relationships: Many-to-One between Films and Content Alterations, Box Office and Streaming Data, Audience, and Critic Reviews.

Focus Question 3: Technology Partnerships in Filmmaking

• Data Elements: Filmmaking Partnerships, Filmmakers/Production Companies, Financial Reports/Case Studies, Technology Adoption Research
• Relationships: Many-to-One between Filmmaking Partnerships and Filmmakers/Production Companies, Financial Reports/Case Studies, Technology Adoption Research.

Changing Landscape of Movie Distribution

• Data Elements: Films, Distribution Channels, Industry Reports, Filmmaker/Studio Statements
• Relationships: Many-to-One between Films and Distribution Channels, Industry Reports, Filmmaker/Studio Statements.