Data Dictionary: Table Name Patient Doctor Attribute Name P_Num P_FirstName P_LastName P_Contact Num D_Num D_FirstName D_LastName...

Transcribed Image Text:

Data Dictionary: Table Name Patient Doctor Attribute Name P_Num P_FirstName P_LastName P_Contact Num D_Num D_FirstName D_LastName D_ContactNum D_Type 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 4.1 Using the correct SQL command create the two tables stated in the data dictionary. 4.2 Using the correct SQL command following information for the Patient table: (001, Anna, Smith, 0317075310) 4.3 Using the correct SQL command following information for the Doctor table: (401, Dawn, Thomas, 3012233445, GP) 4.4 Use the correct SQL command to see all contents in the Patient table. 4.5 Use the correct SQL command to see all contents in the Doctor table. 4.6 Remove the details for Patient 001 from the Patient table. Type INTEGER VARCHAR(35) VARCHAR(35) CHAR(10) INTEGER CHAR(35) CHAR(35) CHAR(10) CHAR(10) (10 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks) Data Dictionary: Table Name Patient Doctor Attribute Name P_Num P_FirstName P_LastName P_Contact Num D_Num D_FirstName D_LastName D_ContactNum D_Type 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 4.1 Using the correct SQL command create the two tables stated in the data dictionary. 4.2 Using the correct SQL command following information for the Patient table: (001, Anna, Smith, 0317075310) 4.3 Using the correct SQL command following information for the Doctor table: (401, Dawn, Thomas, 3012233445, GP) 4.4 Use the correct SQL command to see all contents in the Patient table. 4.5 Use the correct SQL command to see all contents in the Doctor table. 4.6 Remove the details for Patient 001 from the Patient table. Type INTEGER VARCHAR(35) VARCHAR(35) CHAR(10) INTEGER CHAR(35) CHAR(35) CHAR(10) CHAR(10) (10 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks)

Answer rating: 100% (QA)

42 Ans ... View the full answer