Database Systems

Part A. Preliminary Topics

1. Introduction to Database Systems
Elvis C. Foster, Shripad Godbole

2. The Database System Environment
Elvis C. Foster, Shripad Godbole

Part B. The Relational Database Model

3. The Relational Model
Elvis C. Foster, Shripad Godbole

4. Integrity Rules and Normalization
Elvis C. Foster, Shripad Godbole

5. Database Modeling and Design
Elvis C. Foster, Shripad Godbole

6. Database User Interface Design
Elvis C. Foster, Shripad Godbole

7. Relational Algebra
Elvis C. Foster, Shripad Godbole

8. Relational Calculus
Elvis C. Foster, Shripad Godbole

9. Reflective Look at the Relational Database Model
Elvis C. Foster, Shripad Godbole

Part C. The Structured Query Language

10. Overview of SQL
Elvis C. Foster, Shripad Godbole

11. SQL Data Definition Statements
Elvis C. Foster, Shripad Godbole

12. SQL Data Manipulation Statements
Elvis C. Foster, Shripad Godbole

13. Logical Views and System Security
Elvis C. Foster, Shripad Godbole

14. The System Catalog
Elvis C. Foster, Shripad Godbole

15. Some Limitations of SQL
Elvis C. Foster, Shripad Godbole

Part D. Advanced Topics

16. Database Administration
Elvis C. Foster, Shripad Godbole

17. Distributed Database Systems
Elvis C. Foster, Shripad Godbole

18. Object Databases
Elvis C. Foster, Shripad Godbole

19. Data Warehousing
Elvis C. Foster, Shripad Godbole

20. Web-Accessible Databases
Elvis C. Foster, Shripad Godbole

21. Using Database Systems to Anchor Management Support Systems
Elvis C. Foster, Shripad Godbole

Part E. Overview of Selected DBMS Suites

22. Overview of Oracle
Elvis C. Foster, Shripad Godbole

23. Overview of DB2
Elvis C. Foster, Shripad Godbole

24. Overview of MySQL
Elvis C. Foster, Shripad Godbole

25. Overview of Microsoft SQL Server
Elvis C. Foster, Shripad Godbole

Part F. Appendices

26. Review of Trees
Elvis C. Foster, Shripad Godbole

27. Review of Hashing
Elvis C. Foster, Shripad Godbole

28. Review of Information-Gathering Techniques
Elvis C. Foster, Shripad Godbole

29. BNF Syntax for Selected SQL Statements
Elvis C. Foster, Shripad Godbole

30. Sample Exercises and Examination Questions
Elvis C. Foster, Shripad Godbole

Nyckelord: Computer Science, Database Management, Computer Science, general