In the following treatment table, where there are blanks (Null entries), what does this mean with...

Transcribed Image Text:

In the following treatment table, where there are blanks (Null entries), what does this mean with view to the relationship type and business rules? (2 marks) B: If you were to create these tables (Client and Treatment) in SQL RDBMS, which table would you create first and why? Explain... (2 marks). C: If we were to add another record in the treatment' table for a new client '111254' representing a client 'Samantha James', what problem would we encounter and Why? (2 marks). Client table cl_id cl_name 548323 Tina, Edwards 236958 Jake, Vĩnh 546855 Barbara, Thomas 556233 Lina, Smart 457885 Brian, Hynes 471832 Calvin, Payne Treatment table tr_code 145 146 147 tr_type Facial Wax Therapy Pedicure 148 149 Consultation 150 Pigmentation cl_contact d_DOB 411545565 2/08/1985 423555447 15/02/1987 478212454 10/09/2000 542545538 3/08/2000 456823265 5/06/1995 457773266 6/08/1997 tr_charge tr_Date cl_id $80 11/05/2019 548323 8/02/2020 236958 2/03/2020 548323 $90 $75 $60 $15 $105 17/01/2020 457885 In the following treatment table, where there are blanks (Null entries), what does this mean with view to the relationship type and business rules? (2 marks) B: If you were to create these tables (Client and Treatment) in SQL RDBMS, which table would you create first and why? Explain... (2 marks). C: If we were to add another record in the treatment' table for a new client '111254' representing a client 'Samantha James', what problem would we encounter and Why? (2 marks). Client table cl_id cl_name 548323 Tina, Edwards 236958 Jake, Vĩnh 546855 Barbara, Thomas 556233 Lina, Smart 457885 Brian, Hynes 471832 Calvin, Payne Treatment table tr_code 145 146 147 tr_type Facial Wax Therapy Pedicure 148 149 Consultation 150 Pigmentation cl_contact d_DOB 411545565 2/08/1985 423555447 15/02/1987 478212454 10/09/2000 542545538 3/08/2000 456823265 5/06/1995 457773266 6/08/1997 tr_charge tr_Date cl_id $80 11/05/2019 548323 8/02/2020 236958 2/03/2020 548323 $90 $75 $60 $15 $105 17/01/2020 457885

Answer rating: 100% (QA)

The solution is as follows Lets address each of the questions based on the information provided in t... View the full answer