Question: write SQL syntax for description : Movie movie_id an integer and primary key for the Movie table. movie_title- a character field that allows for up

write SQL syntax for description :

Movie movie_id an integer and primary key for the Movie table. movie_title- a character field that allows for up to 100 characters. This field should always have a value. director_last_name a character field that allows for up to 50 characters. This field should always have a value. director_first_name a character field that allows for up to 50 characters. This field should always have a value. genre a character field that allows for up to 20 characters that should always contain a value from the following list of genres: Action, Adventure, Comedy, Romance, Science Fiction, Documentary, Drama, Horror. media_type a character field of up to 20 characters that can contain a value from the following list of mediums: DVD, Blu-Ray. release_date a date field. studio_name a character field that allows for up to 50 characters. retail_price A real field that should always have a positive value. current_stock An integer field that should have a value of 0 or more.

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!

Designing a database and populating data Multiple sclerosis, also known as MS, is a chronic inflammatory disease that attacks the central nervous system (the brain, spinal cord and optic nerves), and...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

Lab 7: Inserting and Updating Data OVERVIEW This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current...

And Below is the script provided /* Modifications: (1) Removed DELETE FROM and RESEED commands from script; 1/3/13 by glh */ /* PLEASE READ THE INSTRUCTIONS FOR LAB # 7 BEFORE EXECUTING */ /* Insert...

PART 1: ALREADY COMPLETED. NEED PART 2 Tasks Query Description SQL Statement Create a new database in MySQL called horsestable. List the databases in MySql. Result set should look like: Create...

To complete this assignment, submit the following two files: An SQL file (i.e. save the file with file extension .sql) containing the SQL written to perform the tasks. An exported SQL file using...

Using MySQL Workbench SELECT commands answer the questions listed below using the Tiny Video schema used in your previous assignment. Submit via the D2L drop box the final SQL script for each...

HERE IS THE TINY VIDEO SCHEMA FOR MYSQL WORKBENCH /* Database Systems, 9th Ed., Coronel/MOrris/Rob */ /* Type of SQL : MySQL */ CREATE SCHEMA IF NOT EXISTS TINY_VIDEO; USE TINY_VIDEO; DROP TABLE IF...

The purpose of this assignment is to use an affinity diagram to brainstorm and identify root causes of the organizational problem and potential solutions for addressing it. Now that you have...

Solve Prob. 4.146 subject to the restriction that H must lie on the y axis. Problem 4.146: Two 3 6-Ã ft plywood panels each weighing 30 lb are nailed together as shown. The panels are...

someone in a 3 4 percent tax bracket can earn 7 percent annually on her investments in a taxable ira account. what will be the one time 1 0 , 0 0 0 investment in 1 2 years?

The sales manager of Trishas Global Marketing (TGM) is considering expanding sales by taking their Original Widget and modifying it for export into the European and Asian markets. Relatively minor...

Incorporate government into the table by assuming that it plans to tax and spend $20 billion at each possible level of GDP. Also assume that the tax is a personal tax and that government spending...

Fill in columns 5 and 6 and determine the equilibrium GDP for the open economy. Explain why this equilibrium GDP differs from that of the closed economy. c. Given the original $20 billion level of...

Why is the long-run aggregate supply curve vertical? Explain the shape of the short-run aggregate supply curve. Why is the short-run curve relatively flat to the left of the full-employment output...