Database Management System · Unit 1 · 2 hrs
Database and Database Users
Exam-focused notes for Database and Database Users (Database Management System, CSC265): what the TU syllabus asks and how it has actually been tested, with 4 solved past questions from this unit.
What this unit covers
- Introduction
- Characteristics of the Database Approach
- Actors on the Scene
- Workers behind the Scene
- Advantages of Using the DBMS Approach
Advantages of Using the DBMS Approach
What is fat-file system? What are the advantages of using DBMS approach? [5]
--- A fat file system (also called a file processing system or flat file system) is a traditional approach to data management where data is stored in separate, independent files managed directly by individual application programs. Each application maintains...
Full solved answer →What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.[10]
--- A Database Management System (DBMS) is a software system that enables users to define, create, maintain, and control access to a database. Traditional file systems store data in flat files managed by individual application programs, which leads to sever...
Full solved answer →Actors on the Scene
What are different types of Database users and their roles? Explain the Data independence with example.[10]
--- A database typically has many types of users, each of whom may require a different perspective or view of the database. A view may be a subset of the database or it may contain virtual data. Since a multiuser DBMS serves users with a variety of distinct...
Full solved answer →Characteristics of the Database Approach
What are the characteristics of database approach? Explain. [5]
The database approach has several important characteristics that distinguish it from traditional file-based systems. Among these, three most important characteristics form the basis of the three-schema architecture, which was proposed to help visualize and ...
Full solved answer →Make Unit 1 stick
Practice CSC265 with flashcards & quizzes