Schemas and Instances
The schema and instance are the essential terms related to databases. In this lesson, we will discuss the key differences between the two.
Database schema
A schema is the blueprint of a database. The names of tables, columns of each table, datatype, functions, and other objects are included in the schema.
We use the schema diagram to display the schema of a database. The schema diagram for the university database can be seen below:
Student Table
| ID | First_Name | Last_Name | Class | Major |
|---|
Course Table
| Course_ID | Course_Name | Course_credits |
|---|
Department Table ...