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.
We'll cover the following...
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 ...