Introduction to Database - Adjusted Answers by Marks
1. What is a database?
A database is an organized collection of data that allows easy access, management, and updating.
It stores information in a structured format such as tables, rows, and columns. [1 Mark]
2. What is a Database Management System (DBMS)? How does it differ from a traditional file
system?
A Database Management System (DBMS) is software for creating, managing, and accessing
databases. Unlike traditional file systems, DBMSs ensure data integrity, reduce redundancy, and
provide concurrent access control. Traditional file systems lack security and structure, leading to
inefficiency in handling large volumes of data. [2 Marks]
3. List and explain the primary components of a DBMS.
The primary components of a DBMS include:
- **Hardware**: The physical devices that store the data.
- **Software**: The DBMS software managing the database.
- **Data**: The stored data itself.
- **Users**: Administrators, developers, and end-users interacting with the DBMS.
- **Procedures**: The rules and instructions guiding the DBMS usage. [3 Marks]
4. What are the advantages of using a DBMS?
Advantages of a DBMS include:
1. **Data Integrity**: Maintains consistency and accuracy.
2. **Data Security**: Protects from unauthorized access.
3. **Redundancy Reduction**: Minimizes duplicate data.
4. **Efficient Querying**: Facilitates quick data retrieval.
5. **Concurrent Access**: Allows multiple users to access data simultaneously. [3 Marks]
5. What are the key functions of a DBMS?
Key functions of a DBMS include:
1. **Data Storage and Retrieval**
2. **User Management**
3. **Backup and Recovery**
4. **Security Enforcement**
5. **Query Processing and Optimization**. [2 Marks]
6. Explain the concept of data abstraction in a DBMS.
Data abstraction in a DBMS involves hiding complex database structures and presenting simplified
views to users. It includes three levels: physical (storage details), logical (data structure), and view
(user-specific views). This improves usability and simplifies database management. [2 Marks]
7. What is data independence? Why is it important in database management?
Data independence refers to the capacity to modify the database schema at one level without
impacting higher levels. It is essential because it simplifies maintenance, reduces system downtime,
and enhances flexibility. [3 Marks]
8. Differentiate between logical and physical data independence.
- **Logical Data Independence**: Changes in logical schema don't affect external views.
- **Physical Data Independence**: Changes in storage schema don't affect logical schema. Logical
independence is more difficult to achieve than physical. [2 Marks]
9. How does data independence contribute to database system efficiency?
Data independence enables schema modifications without affecting the entire system, reducing
maintenance time and improving adaptability. It allows efficient handling of evolving user
requirements. [2 Marks]
10. What is database system architecture? Why is it important?
Database system architecture describes the overall design of a DBMS, including hardware,
software, and data. It is crucial for ensuring scalability, reliability, and efficient data processing. [2
Marks]
11. Explain the external, conceptual, and internal levels of a database system. What is the
significance of each level in database management?
The database has three levels:
1. **External Level**: User-specific views.
2. **Conceptual Level**: Logical structure of the entire database.
3. **Internal Level**: Physical storage details. These levels provide data abstraction, enhancing
flexibility and security by separating concerns. [5 Marks]
12. What is mapping in the context of database levels?
Mapping defines the correspondence between database levels, ensuring consistent data
representation and efficient query processing. It helps translate user requests across different levels.
[3 Marks]
13. Who are the different types of users in a database system?
Types of users include:
1. **Database Administrators (DBA)**: Manage the DBMS.
2. **Developers**: Design applications.
3. **End Users**: Use the database for queries.
4. **Analysts**: Extract insights. These roles ensure the database operates efficiently. [4 Marks]
14. What are the key responsibilities of a Database Administrator (DBA)?
A DBA is responsible for:
1. **Database Design**
2. **User Management**
3. **Security Enforcement**
4. **Backup and Recovery**
5. **Performance Tuning**. These ensure optimal and secure database operations. [3 Marks]
15. What is a data model? Why are data models important in database design?
A data model is a framework for organizing data relationships and constraints. It is vital in database
design as it ensures consistency, clarity, and efficient data management. [2 Marks]
16. Explain the hierarchical data model with an example.
The hierarchical data model structures data in a tree form with parent-child relationships. For
example, a company's organizational chart where a CEO (parent) oversees managers (children).
This model simplifies hierarchical data representation. [3 Marks]
17. What is the network data model? How is it different from the hierarchical model?
The network data model organizes data using graph structures with many-to-many relationships.
Unlike the hierarchical model, it allows nodes to have multiple parent and child nodes, providing
more flexible relationships. [3 Marks]
18. Describe the relational data model. Why is it widely used in modern database systems?
The relational data model uses tables (relations) with rows and columns for data storage. Its
simplicity, support for SQL, and ease of use make it the most popular model for modern databases.
[3 Marks]