Introduction to Information Technology · Unit 5
Database Systems
Exam-focused notes for Database Systems (Introduction to Information Technology, BIT101): what the TU syllabus asks and how it has actually been tested, with 9 solved past questions from this unit.
What this unit covers
- Database system definition and components
- Database management system and importance
- Data model, schema, and instance
- Database system architecture levels
- Data redundancy and data inconsistency
- Characteristics of database systems
- Data warehousing and data mining
Database management system and importance
Define Database management System. What are the advantages of database management system?[10]
A Database Management System (DBMS) is a collection of interrelated data and a set of programs to access and manage that data. It is software that enables users to define, create, maintain, and control access to a database. The primary goal of a DBMS is to ...
Full solved answer →Explain Database Management system and its importance. Define Data redundancy and Data inconsistency. [3+2]
A Database Management System (DBMS) is a collection of interrelated data and a set of programs to access and manage that data. It provides an environment that is both convenient and efficient for storing, retrieving, and manipulating data. More formally: - ...
Full solved answer →Characteristics of database systems
Explain characteristics of Database system in brief. [5]
Note: Reference notes were not available for this topic; the following answer is based on standard database concepts as taught in BSc CSIT curriculum. --- A Database System is a computerized system that allows users to store, manage, and retrieve data in an...
Full solved answer →Data warehousing and data mining
Define data warehousing and data mining.Explain about any two types of language translators.Describe the significance of IoT in smart city with examples.[2+3+5]
--- A data warehouse is a large, centralized repository of integrated data collected from multiple heterogeneous sources within an organization. It stores historical and current data and is used primarily for reporting, analysis, and decision-making rather ...
Full solved answer →Write short notes on: a. IOT Write short notes on: b. Data warehousing and data mining. [2.5+2.5]
Definition: The Internet of Things (IoT) refers to the network of physical devices, vehicles, appliances, and other objects embedded with sensors, software, and connectivity that enables them to collect and exchange data over the internet. Key Components: -...
Full solved answer →Database system definition and components
Define a database system. Briefly explain the components of database system. [5]
A database system (also called a Database Management System or DBMS) is a computerized system that allows users to store, manage, retrieve, and manipulate data in an organized and efficient manner. It provides a way to define, create, maintain, and control ...
Full solved answer →Define a database system.List the components of database system.[2+8]
--- A database system is a computerized system that allows users to store, manage, retrieve, and manipulate data in an organized and efficient manner. It consists of a collection of interrelated data (the database) together with a set of programs (the DBMS)...
Full solved answer →Data model, schema, and instance
Define: Data model, Schema, and Instance. [5]
Note: The reference notes did not provide context for this topic. The following answer is based on standard database concepts as taught in TU BSc CSIT curriculum. --- A data model is a collection of conceptual tools used to describe: - The structure of data...
Full solved answer →Database system architecture levels
Discuss three levels of database system architecture in detail.[10]
The three-level database architecture (also called the ANSI/SPARC Architecture) was proposed by the American National Standards Institute (ANSI) Standards Planning and Requirements Committee (SPARC) in 1975. This architecture separates the user's view of th...
Full solved answer →Make Unit 5 stick
Practice BIT101 with flashcards & quizzes