Database
An organized collection of information arranged and presented in alphabetical order.
Functions of Database
To store, organize and control data.
Components of Database
Data item- It is a field in data processing and it is a piece of information
Schema- It describes the organization of data and its relationships within the database. The Schema consists of the definitions of the various types of records in the database, the data-items they contain and the sets into which they are grouped. ( known a ERD)
Fundamentals of Database
FIELD- A category of data such as last name, etc.
RECORD- A group of related fields that describe a person, place, thing or a transaction.
KEY FIELD- A field that contains unique information for each record
TABLE- A collection of records for a single subject
RELATIONAL database- Multiple tables that are linked together to a business process.
OBJECTS- The parts of an access database that help you view, edit, manage and analyze the data.
DBMS- Database Management System
A software package for manipulating databases A database management system is a set of software programs that allows users to create, edit and update data in database files, store and retrieve data from those database files. Data in a database can be added, deleted, changed, sorted or searched all using a DBMS.
Examples: MySQL, PostgreSQL, Foxpro, etc.
Features of DBMS
1. Allows users to create new databases.
2. Give users the ability to query and modify the data using appropriate language
Query= performs the function of manipulation and processing of the data stored in the database using DML.
3. It provides information to the decision makers that they need to make important decisions
Types of DATABASE LANGUAGE
DDL (Data Definition Language)
DML (Data Manipulation Language)
DCL (Data Control Language)
DMBS Users are the End users, Application Programmers and Database Administrators
Next we were introduced to DATABASE MODELS.
Data model:
Structure
Characteristic
Description
Organization
The basic building blocks for all data models are:
Entity- Represents a particular object in the real world.
Attributes- Characteristic of an entity
Relationship- Describes relationship among entities. There are three types of relationships one to one ( Ex. student - student ID), one to many (Mother - children) and many to many (Student - subject)
Types of Database Models
Hierarchical database ( Uses tree structure.May establish one to many relationship)
Network database ( Many to many relationships is shown)
Relational database ( Organized in forms of rows and columns)
Object-relational database
Which database model to use?
It depends on the following factors
Organization's primary goals and objectives
Volume of transaction/information in an organization.
An organized collection of information arranged and presented in alphabetical order.
Functions of Database
To store, organize and control data.
Components of Database
Data item- It is a field in data processing and it is a piece of information
Schema- It describes the organization of data and its relationships within the database. The Schema consists of the definitions of the various types of records in the database, the data-items they contain and the sets into which they are grouped. ( known a ERD)
Fundamentals of Database
FIELD- A category of data such as last name, etc.
RECORD- A group of related fields that describe a person, place, thing or a transaction.
KEY FIELD- A field that contains unique information for each record
TABLE- A collection of records for a single subject
RELATIONAL database- Multiple tables that are linked together to a business process.
OBJECTS- The parts of an access database that help you view, edit, manage and analyze the data.
DBMS- Database Management System
A software package for manipulating databases A database management system is a set of software programs that allows users to create, edit and update data in database files, store and retrieve data from those database files. Data in a database can be added, deleted, changed, sorted or searched all using a DBMS.
Examples: MySQL, PostgreSQL, Foxpro, etc.
Features of DBMS
1. Allows users to create new databases.
2. Give users the ability to query and modify the data using appropriate language
Query= performs the function of manipulation and processing of the data stored in the database using DML.
3. It provides information to the decision makers that they need to make important decisions
Types of DATABASE LANGUAGE
DDL (Data Definition Language)
DML (Data Manipulation Language)
DCL (Data Control Language)
DMBS Users are the End users, Application Programmers and Database Administrators
Next we were introduced to DATABASE MODELS.
Data model:
Structure
Characteristic
Description
Organization
The basic building blocks for all data models are:
Entity- Represents a particular object in the real world.
Attributes- Characteristic of an entity
Relationship- Describes relationship among entities. There are three types of relationships one to one ( Ex. student - student ID), one to many (Mother - children) and many to many (Student - subject)
Types of Database Models
Hierarchical database ( Uses tree structure.May establish one to many relationship)
Network database ( Many to many relationships is shown)
Relational database ( Organized in forms of rows and columns)
Object-relational database
Which database model to use?
It depends on the following factors
Organization's primary goals and objectives
Volume of transaction/information in an organization.
No comments:
Post a Comment