O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required