Question

Consider the data dictionary below for a patient diagnosis case. Use this dictionary to answer questions a-e. Table Attributes Data type Length Primary key? Foreign key? Patient PatientID INT 8 Yes No Fname Varchar 100 No No Surname Varchar 100 No No Age Int 10 No No Diagnosis D_ID INT 8 Yes No Type Varchar 150 No No Fee Decimal 10 No No PatientID INT 8 No Yes a) Implement the above database using MySQL. 5 Marks b) Create a trigger to be fired each time a new record is added to diagnosis table 3 Marks c) Create a new user called cashier who can add, select and update records in this database. 3 Marks d) Create a transaction for adding, updating and deleting a record in patient table. The transaction allows the user to rollback to some specified save points. 4 Marks

          Consider the data dictionary below for a patient diagnosis case. Use this dictionary to answer questions a-e.

Table	Attributes	Data type	Length	Primary key?	Foreign key?
Patient	PatientID	INT	8	Yes	No
Fname	Varchar	100	No	No
Surname	Varchar	100	No	No
Age	Int	10	No	No
Diagnosis	D_ID	INT	8	Yes	No
Type	Varchar	150	No	No
Fee	Decimal	10	No	No
PatientID	INT	8	No	Yes
a) Implement the above database using MySQL.	5 Marks
b) Create a trigger to be fired each time a new record is added to diagnosis table	3 Marks
c) Create a new user called cashier who can add, select and update records in this database.	3 Marks
d) Create a transaction for adding, updating and deleting a record in patient table. The transaction allows the user to rollback to some specified save points.	4 Marks

Consider the data dictionary below for a patient diagnosis case. Use this dictionary to answer questions a-e.

Table Attributes Data type Length Primary key? Foreign key?
Patient PatientID INT 8 Yes No
Fname Varchar 100 No No
Surname Varchar 100 No No
Age Int 10 No No
Diagnosis DID INT 8 Yes No
Type Varchar 150 No No
Fee Decimal 10 No No
PatientID INT 8 No Yes
a) Implement the above database using MySQL. 5 Marks
b) Create a trigger to be fired each time a new record is added to diagnosis table 3 Marks
c) Create a new user called cashier who can add, select and update records in this database. 3 Marks
d) Create a transaction for adding, updating and deleting a record in patient table. The transaction allows the user to rollback to some specified save points. 4 Marks

Added by Angela R.

Question

Please give Ace some feedback