Question: SQL table for the list below, i got the data i just want help on the table approach thank you Your first task is to

SQL table for the list below, i got the data i just want help on the table approach thank you

Your first task is to create new database tables deployment script for your report data. You will work with these tables for the rest of the challenge. It is up to you how to structure/name/index/test/document the tables, and how many tables to make.

We want you to create tables that can provide pre-computed data and answer for the following questions:

- For all data, What are the names of the characters? How many characters are there?

- For each season, which character has the most lines?

- For each season, what is the number of times a "That's what she said" joke comes up?

- For each season, what is the average percent of lines each character contributed per episode?

- For each character, what is the average number of words per line?

- For each character, what is the most common word?

- For each character, what is the number of episodes where the character does not have a line?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

CIS 3650 Database Management Systems 2. Entity relationship diagram that documents the database design. The diagram should use the Fall 2022 Group Project appropriate crow's foot notation including...

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

S10_Chap7_RQ_WPC-Database Lab This assignment is from the Kroenke book Chap 7 Review Questions (RQ). Create a new folder, WPC-Database, in the Projects folder, found in the SQL Server Management...

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

In this assignment you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data...

SEED Labs - SQL Injection Attack Lab 3.1 Task 1: Get Familiar with SQL Statements The objective of this task is to get familiar with SQL commands by playing with the provided database. We have...

please i need help 1. Databan creates The instruction to a task No. 1 1) Start the Star Office program, choose Database 2) Dialog box "Database Wizard will open on the first step you choose Create...

CSC 2 6 6 0 Project Part 3 You ve submitted the ER Diagram below to the deciding parties at the health clinic. The decision was to go ahead and build the database in MySQL based on the ER Diagram and...

please i need help to make this The instruction to a task No. 1 1 Database create 1) Start the Star Office program, choose Database ) Dialog box Database Ward will open on the first step you choose...

If you create a regression model for predicting the sales ($ million) from money spent on advertising the prior month ($ thousand), is the slope most likely to be closer to 0.03, 300, or 3000?...

The following situations should be considered independently. 1. John Jamison wants to accumulate $60,000 for a down payment on a small business. He will invest $30,000 today in a bank account paying...

Which of the following is not a characteristic of the corporate form of organization? Question 3 7 options: A ) Shareholders are not personally responsible for the debts of the corporation. B )...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. Determine the organizations readiness for ADR. Is ADR consistent with the organizations culture and other HR processes? There needs to be a good match between culture and process for ADR to work.

LO5 Understand the use of policies, procedures, and employee handbooks to communicate workplace behavior and performance expectations.

2. What are some of the things Henry Ford did that you think have merit? If you were running a company, what practices of his might you adopt?