What is Databases? Learn Information

Databases

---

Today we will learn About Databases and its additional information.

Content Outline

• Managing Files: Basic Concepts
• Database Definition
• Database Management System
• Database Models

Managing Files 

• Data Storage Hierarchy- levels of data stored in computer.

1. Database (an organized collection of integrated files that are connected)
2. Files  (A Collection of Related Records)
3. Records (a collection of related fields . Often called a row)
4. Fields ( A unit [individual piece] of data consisting of one or more character bytes. Often called a column)
5. Characters (bytes) ( a letter or a number or a special character)
6. Bits
7. Key Field (a field that is chosen to uniquely identify a record so that it can be easily retried and processes. )

What is Database (Definitions) 

• Structured a set of data held in a computer.
• An organized collection of related (integrated) files.
• A Database is a collection of related data or facts. 

Database Management System 

• Database management system (BDMS) - programs that control the hole structure of a database and access to the data is known as database management system.
• BDMS is a set of a collection of programs that control the database system.
• Advantages of DBMSes:

1. File Sharing.
2. Reduce Data Redundancy (situation in which the same database appears in many different files  and often in different formats).
3. Improved Data integrity ( measure of how accurate, consistent and how up-to-date data is).
4. Increase security.

Database Models

• just as files can be organized in different ways, so database can be organized in different types of ways, so database can be organized in ways to best fit their use.
• The four most common arrangements are :-

1. Hierarchical 
2. Network
3. Relation
4. Object-oriented

• Hierarchical Database

Types of fields or records are arranged in related groups, resembling in a family tree type, with child (lower-level) records subordinate to parent (higher level records.

• Network Database

It is similar to a hierarchical database, but each child record can have more tan one parent record.

• Relational Database

A type of Database which relates connects data in different files the use of key field, or common data element.