Contents:
Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.
Start Free Trial No credit card required. Design relational databases by converting entity-relationship diagrams into relational tables. Describe the data normalization process.
Here are some online sites with useful database management concepts and tips including some good discussion of database normalization: and first, second, and third normal form: In particular, PHPBuilder has understandable examples of the different levels of normalization. See Tom Grayson's notes regarding the syntax of SQL statements to define primary and foreign keys and to constrain table manipulation in order to enforce referential integrity - that is, to keep you from making changes to tables that destroy their internal consistency.
For more information about this page, please contact the The updated exercises and chapter summaries provide the real-world understanding needed to develop ER and EER diagrams, map them to relational databases, and test the resulting relational database. Complete with a wealth of additional exercises and examples throughout, this edition should be a basic component of any database course. Its comprehensive nature and easy-to-navigate structure makes it a resource that students and professionals will turn to throughout their careers.
She teaches a variety of computer science and database courses, and her research areas of concentration are database design, web databases, data mining and statistical computing.