Problem:
Consultants at Northern General Hospital have intended the following E-R diagram to explain the hospital’s conceptual data model.
Required:
Question 1: Map above E-R diagram to a relational schema. Recognize a proper identifier and a few other attributes for each of above entities.
Question 2: Illustrate out the two (2) main approaches to data security.
Question 3: Illustrate the structure of the security rule.