Question: Can I get answer to these question. Create a new schema - Call it VIDEOS Create two new tables using NAVIGATOR in MYSQL WORKBENCH with

Can I get answer to these question.

Create a new schema - Call it VIDEOS
Create two new tables using NAVIGATOR in MYSQL WORKBENCH with the following fields and do not forget to create a primary key for each of the following tables.

[Important: Select the appropriate data type and choose constraints appropriately].

a. friends: FriendID, Lastname, Firstname, Address, City, State, PostalCode, HomePhone

b. video collection: VideoCollectionID, MovieTitle, YearReleased, Rating, Subject, Length, Note.

Consider the database VIDEOS that you created above. Check your tables for 3NF. If they are not in 3NF, modify your database so that your tables are devoid of partial and transitive dependencies.

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!

DAD 2 2 0 Project One Complete the steps below to create three tables named Customers, Orders, and RMA, in the QuantigrationUpdates database. Specifically, you must address the following rubric...

Hi guys, I am trying to properly answer an accounting question concerning shares, bonds, and stock. I was given two annual reports, and am asked to make a decision on one of the companies depending...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

CONTENTS COVID SAFETY ON CAMPUS 2 WHAT IS THE UNIT ABOUT? 3 UNIT DESCRIPTION 3 INTENDED LEARNING OUTCOMES 3 ACKNOWLEDGEMENT OF COUNTRY 3 GRADUATE STATEMENT 4 ALTERATIONS TO THE UNIT AS A RESULT OF...

>>> Hello! I have the following sql code to create a new procedure called InsertCustomerWithTransaction. DELIMITER // CREATE PROCEDURE InsertCustomerWithTransaction (IN newCustomerLastName Char(25),...

STEP 1: Create Data Dictionary for provided elements As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used....

4. Set your new DB to become the default database as shown below: MySQL Workbench Local instance MySQL56 X File Edit View Query Database Server Tools Scripting Help . Navigator SCHEMAS a Fiter...

LINK TO SQL DATA HERE ( had to add a space in between so it does not get blocked) https://drive.go ogle.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing TABLE SQL DATA BELOW -- MySQL...

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...

Need help as soon as possible on these SQL statements as. I have provided the tables containing all of the data from the entire database below the questions. I'm using mySQL Workbench as shown below....

Propose a structure for the compound that has the following spectra: NMR: 81.28 (3H, t, J = 7 Hz); 8 3.91 (2H, q, J = 7 Hz): 85.0 (1H. d. J=4 Hz); 86.49 (1H. d. J= 4 Hz) ppm IR: 3100, 1644 (strong),...

Find the kinetic energy of the a-particle emitted in the decay 28 Pu 234U+ a. The atomic masses needed are as follows: 238 Pu 234 U 238 04955 u 234 04095 u Neglect any recoil of the residual nucleus....

What is the payment on a 6 0 - month, $ 1 0 , 0 0 0 car loan with APR of 9 . 1 3 % ? Round your answer to the nearest cent ( one - hundredth ) . Do not include the dollar sign, $ .

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...