Database Management System · Unit 1
Database Fundamentals and Architecture
Exam-focused notes for Database Fundamentals and Architecture (Database Management System, BIT202): what the TU syllabus asks and how it has actually been tested, with 8 solved past questions from this unit.
What this unit covers
- Database definition and characteristics
- Advantages of DBMS over file systems
- Three-schema architecture layers
- Logical and physical data independence
- Database users and roles
- Data models, schemas, and instances
Three-schema architecture layers
Describe the three schema architecture. How does the architecture create data independence? [5]
The three schema architecture (also called the ANSI/SPARC architecture) is a framework for database systems that separates the database into three distinct levels or schemas. This architecture was proposed to achieve data independence and support multiple u...
Full solved answer →What is data independence? How three schema architecture ensures logical and physical data independence? [5]
Data independence is the ability to modify the schema definition at one level of the database system without affecting the schema definition at the next higher level. In simple terms, it means changes made to the structure or storage of data do not require ...
Full solved answer →What are the three layers of the Three-Schema Architecture? Explain. [5]
The Three-Schema Architecture (also called the ANSI/SPARC architecture) is a framework for database systems that separates the user's view of the database from the physical storage of data. It defines three levels of abstraction to achieve data independence...
Full solved answer →What is data independence? How three schema architecture ensures logical and physical data independence? [5]
Data independence is the ability to modify the schema definition at one level of the database system without affecting the schema definition at the next higher level. It means that changes made to the structure or storage of data should not require changes ...
Full solved answer →Advantages of DBMS over file systems
What are the Advantages of using DBMS? Explain in brief. [5]
(Note: Reference notes were not available for this topic; the following answer is based on standard Database Management System concepts as taught in BSc CSIT curriculum.) --- A Database Management System (DBMS) is software that manages the storage, retrieva...
Full solved answer →Database definition and characteristics
What is Database? Explain the characteristics of Database Approach. [5]
A database is a collection of related data that is organized, stored, and managed so that it can be easily accessed, retrieved, updated, and managed. It represents some aspect of the real world (called a miniworld or Universe of Discourse) and is designed f...
Full solved answer →Database users and roles
What are different types of Database Users? Explain in Brief. [5]
Database users are people who interact with the database system in different ways. They can be classified into the following types: --- - These are end users who interact with the database through predefined application programs (forms, menus). - They do no...
Full solved answer →Data models, schemas, and instances
Explain Data Models, Schemas, and Instances. [5]
A data model is a collection of concepts or tools used to describe the structure of a database. It provides a way to describe the design of a database at logical, physical, and view levels. Data models define: - The data itself - Relationships among data - ...
Full solved answer →Make Unit 1 stick
Practice BIT202 with flashcards & quizzes