1- write a procedure to create the tables in your database, tables as in the image. U means unique content when creating the tables, check if such tables exist, if so, delete it and create a new one. 2- 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 are to be collected.

3. Prepare a dataset with your Last Name and FirstName. The set should contain three changes of surname or first name.

4. Prepare a view that displays only the last data (surname first name birth of date

Person id_person Integer (10) BirthDate date Data ID_Data_Person integer (10) Id person Integer (10) id_name into ger(10) Data type Integer (10) Name Id_name into ger(10) name varchar(40) U Data type Datat a type integer(10) name varchar(20) U Person id_person Integer (10) BirthDate date Data ID_Data_Person integer (10) Id person Integer (10) id_name into ger(10) Data type Integer (10) Name Id_name into ger(10) name varchar(40) U Data type Datat a type integer(10) name varchar(20) U