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:
Get hands-on with 1200+ tech skills courses.