$($Marks: $65)$

Question $3$

Practical computer work: The answer to this question should be submitted electronically.

Using MySaL create a single struthents to indicate which part of the satp comment questions below. Include comments to indicate which part of the script answers which question.

The script must execute correctly using My $SQL$ to get full marks.

the following extract from an Entity Relationship Diagram $($ERD$)$ before answering

Q$\mathrm{.}3\mathrm{.}1$ Write an SQL statement to create the Patient table.

$(5)$

Q$\mathrm{.}3\mathrm{.}2$ Write an SQL statement to create the Doctor table.

Q$\mathrm{.}3\mathrm{.}3$ Write an SQL statement to create the Appointments table.

$(4)$

Q$\mathrm{.}3\mathrm{.}4$ Write SQL statements to insert the following data:

Table: Patient

$\backslash$table$[[$Patient ID$,$Patient Name,Patient Surname,Date of Birth$],[1,$Debbie,Theart,$1980-03-17$