Data analysis for database design is a subject of great practical value to systems analysts and designers. This classic text has been updated to include chapters on distributed database systems, query optimisation and object-orientation.The SQL content now includes features of SQL92 and SQL 99. With new databases coming online all the time and the general expansion of the information age, it is increasingly important to ensure that the analysis and model of a database design is accurate and robust. This is an ideal book for helping you to ensure that your database is well designed and therefore user friendly. Increased material on SQL including the latest developments Practical approach to explaining techniques and concepts Contains many questions and answer pointers
Part 1: Databases and database management systems: Database systems Database management system architecture Part 2: Relational modelling: Tables Redundant vs duplicated data Repeating groups Determinants and identifiers Fully-normalised tables Part 3: Entity-relationaship modelling Introduction to entity-relationship modelling Properties of relationships Decomposition of many:many relationships Connection traps Skeleton entity-relationship models Attribute assignment First-level design Second level design Part 4: Further topics Distributed database systems Relational algebra Query optimnisation The SQL language Object orientation Appendix: The Codasyl (network) model
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).