Skip to main content

DATABASE INTRODUCTION

Database: A database is an organized collection of related information in which facts are properly arranged and stored. 

A database is made up of a basic unit called “Table”. 

A table is made of different ‘Fields’ and ‘Records’. 

Record: Collection of organized data or related facts is called Record. 

Field: A field is a collection of same data types. 

DBMS (Database Management System): A database Management System is a tool for managing and manipulating information of a database. 

The main Functions of a DBMS is: 

  1. Creating Database. 
  2.  Adding Records. 
  3. Modifying Records. 
  4. Displaying Records. 
  5.  Storing Records. 
  6.  Deleting Records. 
  7.  Generating Reports. 
  8.  Printing Reports.
 Some Example of DBMS: MS Access, My-SQL,etc. 

Features of DBMS:

  1. DBMS ensures data security.
  2. DBMS facilitates the sharing of data among different database.
  3. DBMS controls data inconsistency to a large extent.
  4. DBMS reduces the data redundancy to a large context.
Data Consistency: Data consistency means that if any change is made in the data at one place, the corresponding changes in value of other information which is related to that data in other tables is also update.
Data Redundancy: Data redundancy mean storing of the same data in a duplicate form in different table separately in the same database.

Comments

Post a Comment

Popular posts from this blog

Computer Generations

 Computer Generations   Computers have evolved over time through different generations, each marked by significant technological advancements and changes in design and architecture. These generations are often categorized based on the underlying hardware and the key developments that distinguish one Generation from another. Let's explore the main computer generations: First Generation Computers    The First Generation of computers refers to the initial period of electronic computing, characterized by the use of vacuum tubes as the primary electronic component. This Generation spans the 1940s and 1950s and is marked by groundbreaking developments in computer technology.  Examples of First-Generation Computers:  o ENIAC (Electronic Numerical Integrator and Computer): Completed in 1945, ENIAC was one of the first electronic general-purpose computers. It was designed to calculate artillery firing tables for the United States Army during World War ...
2 comments
Read more

Programming in "C"

 Introduction   C is a general-purpose programming language that was developed in the early 1970s by Dennis Ritchie at Bell Laboratories. It has since become one of the most widely used programming languages and has influenced the development of many other languages, including C++, Java, and C#. C is known for its efficiency, flexibility, and low-level programming capabilities. It is commonly used for system programming, embedded systems, and developing operating systems. C is also a popular choice for developing applications that require high performance, such as game engines and scientific simulations.   Here are some key features and concepts of C programming:   Syntax: C has a relatively simple syntax compared to some other programming languages. It uses a combination of keywords, variables, data types, operators, and control structures to write programs.  Variables and Data Types: You declare variables to store data in C. Various d...
Post a Comment
Read more

ARITHMETIC OPERATIONS ON BINARY NUMBER

Binary arithmetic is simpler to learn because binary number system deals with only two digits - 0 and 1. Binary number perform all arithmetic operation such as Addition, Substraction, Multiplication and compliment as in decimal number system. Binary Addition The addition table for binary arithmetic consist of only the following four entries: 0+0=0 0+1=1 1+0=1 1+1=0 , plus a carry of 1 to the next column.     1011        + 1100    10111     1100    + 1100     11000 Binary Substraction There are three ways to do substraction between binary numbers:- 1. Simple Substraction 2. Substraction using 1's Complement 3. Substraction using 2's Complement Simple Substraction: The complete table of binary substraction is as follows: 0-0=0 0-1=1, borrow 1 from next column 1-0=1 1-1=0    1101 - 0101   1000     1001   - 0111    0...
Post a Comment
Read more