Write a Structured Query Language (SQL) statement for each of the following questions:
a) Create the AppointmentDetails table with the following requirements:
Appropriate data types.
All keys can store between 6 to 10 characters.
All the columns must have values (cannot be empty).
Add on charges is set to 0.00 by default.
Enforce entity and referential integrities.
b) Diplay the therapists’ particulars (include TheraName, TheraContact) as first two columns, then calculate the Total_Count_Of_Appointment for each therapist within the year 2020 as third columns. Lastly, arrange the outcome to show the list by the higher popularity of therapists first.
Extracted text: Question 4 Given the Database Design Language (DBDL) for Rio Massage Centre as follows: Note: Date format is 'DD/MM/YYYY'. Customer(CustlID, CustName, CustContact) Therapist (TheralD, TheraName, TheraContact, TheraBiodata) Service (ServicelD, ServiceDesc, Price) CustomerAppointment (ApptNo, RecordDate, ApptDate, ArrivalTime, CustID*) AppointmentDetails (ApptNo*, ServicelD*, AddOnCharges, TheralD*) You are required to use the aliases for the given tables as below (whenever it is appropriate): C for Customer, T for Therapist, S for Service, CA for CustomerAppointment, A for AppointmentDetails.