Health Connect relational model Users (nickname, firstName, surname, birthYear,

Question

Health Connect relational model

Users (nickname, firstName, surname, birthYear, city, suburb, job, TV, videoID, mentorNickname) Posts (postID, datetime, content)

PostAuthors (nickname, postID) PostComments (nickname, postID, datetime, content)

Video (videoID, title, description, duration, filetype) HealthPractitioners (healthPracID, firstName, surname, streetNumber, street, suburb, city, postcode, type)

PhoneNumber (phoneNumber, healthPracID) Illness (illnessID, name, description) TreatmentRecords (nickname, healthPracID, illnessID, dateStarted, degree)

FOREIGN KEYS

PostAuthors (nickname) is dependent on Users (nickname)

PostComments (nickname) is dependent on Users (nickname)

PostAuthors (postID) is dependent on Posts (postID)

PostComments (postID) is dependent on Posts (postID)

Users (videoID) is dependent on Video (videoID)

TreatmentRecords (healthPracID) is dependent on HealthPractitioners (healthPracID)

PhoneNumber (healthPracID) is dependent on HealthPractitioners (healthPracID)

TreatmentRecords (illnessID) is dependent on Illness (illnessID) OTHER CONSTRAINTS

Video (filtype) domain is [AVI, MOV, FLV, MP4, WMV]

HealthPractitioners (type) domain is [Doctor, Physio, Dietician]

TreatmentRecords (degree) domain is [1-5]

Health Practitioners may have up to three phone numbers

Health Connect have two employees, Wayne and Jake, to work with the MySQL database. Working as MySQL database administrator, provide the commands required to grant or revoke access so the following security requirements are met:

A. User Wayne must be able to add records to the USERS table (0.5 Marks)

B. User Wayne must be able to remove records from the USERS table (0.5 Marks)

C. User Jake is no longer allowed to add data to the USERS table (0.5 Marks)

D. User Jake is no longer allowed to delete records from the USERS table (0.5 Marks)

Assume usernames of employees Wayne and Jake are wayne and jake respectively.

Explanation / Answer

Answer)

A. User Wayne must be able to add records to the USERS table (0.5 Marks)

GRANT INSERT ON USERS TO 'Wayne';

B. User Wayne must be able to remove records from the USERS table (0.5 Marks)

GRANT DELETE ON USERS TO 'Wayne';

C. User Jake is no longer allowed to add data to the USERS table (0.5 Marks)

REVOKE INSERT ON USERS TO 'Jake';

D. User Jake is no longer allowed to delete records from the USERS table (0.5 Marks)

REVOKE DELETE ON USERS TO 'Jake';

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.