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

History of Language "C"

  History of C      The history of C programming dates back to the early 1970s when Dennis Ritchie created it at Bell Laboratories. Here's a brief timeline of the major milestones in the history of C:  1969: The development of C began as a successor to the B programming language, which Ken Thompson created. Dennis Ritchie wanted to improve upon B's capabilities and efficiency.  1972: The C programming language was developed primarily to support the development of the Unix operating system. Ken Thompson and Dennis Ritchie rewrote Unix in C, which helped in porting the operating system to different computer architectures easily. 1978: The first edition of "The C Programming Language," also known as the "K&R C," was published. Brian Kernighan and Dennis Ritchie wrote it, becoming the authoritative reference for C programming. 1983: The American National Standards Institute (ANSI) formed a committee to establish a standard for the C language. The ...
Post a Comment
Read more