Chapter 1. Understanding Relational Databases

The Entity Relationship Diagram, Data Schema Diagram, and Normalization

The Oracle product that is discussed throughout this book is Oracle’s database product. Databases store data and metadata. Data are the individual facts that are used to derive information. Metadata describe the content, quality, condition, availability, and characteristics of data. Database management software (DBMS) is used to modify the data. For the purposes of this book, database will refer to the data stored in a database product such as Oracle9i.

Over the years, there has been a variety of database types: sequential files, hierarchical databases, network databases, and relational databases. The latest type of data storage ...

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.