An edition of Database Design and Implementation A practical introduction using Oracle SQL
(2013)
Database Design and Implementation A practical introduction using Oracle SQL
by Howard Gould
Share
×Close
This book uses a simple step by step approach to explain the essential relational database design modelling techniques, and shows how Oracle SQL can be used to implement a database.
You can download the book for free via the link below.
Publish Date
2013
Publisher
Bookboon.com
Check nearby libraries
Buy this book
| Edition | Availability |
|---|---|
1
Database Design and Implementation A practical introduction using Oracle SQL
2013, Bookboon.com
8740310469 9788740310467
|
aaaa
|
Book Details
Table of Contents
Sisältö
Introduction to database development
Conceptual data modelling
The Entity Relationship Diagram (ERD)
Entity types
Producing the ERD
Entity attributes
Entity selection and validation
Entity definitions
Validating the model
Entity Relationships
Introduction
Relationships
Relationship cardinality
Relationship optionality
Complex relationships
Introduction
Associative relationships
Link entity identifier
Recursive relationships
Sub types
Exclusive relationships
Summary
Logical Database Design
Introduction
Relations
Keys
Identifying relations
Resolving many-to-many relationships
Resolving one-to-many relationships with optionality
Resolving one-to-one relationships
Recursive relationships
Exclusive relationships
Identification Dependency
Modelling problems
Summary
Normalisation
Introduction
Un-normalised form (UNF)
First Normal Form (NF)
Second Normal Form (NF)
Third Normal Form (NF)
Denormalisation
Checking the model
Summary
Introduction to Oracle SQL
Using Foreign Keys
Selecting data from a table
Selecting data from multiple tables
Subqueries and group functions
Creating pages & reports
Appendices
Appendix A
UML Modelling Notation
Appendix B
Music System Specification (ERD and Tables)
Appendix C
Order System Specification (ERD and Tables)
Appendix D
Normalisation Template
Bibliography
Edition Identifiers
Work Identifiers
Links outside Open Library
Community Reviews (0)
Lists
History
- Created September 8, 2015
- 4 revisions
Wikipedia citation
×CloseCopy and paste this code into your Wikipedia page. Need help?
| August 22, 2020 | Edited by ISBNbot2 | normalize ISBN |
| September 8, 2015 | Edited by Alice Kirk | Edited without comment. |
| September 8, 2015 | Edited by Alice Kirk | Added new cover |
| September 8, 2015 | Created by Alice Kirk | Added new book. |