(Solved): database management . part B answer please Part A: Create the following tables using SQL ...

database management .

part B answer please

Part A: Create the following tables using SQL Developer, based on the given data types and constraints. Please note that you must study the structure of the tables/columns thoroughly and create the tables using SQL queries. Part B: Write SQL queries of each of the following questions: 1. Write SQL query to show all the tables you have created. You need to use a single query to show all the table names in a single column. 2. Write SQL query to show all the constraints for the tables you have created above. 3. Insert one row in each of the tables. You can assume the values of your choice. Please keep in mind to consider referential integrity while inserting the values. 4. Add a column named salary with a datatype of $$\mathrm{NUMBER}(9,2)$$ to the ARTISTMANAGER table. Ensure that the amount entered should not be less than 0. 5. There can be a change in the width of the mail on Artists. Write SQL query to change the datatype of all the Artists's email to VARCHAR2(55). 6. Change the CONTRACT table so that only less than 100 can be entered in the column "RoyaltyPercentage". 7. Change the ARTIST table so that NULL values can't be entered in the name columns (First and Last). 8. Write SQL query to remove the column ArtistType from the ARTIST table. 9. Write SQL queries to delete the data from all the tables. 10. Write SQL queries to remove all the tables from one by one. You need to keep the sequence of the removal in mind to remove the tables successfully. You are not allowed to use CASCADE option.