Back to notes
Differentiate between a database schema and a database instance.
Press to flip
A schema is the fixed structure of a database, while an instance is the data contained in the database at a particular moment and can change over time.
What happens to a database instance when data is added or deleted?
When data is added or deleted, the database instance changes as it reflects the current state of the data.
What typical fields might be found in a 'Course' table within a university database?
Fields typically include course ID, title, department name, and credits.
What is the definition of a schema in a database context?
A schema is the overall design of a database, defining its structure which includes tables, rows, and columns.
Explain how database administrators contribute to the maintenance of a schema.
Database administrators manage changes to the schema, ensuring the database structure supports current and future data requirements efficiently.
How many levels of abstraction are there in databases and what are they?
There are three levels of abstraction: View Level, Logical Level, and Physical Level.
How does the concept of a database schema relate to a variable declaration in programming?
A database schema is similar to a variable declaration as both define a fixed structure, where the schema structures data organization and variables define data types and sizes.
What are some characteristics of a database schema?
Once fixed, a schema is not frequently changed and changes require intervention by a database administrator.
Why is understanding instances and schemas crucial in database management?
Understanding instances and schemas is crucial as schemas define the fixed structure of the database, while instances represent the dynamic data allowing effective database management and manipulation.
How does a database instance relate to variable values in programming?
A database instance is akin to the value of a variable, representing data that can change as new data is added or existing data is altered.
In the context of database abstraction, what knowledge does the physical level convey to a database administrator?
The physical level provides knowledge about the actual storage of data, which is important for database administrators.
How does the logical level of abstraction differ from the physical level?
The logical level defines the structure of the database, while the physical level pertains to the actual storage method and layout of the schema data.
Give an example of how data abstraction benefits application developers.
Data abstraction allows application developers to interact with the database without needing to understand the complexities of how data is physically stored.
What is the role of the view level in database abstraction?
The view level provides sub-schemas or views to users to hide the complexity of the data structure.
What fields might you expect in a 'Department' table of a university database schema?
Fields might include department name, building, budget, and head of department.
Previous
Next