Submitted by: Submitted by homestudyhelp365
Views: 10
Words: 386
Pages: 2
Category: Other Topics
Date Submitted: 06/21/2016 12:10 AM
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...