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
Accessing your eBook through Kortext
Once purchased, you can view your eBook through the Kortext app, available to download for Windows, Android and iOS devices. Once you have downloaded the app, your eBook will be available on your Kortext digital bookshelf and can even be downloaded to view offline anytime, anywhere, helping you learn without limits.
In addition, you'll have access to Kortext's smart study tools including highlighting, notetaking, copy and paste, and easy reference export.
To download the Kortext app, head to your device's app store or visit https://app.kortext.com to sign up and read through your browser.
NB: eBook is only available for a single-user licence (i.e. not for multiple / networked users).