QUESTION 3-SQL (30 marks) Using the following database formulate SQL statements to satisfy what is requested by the users Primary keys appear in bold and underlined and foreign key in italics PERSON (PersonID Name Name, DOB, DOO, Gender, Address City, Country, Phone, Email RELATIONSHIP (Person Person2. Relation) Notes. This database was created for an application which will construct a family tree. In PERSON we have data describing each person DOB is for the Date of Birth and DOD is for the Date of Death In RELATIONSHIP We have the relationship between every pair of persons e. father, mother sister, brother, etc. Person and Person2 keep data of type Personi. Relation keeps data such as brother sister, mother, father, etc. and it is always the relation of person to Persona. For example: (123,201, Mother shows Person with code 123 being the mother of Person with code 201 10 Create a new tale med DECEASED 10 in Pon.Name. Nane, DONDOO.Gender Country with Penn heimary by Com the records of wildcard penontom ROCHASED Allerwarde delete the records from PERSON O commande Con how many others have 3 or more that and day Having the As a record wordt the PERSON Two coperty of the number of minongo 10 w gender Insert wurde in PERSON Toto in the incomodo 11 QUESTION 3-SQL (30 marks) Using the following database formulate SQL statements to satisfy what is requested by the users Primary keys appear in bold and underlined and foreign key in italics PERSON (PersonID Name Name, DOB, DOO, Gender, Address City, Country, Phone, Email RELATIONSHIP (Person Person2. Relation) Notes. This database was created for an application which will construct a family tree. In PERSON we have data describing each person DOB is for the Date of Birth and DOD is for the Date of Death In RELATIONSHIP We have the relationship between every pair of persons e. father, mother sister, brother, etc. Person and Person2 keep data of type Personi. Relation keeps data such as brother sister, mother, father, etc. and it is always the relation of person to Persona. For example: (123,201, Mother shows Person with code 123 being the mother of Person with code 201 10 Create a new tale med DECEASED 10 in Pon.Name. Nane, DONDOO.Gender Country with Penn heimary by Com the records of wildcard penontom ROCHASED Allerwarde delete the records from PERSON O commande Con how many others have 3 or more that and day Having the As a record wordt the PERSON Two coperty of the number of minongo 10 w gender Insert wurde in PERSON Toto in the incomodo 11
