Table of contents

Inner join on the id field Prime ministers, presidents

Database schema

• how data is organized within a relational database
• inclusive of logical constraints
  • table names
  • fields
  • data types
  • relationships between entities
  • visual representations to communicate the architecture of the database
  • foundation for an organization’s data management disciplie
  • data modeling

database users, database administrators, and programmer

it helps database administrators manage normalization processes to avoid data duplication

Database schema vs. database instance

• blueprint of a database
• how the data may relate to other tables or other data models
• schema does not actually contain data.

Inner joins

Joins on joins

Select *