Question 3 (20 Marks) A database language such as the popular Standard Query Language (SQL) allows you to create databases and table structures, to perform basic data management chores (add, delete, and modify), and to perform complex queries designed to transform the raw data into useful information. Included in the training schedule are practical exercises on the SQL query language. Refer to the data dictionary below and provide SQL queries to the following activities. Data Dictionary Table Name Patient Attribute Name P_Num P_FirstName P Last Name P_Contact Num Type INTEGER VARCHAR(35) VARCHAR(35) CHAR(10) Contents Customer Number Customer First Name Customer Last Name Customer Telephone Number Doctor Number Doctor First Name Doctor Last Name Doctor Telephone Number Type of Doctor Doctor D Num D_FirstName D LastName D_Contact Num D Type INTEGER CHAR(35) CHAR(35) CHAR(10) CHAR(10) 3.1 Using the correct SQL command create the two tables stated in the data dictionary. (10 marks) 3.2 Using the correct SQL command following information for the Patient table: (2 marks) (001, Anna, Smith, 0317075310) 3.3 Using the correct SQL command following information for the Doctor table: (2 marks) (401, Dawn, Thomas, 3012233445, GP) 3.4 Use the correct SQL command to see all contents in the Patient table. (2 marks) 3.5 Use the correct SQL command to see all contents in the Doctor table. (2 marks) 3.6 Remove the details for Patient 001 from the Patient table. (2 marks)