Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable.
Recipe for database success
Take one RDMS - any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox
Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary
Part 1 Background
1 Introduction
2 The relational model
3 SQL and QBE
4 The database system development lifecycle
5 Database administration and security Part 2 Database analysis and design techniques
6 Fact-finding
7 Entity-Relationship modeling
8 Normalization Part 3 Logical database design
9 Logical database design - Step 1
10 Logical database design - Step 2
11 Enhanced ER modeling techniquesPart 4 Physical database design
12 Physical database design - Step 3
13 Physical database design - Step 4
14 Physical database design - Steps 5 and 6
15 Physical database design - Step 7
16 Physical database design - Step 8 Part 5 Second worked example
17 PerfectPets - Logical database design
18 PerfectPets - Physical database design Part 6 Current and emerging trends
19 Current and emerging trends Appendices
A Alternative data modeling notations
B Summary of the database design methodology
C Advanced logical database design
D File organizations and indexes
E Common data models Glossary References Index
