
"Database Design and Implementation: A Practical Introduction Using Oracle SQL" by Howard Gould
BoBoCoAe | 2015 | ISBN: 8740310469 9788740310467 | 164 pages | PDF | 14 MB
BoBoCoAe | 2015 | ISBN: 8740310469 9788740310467 | 164 pages | PDF | 14 MB
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. There are numerous practical exercises with feedback.
Key topics include conceptual modelling using the crow's feet notation and the Unified Modelling Language (UML), logical and physical modelling, normalisation, the structured query language (SQL) and simple application development using APEX forms and reports.
This book has been written to provide a practical introduction to relational database design and database development for students studying computing-related courses and anyone else who needs to work with relational databases, either as users, designers or developers. Similarly, people who are commissioning a database may benefit from an understanding of this content.
The book is based on an approach that has been used successfully over a number of years to teach many undergraduate computing students, and is presented in a concise form that will make it easy for you to grasp the essential principles and techniques and apply these in any relational database environment.
The Oracle database management system and Oracle Application Express (APEX) development environment are used to introduce the industry standard Structured Query Language (SQL).
Contents
1. Introduction to database development
1.1. Conceptual data modelling
1.2. The Entity Relationship Diagram (ERD)
1.3. Entity types
1.4. Producing the ERD
1.5. Entity attributes
1.6. Entity selection and validation
1.7. Entity definitions
1.8. Validating the model
2. Entity Relationships
2.1. Introduction
2.2. Relationships
2.3. Relationship cardinality
2.4. Relationship optionality
3. Complex relationships
3.1. Introduction
3.2. Associative relationships
3.3. Link entity identifier
3.4. Recursive relationships
3.5. Sub types
3.6. Exclusive relationships
3.7. Summary
4. Logical Database Design
4.1. Introduction
4.2. Relations
4.3. Keys
4.4. Identifying relations
4.5. Resolving many-to-many relationships
4.6. Resolving one-to-many relationships with optionality
4.7. Resolving one-to-one relationships
4.8. Recursive relationships
4.9. Exclusive relationships
4.10. Identification Dependency
4.11. Modelling problems
4.12. Summary
5. Normalisation
5.1. Introduction
5.2. Un-normalised form (UNF)
5.3. First Normal Form (1NF)
5.4. Second Normal Form (2NF)
5.5. Third Normal Form (3NF)
5.6. Denormalisation
5.7. Checking the model
5.8. Summary
6. Introduction to Oracle SQL
7. Using Foreign Keys
8. Selecting data from a table
9. Selecting data from multiple tables
10. Subqueries and group functions
11. Creating pages & reports
12. Appendices
12.1. Appendix A
12.2. UML Modelling Notation
12.3. Appendix B
12.4. Music System Specification (ERD and Tables)
12.5. Appendix C
12.6. Order System Specification (ERD and Tables)
12.7. Appendix D
12.8. Normalisation Template
13. Bibliography
true PDF with TOC BookMarkLinks
Buy Premium Account To Get Resumable Support & Max Speed
rapidgator_net:
http://rapidgator.net/file/058dabbc2b64ab85b35c8be1cb618620/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf.html
nitroflare_com:
http://nitroflare.com/view/E589B1F616A7BFB/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf
uploaded_net:
http://uploaded.net/file/wp09qjlm/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf
http://rapidgator.net/file/058dabbc2b64ab85b35c8be1cb618620/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf.html
nitroflare_com:
http://nitroflare.com/view/E589B1F616A7BFB/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf
uploaded_net:
http://uploaded.net/file/wp09qjlm/zt5pa.Database.Design.and.Implementation.A.Practical.Introduction.Using.Oracle.SQL.by.Howard.Gould.pdf
Links are Interchangeable - No Password
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm