Database Design and Implementation A practical introduction using Oracle SQL
Publisher: Bookboon.com
Published: 2015
ISBN-13: 9788740310467
Table of contents: title: Content; title: 1. Introduction to database development; title: 1.1. Conceptual data modelling; title: 1.2. The Entity Relationship Diagram (ERD); title: 1.3. Entity types; title: 1.4. Producing the ERD; title: 1.5. Entity attributes; title: 1.6. Entity selection and validation; title: 1.7. Entity definitions; title: 1.8. Validating the model; title: 2. Entity Relationships; title: 2.1. Introduction; title: 2.2. Relationships; title: 2.3. Relationship cardinality; title: 2.4. Relationship optionality; title: 3. Complex relationships; title: 3.1. Introduction; title: 3.2. Associative relationships; title: 3.3. Link entity identifier; title: 3.4. Recursive relationships; title: 3.5. Sub types; title: 3.6. Exclusive relationships; title: 3.7. Summary; title: 4. Logical Database Design; title: 4.1. Introduction; title: 4.2. Relations; title: 4.3. Keys; title: 4.4. Identifying relations; title: 4.5. Resolving many-to-many relationships; title: 4.6. Resolving one-to-many relationships with optionality; title: 4.7. Resolving one-to-one relationships; title: 4.8. Recursive relationships; title: 4.9. Exclusive relationships; title: 4.10. Identification Dependency; title: 4.11. Modelling problems; title: 4.12. Summary; title: 5. Normalisation; title: 5.1. Introduction; title: 5.2. Un-normalised form (UNF); title: 5.3. First Normal Form (NF); title: 5.4. Second Normal Form (NF); title: 5.5. Third Normal Form (NF); title: 5.6. Denormalisation; title: 5.7. Checking the model; title: 5.8. Summary; title: 6. Introduction to Oracle SQL; title: 7. Using Foreign Keys; title: 8. Selecting data from a table; title: 9. Selecting data from multiple tables; title: 10. Subqueries and group functions; title: 11. Creating pages & reports; title: 12. Appendices; title: 12.1. Appendix A; title: 12.2. UML Modelling Notation; title: 12.3. Appendix B; title: 12.4. Music System Specification (ERD and Tables); title: 12.5. Appendix C; title: 12.6. Order System Specification (ERD and Tables); title: 12.7. Appendix D; title: 12.8. Normalisation Template; title: 13. Bibliography