$2$y$/5$

ection $2\mathrm{.}13-$ BUSA $200$: Database Fundamentals $|$zy

KLINBUSA$200$Spring$2024$E$/$chapter$/2/$section$/18$

$00$: Database Fundamentals home $=>2.J3.$LAB $-$ Create Movie table

$2\mathrm{.}13$ LAB $-$ Create Movie table

Create a Movie table with the following columns

ID $-$ positive integer with maximum value of $50,000$

Title $-$ variable$-$length string with up to $50$ characters

Rating $-$ fixed$-$length string with $4$ characters

ReleaseDate$-$date

Budget $-$ decimal value representing a cost of up to $999,999$ dollars, with $2$ digits

Note: Your SQL code does not display any results in Develop mode Use Submit mode

LAB ACTIVITY

$2\mathrm{.}13\mathrm{.}1$: LAB $-$ Create Movie table

Main.sql

CREATE TABLE Movie

ID INT NOT NULL,

$4$ RATING CHAR $(4),$

$5$ ReleaseDATE DATE

$7$ PRIMARY KEY $($ID$)$

$8)$;