Database Solutions
Description
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
All prices
More details
Other editions
Additional editions
Content
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
