An academic health system is using a database to store historical data and business metrics to use for strategic decision making. What kind of database is this? What kind of tools are used to retrieve data from this database?

2.What is structural independence, and why is it important?

3.What is a relationship and list the three relationship types.

4.What kind of database is used support vast amounts of sparse data in big data era?

5.What are the characteristics of a relational table?

6.Patient’s Body Mass Index is calculated based on patient’s weight and height. A high BMI can indicate high body fatness. What kind of attribute is BMI? What do you call height and weight attributes that determine the value of BMI attribute?

7.What is a surrogate primary key and when this is used?

8.What kind of data is stored in an entity subset and what will be the primary key used in this?

9.What kind of trap arises when a relationship is improperly or incompletely identified? How do you correct this problem?

10. A pregnant mother was admitted to a hospital and delivered a new born. Both mom and baby are records in patient entity but also related to each other. What kind of relationship is this?