DBMS in Health Care

Explain Inclusion dependencies and Template dependencies.

Explain the following data type:

iv) Timestamp data type.

Explain schema change statements in SOL.

Explain the main approaches of database programming.

Discuss the informal design guidelines for relation schemas.

Define the following:

i) Second normal form

Define the following:

ii) Boyce - codd normal form.

List the Inference rules for the functional dependencies.

Discuss Join dependencies and fifth normal form.

Explain the following data type:

iii) Bit --string data types 

Write a note on discretionary privileges.

Discuss Mandatory Access control in DBMS.

Explain the ACID properties of DBMS.

Explain the rules in strict Two-phase locking protocol.

Discuss deadlock prevention scheme.

Explain the actions that cause writing of LOG record.

Discuss any five sources of medical literature.

a. Discuss computer based patient record.

Explain the following data type:

ii) Character-string data types

Explain the following data type:

i) Numeric data type

c. Define the following operation in DBMS

iv) MAXIMUM

c. Define the following operation in DBMS

iii) AVERAGE

c. Define the following operation in DBMS

ii) DIVISION

c. Define the following operation in DBMS

i) JOIN 

b. Explain SELECT and PROJECT operations in DBMS.

a. Describe update operations in DBMS.

c. Explain with figure ER model for company database.

b. Explain the structural constraints in DBMS.

Define the following:

iii) Relationship

Define the following:

ii) Attribute 

 Define the following:

i) Entity

c. Explain the structure of DBMS, with a neat diagram.

b. Discuss levels of abstractions in DBMS.