Skip navigation

Bookboon.com Gratis studiebøger og e-bøger

Choose a category

Database Design and Implementation

A practical introduction using Oracle SQL

Database Design and Implementation
4,8 (30 Anmeldelser) Læs anmeldelser
ISBN: 978-87-403-1046-7
1. udgave
Sider : 164
  • Pris: 129,00 kr
  • Pris: €13,99
  • Pris: £13,99
  • Pris: ₹250
  • Pris: $13,99
  • Pris: 129,00 kr
  • Pris: 129,00 kr

4 nemme skridt til din e-bog

Vi beklager, men for at kunne downloade vores bøger eller se vores videoer, kræves det at din browser tillader JavaScript.
Er du interesseret i GRATIS e-bøger og relevante opdateringer fra Bookboon?
Efter du har indtastet din email addresse, modtager du en bekræftelsesmail. Venligst acceptér denne for at modtage vores ugentlige eBooks update. Vi giver ikke din personlige information videre.
eLib
Opnå din organisations potentiale
Se Demo

Corporate eLibrary

Se vores erhvervsløsninger til intern uddannelse

Dette er en Premium eBog

Bookboon Premium - Få adgang til over 800 eBøger - uden annoncer

Du kan få gratis adgang i 30 dage til denne - og 800 andre bøger via Premium abonnementet. Du kan også købe bogen nedenfor

  • Start et 30 dages prøveabonnement. Efter 30 dage: 39,99 kr pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: €5,99 pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: £4,99 pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: ₹299 pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: $3,99 pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: 39,99 kr pr/måned
  • Start et 30 dages prøveabonnement. Efter 30 dage: 39,99 kr pr/måned
eLib
Opnå din organisations potentiale
Klik her

Corporate eLibrary

Se vores erhvervsløsninger til intern uddannelse

Om bogen

  1. Anmeldelser
  2. Beskrivelse
  3. Indledning
  4. Indholdsfortegnelse

Anmeldelser

Akinola Michael ★★★★★

Command in show databases, show table and describe tablename.

Beskrivelse

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.

Indledning

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.

This 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.

An established data modelling methodology is explained which includes Entity Relationship models. These are presented using the long-established crow’s foot notation; however, as the Unified Modelling Language (UML) has become an industry standard, the Class Diagram notation is also introduced to show how it can also be used for ER modelling, though there are differences (Hay & Lynott, 2008).

The modelling diagrams used in this book have been drawn using the QSEE SuperLite v1.1.2 CASE tool which is available to download from http://www.leedsbeckett.ac.uk/qsee/.

The Oracle database management system and Oracle Application Express (APEX) development environment are used to introduce the industry standard Structured Query Language (SQL). An APEX user account can be obtained from apex.oracle.com for web access; alternatively, a copy of Oracle Database 11g Express Edition and Oracle APEX can be downloaded from Oracle.com for installation on your own system.

Further supporting materials can be found at the author’s website howard-gould.co.uk.

Indholdsfortegnelse

  1. Introduction to database development
    1. Conceptual data modelling
    2. The Entity Relationship Diagram (ERD)
    3. Entity types
    4. Producing the ERD
    5. Entity attributes
    6. Entity selection and validation
    7. Entity definitions
    8. Validating the model
  2. Entity Relationships
    1. Introduction
    2. Relationships
    3. Relationship cardinality
    4. Relationship optionality
  3. Complex relationships
    1. Introduction
    2. Associative relationships
    3. Link entity identifier
    4. Recursive relationships
    5. Sub types
    6. Exclusive relationships
    7. Summary
  4. Logical Database Design
    1. Introduction
    2. Relations
    3. Keys
    4. Identifying relations
    5. Resolving many-to-many relationships
    6. Resolving one-to-many relationships with optionality
    7. Resolving one-to-one relationships
    8. Recursive relationships
    9. Exclusive relationships
    10. Identification Dependency
    11. Modelling problems
    12. Summary
  5. Normalisation
    1. Introduction
    2. Un-normalised form (UNF)
    3. First Normal Form (1NF)
    4. Second Normal Form (2NF)
    5. Third Normal Form (3NF)
    6. Denormalisation
    7. Checking the model
    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
    1. Appendix A
    2. UML Modelling Notation
    3. Appendix B
    4. Music System Specification (ERD and Tables)
    5. Appendix C
    6. Order System Specification (ERD and Tables)
    7. Appendix D
    8. Normalisation Template
  13. Bibliography
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.