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

 QUESTION 3-SQL (30 marks) Using the following database formulate SQL statements
to satisfy what is requested by the users Primary keys appear in

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

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!