...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...
Words: 386 - Pages: 2