Data Management - Anyone Can Read Bankacnt Relation Except for the Acct No Attribute

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...