use the code below to create tabels. include screenshots CREATE TABLE PRICE ( PRICE_CODE                NUMBER(2,0)  PRIMARY KEY, PRICE_DESCRIPTION   VARCHAR2(20)  NOT NULL  , PRICE_RENTFEE                      NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) );   CREATE TABLE MOVIE ( MOVIE_NUM    NUMBER(8,0)  PRIMARY KEY, MOVIE_TITLE  VARCHAR2(75) NOT NULL, MOVIE_YEAR  NUMBER(4,0)  CHECK (MOVIE_YEAR > 1900), MOVIE_COST   NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE    NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM                   NUMBER(8,0) PRIMARY KEY, MEM_FNAME   VARCHAR2(30) NOT NULL, MEM_LNAME   VARCHAR2(30) NOT NULL, MEM_STREET  VARCHAR2(120), MEM_CITY                   VARCHAR2(50), MEM_STATE    CHAR(2), MEM_ZIP                     CHAR(5), MEM_BALANCE           NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1); INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3); INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1); INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5); MOVIE: INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);     RENTAL: INSERT INTO RENTAL VALUES (1001, '01-MAR-23', 103); INSERT INTO RENTAL VALUES (1002, '01-MAR-23', 105); INSERT INTO RENTAL VALUES (1003, '02-MAR-23', 102); INSERT INTO RENTAL VALUES (1004, '02-MAR-23', 110); INSERT INTO RENTAL VALUES (1006, '02-MAR-23', 107); INSERT INTO RENTAL VALUES (1007, '02-MAR-23', 104); INSERT INTO RENTAL VALUES (1008, '03-MAR-23', 105); INSERT INTO RENTAL VALUES (1009, '03-MAR-23', 111);

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

use the code below to create tabels. include screenshots

CREATE TABLE PRICE (

PRICE_CODE                NUMBER(2,0)  PRIMARY KEY,

PRICE_DESCRIPTION   VARCHAR2(20)  NOT NULL  ,

PRICE_RENTFEE                      NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0),

PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0)

);

 

CREATE TABLE MOVIE (

MOVIE_NUM    NUMBER(8,0)  PRIMARY KEY,

MOVIE_TITLE  VARCHAR2(75) NOT NULL,

MOVIE_YEAR  NUMBER(4,0)  CHECK (MOVIE_YEAR > 1900),

MOVIE_COST   NUMBER(5,2),

MOVIE_GENRE VARCHAR2(50),

PRICE_CODE    NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE

);

CREATE TABLE MEMBERSHIP (

MEM_NUM                   NUMBER(8,0) PRIMARY KEY,

MEM_FNAME   VARCHAR2(30) NOT NULL,

MEM_LNAME   VARCHAR2(30) NOT NULL,

MEM_STREET  VARCHAR2(120),

MEM_CITY                   VARCHAR2(50),

MEM_STATE    CHAR(2),

MEM_ZIP                     CHAR(5),

MEM_BALANCE           NUMBER(10,2)

);

PRICE:

INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);

INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3);

INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1);

INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5);

MOVIE:

INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2);

INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1);

INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2);

INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2);

INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL);

INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3);

INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);

 

 

RENTAL:

INSERT INTO RENTAL VALUES (1001, '01-MAR-23', 103);

INSERT INTO RENTAL VALUES (1002, '01-MAR-23', 105);

INSERT INTO RENTAL VALUES (1003, '02-MAR-23', 102);

INSERT INTO RENTAL VALUES (1004, '02-MAR-23', 110);

INSERT INTO RENTAL VALUES (1006, '02-MAR-23', 107);

INSERT INTO RENTAL VALUES (1007, '02-MAR-23', 104);

INSERT INTO RENTAL VALUES (1008, '03-MAR-23', 105);

INSERT INTO RENTAL VALUES (1009, '03-MAR-23', 111);

 

 

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education