Question: 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

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.

 write a procedure(s) (procedures adding, updating deleting, data to this database),

SQL

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!