1. CREATE TABLE `assignment`.`membership` ( `Mem_Num` INT NOT NULL, `Mem_Fname` VARCHAR(45) NOT NULL, `Mem_Lname` VARCHAR(45) NOT NULL, `Mem_Street` VARCHAR(45) NOT NULL, `Mem_Street` VARCHAR(45) NOT NULL, `Mem_State` VARCHAR(45) NOT NULL, `Mem_Zip` INT NOT NULL, `Mem_Balance` INT NOT NULL, PRIMARY KEY (`Mem_Num`)); 2. CREATE TABLE `assignment`.`rental` ( `Rent_Num` INT NOT NULL, `Rent_Date` DATE NOT NULL, `Mem_Num` INT NOT NULL, PRIMARY KEY (`Rent_Num`)); 3. CREATE TABLE `assignment`.`movie` ( `Movie_Num` INT NOT NULL, `Movie_Name` VARCHAR(45) NOT NULL, `Movie_Year` YEAR NOT NULL, `Movie_Cost` INT NOT NULL, `Movie_Genre` VARCHAR(45) NOT NULL, `Price_Code` INT NOT NULL, PRIMARY KEY (`Movie_Num`)); 4. CREATE TABLE `assignment`.`price` ( `Price_Code` INT NOT NULL, `Price_Description` VARCHAR(45) NOT NULL, `Price_Rentfee` INT NOT NULL, `Price_Dailylatefee` INT NOT NULL, PRIMARY KEY (`Price_Code`));

Membership insert into membership values (102, "Tami", "Dawson", "2632 Takli Circle", "Norene", "TN", 37136, 11); insert into membership values (103, "Curt", "Knight", "4025 Cornell Court", "Flatgap", "KY", 41219, 6); insert into membership values (104, "Jamal", "Melendez", "788 East 145th Avenue", "Quebeck", "TN", 38579, 0); insert into membership values (104, "Jamal", "Melendez", "788 East 145th Avenue", "Quebeck", "TN", 38579, 0); insert into membership values (106, "Miranda", "Parks", "4469 Maxwell Place", "Germantown", "TN", 38183, 0); insert into membership values (107, "Rosario", "Elliott", "7578 Danner Avenue", "Columbia", "TN", 38402, 5); insert into membership values (108, "Mattie", "Guy", "4390 Evergreen Street", "Lily", "KY", 40740, 0); insert into membership values (109, "Clint", "Ochoa", "1711 Elm Street", "Greeneville", "TN", 37745, 10); insert into membership