create table stock (stock_id numeric(10) not null, title varchar(80) not null, amount numeric(10) not null); 

create table media (media_id numeric(10) not null, description varchar(5) not null); 

create table cust (cust_id numeric(5) not null, stock_id numeric(5) not null, media_id numeric(1) not null, fname varchar(10) not null, lname varchar(10) not null, dob date not null, dt_rent date null, days_rent numeric(1) not null, dt_rt date null); 

*mysql

You created the CUST, STOCK, and MEDIA tables in Assignment 7. Perform the DESCRIBE command on each of these tables. Next, determine which columns should be a primary key and which should be a foreign key in each table