MYSQL

Part 1 (5 Points): Creating the database: Create the following tables. The underlined bold column names are the primary keys. Make sure to specify the primary and foreign key constraints in your create table statements. 1. customer: (cus code:integer, cus lname:varchar(20), cus fname:varchar(20), 2. invoice: (inv number:integer cus_code:integer, inv date.date, foreign key cus code references customer(cus code]) 3. line: (inv number:int prod code:integer oreign key (inv number) references Invoice(inv number) foreign key (prod code) references Product (prod code)] 4. product:(prod code:integer prod descvaxchar(50), prod^priceinteger prod quantintegervend code:integer, foreign key (vend code) referenecs Vendor(vend. code)) 5. vendor:(yend code.integervend_name:varchar(30),vend_contact:varchar(30), vend_areacode:integer,vend phone:integer)