Chapter 8 (Section 2 & 3) Final Revision #1
No description yet. This curated deck is ready for daily study.
Card preview (24)
Section 1: Database Management Systems (DBMS) Fundamentals
What is the formal definition of a Database Management System (DBMS)?
System software used for defining, creating, and manipulating a database.
What does the term “Data Management” encompass within a database context?
The process of organizing and maintaining data within a database to deliver necessary information.
Identify the main features that a DBMS provides for data management.
• A data dictionary that stores information about the data stored (e.g., field names and primary keys). • A logical schema that uses methods such as an E-R diagram to show the structure of the database and its relationships. • A query processor that allows a user to perform searches to find specific data. • A developer interface that allows the user to create tables, forms and reports. • Security and integrity facilities (e.g., access rights, backups, encryption).
Section 2: Addressing File-Based Limitations in a DBMS
How does a DBMS address the issue of Data Redundancy found in file-based systems?
By linking tables so that most data is stored only once; however, foreign keys are an exception as they must be stored in multiple tables to create links.
How does a DBMS handle inappropriate deletion of linked items?
The system flags errors if a user attempts to delete linked items, such as foreign key records, inappropriately.
How is “Data Inconsistency” resolved by a DBMS?
By storing most data items only once, updates become universally accessible across all applications, ensuring consistency.
What is “Data Dependency” in file-based systems?
A situation where changes to the data structure impact all associated applications.
How does a DBMS achieve “Data Independence”?
It decouples data from specific applications, allowing structural changes (like adding fields) to be managed with minimal impact on unrelated applications.
Section 3: Data Dictionary
What is a Data Dictionary?
A set of data containing metadata — data about other data within a database. It identifies the characteristics of the data that will be stored.
What metadata is typically stored in a Data Dictionary?
• Field / attribute names • Table name(s) • Data types • Primary keys // foreign keys • Validation rules • Relationships • Views • Indexing details
How does a Data Dictionary enhance data integrity?
By ensuring the accuracy, completeness, and consistency of the data through defined rules.
Section 4: Logical Schema
What is a Logical Schema?
• A conceptual design / overview of a database structure. • A data model that models the problem/situation, e.g., by using methods such as an E-R diagram. • Platform/database independent — independent of any particular DBMS used for its construction. • Used to design the physical structure of the database.
What is the focus of a Logical Schema?
It represents how data is logically structured, defining what data is stored, entity relationships, and constraints without detailing physical storage.
Which DBMS feature describes the relationship between data and its structure?
The Logical Schema.
What are the three main differences between a Data Dictionary and a Logical Schema?
• Definition: Metadata vs. conceptual design. • Scope: Table attributes vs. table relationships. • Format: Tabular structure vs. ER diagrams/textual representation.
Section 5: Query Processor and Developer Interface
What is the primary role of the Query Processor?
A DBMS feature responsible for processing and executing SQL-based queries.
Describe the purpose of a query processor in a DBMS.
• Allows the user to enter criteria. • Searches for the data that meets the entered criteria. • Organises the results to be displayed to the user.
What is the function of the DDL Interpreter?
It interprets Data Definition Language statements and records them in the data dictionary.
What is the function of the DML Compiler?
It compiles Data Manipulation Language statements into executable instructions and optimizes them for efficiency.