AvE4EvA, 2015. — 164 p. — ISBN: 8740310469, 9788740310467This 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).
