Database Management System (DBMS)
Class 12 Computer Science - Database Management System Full Notes with Summary and MCQs.
Summary
Data: Data is defined as the facts and figures. It can be any character including text and numbers, pictures sound, or video.
Information: Information is an organized collection of related data which gives a complete sense. It also involves the manipulation of raw data.
Database: A database is a collection of related data organized in a way that can be easily accessed, managed, and updated. For example: customer records, telephone diary, result sheet.
DBMS: A database management system (DBMS) is software that allows a computer to perform database functions of storing, retrieving, adding, deleting, and modifying data.
Table: A database table is composed of records and fields that whole data. Tables are also called datasheets.
Field: A field is a column in a table that is designed to maintain specific information about every record in the table.
Record: A record is all of the data or information about one person or one thing.
File: A file is an object on a computer that stores data, information, settings, or commands use with a computer program.
Primary key: A primary key is a column that contains values that uniquely identify each row in a table. It cannot contain null values.
Normalization: It is a systematic approach to decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update, and Deletion anomalies.
Centralized database system: Centralized computing is similar to a client/server architecture where one or more client PCs are directly connected to a central server.
Distributed data system: It is a collection of multiple interconnected databases, which are spread physically across various locations that communicate via a computer network.
Next ---> Unit 2 - Networking
Notes By Ranjan Dulal.
Published by NotesPT, visit www.notespt.ml for more.