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.
Type of Material:
PDF - Open (Access) Textbook [integrated advertising]
Recommended Uses:
It is suitable for in-class discussion, homework, individual, team, lecture and self-paced study as the open book contains lots of examples and exercises.
Technical Requirements:
PDF viewer
Identify Major Learning Goals:
The main learning goal is to provide a practical approach for studying relational database design and implementation using the Oracle SQL for any computing-related students, users, designers or developers through various examples and exercises.
Target Student Population:
College General Ed, College Lower Division, College Upper Division, Professional
Prerequisite Knowledge or Skills:
First-year computer science fundamentals
College or university students with basic training in programming and design thinking skills.
Content Quality
Rating:
Strengths:
It supports students in a course that introduces relational database concepts and application.
The covered concepts on database design are clearly illustrated by practical examples and implementation using Oracle SQL.
Concerns:
Used on its own, may not satisfy "anyone else who needs to work with relational databases, either as users, designers or developers."
Potential Effectiveness as a Teaching Tool
Rating:
Strengths:
There are ample examples and very useful in-text exercises with explanatory solutions.
It is effective for concept reinforcement and also integration into course assignment or other form of assessments such as student projects.
Ease of Use for Both Students and Faculty
Rating:
Strengths:
The material is appealing with lots of practical and simple examples.
PDF readily downloadable from website. (No personally identifiable information is necessary if user checks "No" in response to "Can we interest you in some FREE eBooks and relevant Bookboon updates?")
Concerns:
No-cost e-book is suffused with advertising. (Website indicates that an non-advertising version is available for a fee.)
It can be enhanced if more illustrative diagrams are included in this open book.
Creative Commons:
Search by ISBN?
It looks like you have entered an ISBN number. Would you like to search using what you have
entered as an ISBN number?
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.
