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