This book places a strong emphasis on good design practice, allowing students to master design methodology in an accessible, step-by-step fashion. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals. The book is designed to be used in database courses for technical and non-technical students.PART I: BACKGROUND.
1.Introduction to Databases. PART II: THE RELATIONAL MODEL AND LANGUAGES.
2. Database Environment.
3. The relational model. PART III: DATABASE ANALYSIS AND DESIGN TECHNIQUES.
4. Relational algebra and relational calculus.
5. SQL: data manipulation.
6. SQL: data definition.
7. Query-By-Example (QBE).
8. Commercial DBMSs: Access and Oracle.
9. Database planning, design and administration. PART IV: METHODOLOGY.
10. Fact-finding techniques.
11. Entity-relationship modeling.
12. Enhanced entity-relationship modeling.
14. Advanced normalization.
15. Methodology - conceptual database design. PART V: SELECTED DATABASE ISSUES.
16. Methodology - logical database design for relational model.
17. Methodology - physical database design for relational databases.
18. Methodology - monitoring and tuning the operational system.
19. Security. PART VI: DISTRIBUTED DBMSs AND REPLICATION.
20. Transaction management.
21. Query processing.
22. Programming SQL.
23. Distributed DBMSs - concepts and design. PART VII: OBJECT DBMSs.
24. Distributed DBMSs - advanced concepts.
25. Replication and mobile databases.
26. Introduction to Object DBMSs. PART VIII: WEB AND DBMSs.
27. Object-oriented DBMSs - concepts and design.
28. Object-oriented DBMSs - standards and languages.
29. Object-relational DBMSs.
30. Web technology and DBMSs. PART IX: BUSINESS INTELLIGENCE (OR DECISION SUPPORT).
31. Semistructured data and XML.
32. Data warehousing concepts.
33. Data warehousing design.
35. Data mining.