Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Having trouble with the code below. I am building a Vertical Database Partitioning. I am building a new table cast_bio from the movie_cast table (i.e.,

Having trouble with the code below.  I am building a Vertical Database Partitioning.  I am building a new table cast_bio from the movie_cast table (i.e., columns in cast_bio will be a subset of those in movie_cast). I will have to insert into the new cast_bio that the values are unique.  This is cast_bio table I need to build with values I will pull from the movie_cast table.


cast_bio 1. cast_id (integer) 2. cast_name (text) 3. birthday (date) 4. popularity (real)


# Part a.iii Vertical Database Partitioning [5 points]

    def part_aiii(self,connection):

        ############### EDIT CREATE TABLE SQL STATEMENT ###################################

        part_aiii_sql = ""

        ######################################################################

        

        self.execute_query(connection, part_aiii_sql)

        

        ############### CREATE IMPORT CODE BELOW ############################

        part_aiii_insert_sql = ""

        ######################################################################

        

So I have a table named movie_cast table and the values in movie_ cast are     (movie_id integer, cast_id integer, cast_name text, birthday text, popularity real);";  I need to edit that table using the Veritcal Database Partitioning with a new table labeled cast_bio.  This table will have 1. cast_id (integer) 2. cast_name (text) 3. birthday (date) 4. popularity (real).  So I will input them in the Edit Table and Create Table area that is comment out.

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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

More Books

Students also viewed these Databases questions

Question

What life events might trigger your entrepreneurial career?

Answered: 1 week ago

Question

d. How does a listener encourage a speaker to speak?

Answered: 1 week ago