Please write the SQL syntax only for the following questions! Thank you!

HW 3: Constraint & Table Management 1. Create a new table for compact disc artists. Include fields for artist_id, Artist_name, and place of birth. Make the artist ID and artist name not null. 2. Make a second table CD Inventory. Include these columns; Artist name, CD name, and copyright. Make the cd name unique. AM 3. Now create a table Record inventory. ude these columns; artist name, record name, date released. Make a Unique constraint at the table level for artist name and record name. 4. Create a fourth table called cd musicians. Include these columns; artist id, artist name, record co. make a primary key at the table level. 5. Now create a fifth table called cd titles. Include these columns; cd title, cd name, artist id no. add a foreign key constraint that references the primary key in the cd musicians table. 6. Alter the cd titles table to include a new column for in stock. Make it not null and add a check constraint at the table level, the check constraint should make it so the column cannot be less than zero or larger than 30. Drop table Customers!!! Drop table Customers; 7. Now we'll recreate the customers table: Use fields customer#, lastname, firstname, address, city, state, zip, referred, region. Add Not null constraints to lastname and firstname. wwwwww wwwwww Table Management 8. Rename the Employees table as JL Emps 9. Create a new table with these four columns from the existing Books table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID and the other columns should keep their original names. Name the new table Book Pricing. 10. Delete the book pricing table permanently so that it isn't moved to the recycle bin. Then delete the JL Emps table so that it can be restored. Restore the JL Emp table and verify that it is available again