Database Design and Implementation A practical introduction using Oracle SQL
Publisher: Bookboon
Published: 2013
ISBN-13: 9788740310467
Table of contents: title: Innhold; title: Introduction to database development; title: Conceptual data modelling; title: The Entity Relationship Diagram (ERD); title: Entity types; title: Producing the ERD; title: Entity attributes; title: Entity selection and validation; title: Entity definitions; title: Validating the model; title: Entity Relationships; title: Introduction; title: Relationships; title: Relationship cardinality; title: Relationship optionality; title: Complex relationships; title: Introduction; title: Associative relationships; title: Link entity identifier; title: Recursive relationships; title: Sub types; title: Exclusive relationships; title: Summary; title: Logical Database Design; title: Introduction; title: Relations; title: Keys; title: Identifying relations; title: Resolving many-to-many relationships; title: Resolving one-to-many relationships with optionality; title: Resolving one-to-one relationships; title: Recursive relationships; title: Exclusive relationships; title: Identification Dependency; title: Modelling problems; title: Summary; title: Normalisation; title: Introduction; title: Un-normalised form (UNF); title: First Normal Form (1NF); title: Second Normal Form (2NF); title: Third Normal Form (3NF); title: Denormalisation; title: Checking the model; title: Summary; title: Introduction to Oracle SQL; title: Using Foreign Keys; title: Selecting data from a table; title: Selecting data from multiple tables; title: Subqueries and group functions; title: Creating pages & reports; title: Appendices; title: Appendix A; title: UML Modelling Notation; title: Appendix B; title: Music System Specification (ERD and Tables); title: Appendix C; title: Order System Specification (ERD and Tables); title: Appendix D; title: Normalisation Template; title: Bibliography