This is my database Homework

2. Write a procedure to create the tables in your database, tables as in the image. U means unique content when creating tables, check if such table exists, if so, delete it and create a new one (1 point). 3. Write a procedure(s) (procedures adding, updating, deleting, data to this database), on the input Birth_Date, surname, first name, the database there can be no empty values, when you mistakenly enter the value it should be removed from the Data table. You should check whether the added name is already in the name table. The same surname and first name can have several people. Surname, first name, Birth_Date (2.5 pt.) are to be collected. 4. Prepare a dataset with your Last Name and FirstName. The set should contain three changes of surname or first name (0.5 pt). 5. Prepare a view that displays only the last data (surname first name birth of date (1pt.) 6. Save everything in a text file named ID.txt (full script) (0.5pt) Person id_person Integer (10) BirthDate date Data ID_Data_Person inte ger(10) Id_person inte ger(10) id_name integer (10) Data type integer (10) Name Id_name Integer(10) varchar(40) U name Data type Data type integer (10) name varchar(20) U 2. Write a procedure to create the tables in your database, tables as in the image. U means unique content when creating tables, check if such table exists, if so, delete it and create a new one (1 point). 3. Write a procedure(s) (procedures adding, updating, deleting, data to this database), on the input Birth_Date, surname, first name, the database there can be no empty values, when you mistakenly enter the value it should be removed from the Data table. You should check whether the added name is already in the name table. The same surname and first name can have several people. Surname, first name, Birth_Date (2.5 pt.) are to be collected. 4. Prepare a dataset with your Last Name and FirstName. The set should contain three changes of surname or first name (0.5 pt). 5. Prepare a view that displays only the last data (surname first name birth of date (1pt.) 6. Save everything in a text file named ID.txt (full script) (0.5pt) Person id_person Integer (10) BirthDate date Data ID_Data_Person inte ger(10) Id_person inte ger(10) id_name integer (10) Data type integer (10) Name Id_name Integer(10) varchar(40) U name Data type Data type integer (10) name varchar(20) U