DATA MANAGEMENT ARAVIND – 09901366442 – 09902787224

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

www.mbacasestudyanswers.com

ARAVIND – 09901366442 – 09902787224

DATA MANAGEMENT

CASE STUDY : 1

The physical or internal level organization of a database system is concerned with the efficient storage of information in the Secondary Storage devices. The physical to conceptual level mapping must provide the necessary shield to the user. The basic problem in physical database representation is to select a suitable file system  to store the desired information. The file consist of records and a record may consist of several fields.

1) What are the typical operations that may be performed on the information stored in the file?

2) Explain in detail factors affecting physical organization of data?

3) Explain the term ‘Magnetic Tapes’?

4) Define in brief ‘Secondary Storage Devices’?

CASE STUDY : 2

In a medical database with attributes DISEASE, SYMPTOM, TEST (such as pathological or clinical tests), TREATMENT and MEDICINE, following data dependencies are assumed to hold.

1) Compute the dependency basis of each attribute?

2) Identify the join dependencies that hold in this database?

3) Does there exist a fourth normal form decomposition that preserves the dependencies?

4) If so, design a fourth normal form lossless, join decomposition that preserves the dependencies?

CASE STUDY : 3

1) Anyone can read BANKACNT relation except for the ACCT NO attribute. 

2) Any accountholder can read the tuple corresponding to his/her own account number

from the ACNT DETAIL relation.

3) Bank employees can read tuples from ACNT DETAIL relation, but only those employees whose job is TELLER can update entries in the ACNT DETAIL relation pertaining to any ACCT NO (this field cannot be modified).

4) Bank employees can read BANK EMPLOYEE relation except for the SALARY attribute.

CASE STUDY : 4

1) Explain why transaction atomicity is one of the most important requirement for concurrency control?

2) Describe how in a multiuser environment atomicity of read and write operations can be ensured, especially for large data items i.e. when the granularity of data items is larger than a disc block?

3) Describe the functional modules of a centralized database system responsible for concurrency control and recovery?

4) Discuss how database read and write operations are implemented?

WE PROVIDE CASE STUDY ANSWERS, ASSIGNMENT SOLUTIONS, PROJECT REPORTS AND THESIS

aravind.banakar@gmail.com

ARAVIND - 09901366442 – 09902787224