Page no:39
5
6
7
8
4.3 Normalization Normal forms based on primary keys (1 NF, 2 NF, 3 NF, BCNF, 4 NF, 5 NF) 4.4 Loss less joins and dependency preserving decomposition Storage and File Structure 5.1 Overview of physical storage media 5.2 Magnetic disk 5.3 RAID 5.4 Tertiary storage 5.5 Storage access 5.6 File organization 5.7 Organization of records in files 5.8 Data dictionary storage Transaction And Concurrency control 6.1 Concept of transaction, ACID properties 6.2 Serializibility 6.3 States of transaction, 6.4 Concurrency control 6.3.1 Locking techniques 6.3.2 Time stamp based protocols 6.3.3 Granularity of data items 6.3.4 Deadlock Crash Recovery and Backup 7.1 Failure classifications 7.2 storage structure 7.3 Recovery & atomicity 7.4 Log base recovery 7.5 Recovery with concurrent transactions 7.6 Failure with loss of Non-Volatile storage 7.8 Database backup & recovery from catastrophic failure 7.9 Remote Backup System Security and privacy 8.1 Database security issues 8.2 Discretionary access control based on grant & revoking privilege 8.3 Mandatory access control and role based access control for multilevel security 8.4 Encryption & public key infrastructures
3
1, 2, 5,8
4
6 ,7
4
2,5
2
1,5
Note: Case studies on ER diagram, Normalization and SQL should be covered