Question: Here is the table: CREATE TABLE Showings( theaterID INT, showingDate DATE, startTime TIME, movieID INT, priceCode CHAR(1), PRIMARY KEY(theaterID, showingDate, startTime), ); I need to

Here is the table:

CREATE TABLE Showings(

theaterID INT,

showingDate DATE,

startTime TIME,

movieID INT,

priceCode CHAR(1),

PRIMARY KEY(theaterID, showingDate, startTime),

);

I need to add this constraint: "In Showings, if movieID is not NULL, then priceCode must also not be NULL"

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!

Q:

SQL VIEW AND QUERYVIEW, please read carefully and try not to make it too complex need 2.6.1 and 2.6.2 SQL Query Here are the tables: CREATE TABLE Movies( movieID INT, name VARCHAR(30) NOT NULL, year...

Q:

SQL Query Here are the tables: CREATE TABLE Movies( movieID INT, name VARCHAR(30) NOT NULL, year INT, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY KEY(movieID), UNIQUE(name, year) );...

Q:

SQL CHECK CONSTRAINT AND TEST CASE... SQL Query Here are the tables: CREATE TABLE Movies( movieID INT, name VARCHAR(30) NOT NULL, year INT, rating CHAR(1), length INT, totalEarned NUMERIC(7,2),...

Q:

create.sql DROP SCHEMA Lab4 CASCADE; CREATE SCHEMA Lab4; CREATE TABLE Movies( movieID INT, name VARCHAR(30) NOT NULL, year INT, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY...

Q:

create.sql DROP SCHEMA Lab4 CASCADE; CREATE SCHEMA Lab4; CREATE TABLE Movies( movieID INT, name VARCHAR(30) NOT NULL, year INT, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY...

Q:

Write SQL Statements 2. Description 2.1 Tables with Primary Keys The primary key for each table is underlined. Movies(movieID, name, year, rating, length, totalEarned) Theaters(theaterID, address,...

Q:

Writing Multiple SQL Queries RELATIONS: CREATE TABLE Movies( movieID INT, year INT UNIQUE, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY KEY(movieID) ); CREATE TABLE Theaters(...

Q:

WRITING POSTGRESQL QUERIES RELATIONS: CREATE TABLE Movies( movieID INT, year INT UNIQUE, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY KEY(movieID) ); CREATE TABLE Theaters( theaterID...

Q:

Writing Multiple SQL Queries RELATIONS: CREATE TABLE Movies( movieID INT, year INT UNIQUE, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY KEY(movieID) ); CREATE TABLE Theaters(...

Q:

WRITING POSTGRESQL QUERIES RELATIONS: CREATE TABLE Movies( movieID INT, year INT UNIQUE, rating CHAR(1), length INT, totalEarned NUMERIC(7,2), PRIMARY KEY(movieID) ); CREATE TABLE Theaters( theaterID...

Q:

Hearne Company has a number of potential capital investments. Because these projects vary in nature, initial investment, and time horizon, management is finding it difficult to compare them. Project...

Q:

Your spouse works at a middle school and reports rumors of a teacher, Zane Wilkens, molesting some students and taking ilicit pictures of them. Zane allegedly viewed these pictures in his office....

Q:

Convertible securities can usually be sold with interest rates _ _ _ _ _ _ _ _ _ other nonconvertible securities . Group of answer choices higher than lower than equal to with no relation to

Q:

Which persons are specifically exempt from the licensing act? Listers of real estate. Executors and Administrators. Part - time salespersons. War veterans.

Q:

4.19 A company specializes in installing and servicing central-heating furnaces. In the prewinter period, service calls may result in an order for a new furnace. The following table shows estimated...

Q:

4.18 An automobile dealer calculates the proportion of new cars sold that have been returned a various numbers of times for the correction of defects during the warranty period. The results are shown...

Q:

4.17 Consider the probability distribution function x 0 1 Probability 0.50 0.50 a. Graph the probability distribution function. b. Calculate and graph the cumulative probability distribution. c. Find...