Design Considerations
The process of deciding what the database will look like is called database design. Designing a database involves choosing
The tables that belong in the database
The columns that belong in each table
How tables and columns interact with each other
Database design is concerned with the logical structure of the database. In the relational model, decisions about logical design are completely independent of the database's physical storage and structure. The logical structure is also independent of what the end user eventually sees. That can be customized with views created by the designer (see Chapter 9 for details) or with front-end application programs.
Database design using the relational model offers some important advantages ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
