IT 234 IT234 Unit 5 Assignment (Kaplan University)

IT 234 IT234 Unit 5 Assignment (Kaplan University)

BUY HERE⬊

http://mxstudent.com/it-234-it234-unit-5-assignment-kaplan-university/

1. Create a new Table: added MovieReview with two columns and a primary key

2. Add a new column Added MovieReviewCategory and the column Director_ID to the table MovieReview.

3. Add Foreign Keys Director_Id referencing table Director

4. Remove a column Drop the column MovieReviewcategory

5. Make 4 more changes:

6. New Physical Model

a. Table Director, columns, Primary and Foreign Keys

b. Table Genre and Lead_Star, columns, Primary and Foreign Keys

c. Table MovieReview, Columns, Primary and Foreign Keys

d. Table Movies, Columns, Primary and Foreign Keys

e. Table Title, Columns, Primary and Foreign keys.