Marklyn, Bill
Inside Relational Databases with Examples in Access
1. Introduction
Part 1. A simple, single-table database
2. Introduction to Part 1
3. Tables
4. Queries/Views
5. Forms
6. Reports
7. Summary of Part 1
Part 2. A multi-table database
8. Introduction to Part 2
9. Serious problems with single tables
10. Multiple tables cure serious problems
11. Making multiple tables work together
12. Getting the data into the correct tables
13. Relationships in the real world
14. How are relationships modeled?
15. Revisiting the big four — the synergy begins
16. Integrity
17. Summary of Part 2
Part 3. Database Design & Architecture
18. Database design
19. The seven layers of wisdom
20. Database architecture
Part 4. Related database topics
21. What exactly is a relational database?
22. Chapter 22 Triggers and stored procedures
23. Transactions, logs, backup, locking and concurrency
24. Codd’s rules
25. Normalization
26. More about normalization
27. The system tables
28. More on queries: data manipulation
29. SQL
30. Domains
31. What does null mean?
32. Primary keys
Part 5. Speeding up your database
33. Hardware considerations
34. Indexing
35. More on optimization
36. Denormalization
DRM-restrictions
Printing: not available
Clipboard copying: not available
Avainsanat: COMPUTERS / Computer Science COM014000
- Tekijä(t)
- Marklyn, Bill
- Whitehorn, Mark
- Julkaisija
- Springer
- Julkaisuvuosi
- 2007
- Kieli
- en
- Painos
- 1
- Kategoria
- Tietotekniikka, tietoliikenne
- Tiedostomuoto
- E-kirja
- eISBN (PDF)
- 9781846286872