Page 4 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

CONTENTS

Unit 1: Database Fundamentals 1
Harjinder Kaur, Lovely Professional University
Unit 2: Database Relational Model 12
Pooja Gupta, Lovely Professional University
Unit 3: Structured Query Language 37
Sartaj Singh, Lovely Professional University
Unit 4: Advanced SQL 59
Sarabjit Kumar, Lovely Professional University
Unit 5: Integrity Constraints 72
Pawan Kumar, Lovely Professional University
Unit 6: Relational Language and Database Design 84
Pawan Kumar, Lovely Professional University
Unit 7: Relational Database Design 106
Mandeep Kaur, Lovely Professional University
Unit 8: Normalization 127
Sahil Rampal, Lovely Professional University
Unit 9: Transaction Management 148
Pooja Gupta, Lovely Professional University
Unit 10: Datalog and Recursion 166
Mithilesh Kumar Dubey, Lovely Professional University
Unit 11: Recovery System 179
Balraj Kumar, Lovely Professional University
Unit 12: Query Processing and Optimization 196
Kamlesh Lakhwani, Lovely Professional University
Unit 13: Parallel Databases 219
Manmohan Sharma, Lovely Professional University
Unit 14: Application Development and Administration 232
Manmohan Sharma, Lovely Professional University