What is a database?
Databases are defined as a set of information that is accessed by a computer for special searches and this information is stored on a storage device like a magnetic disk file in letters and words, Contains scientific and technical data and a personal computer can maintain a small database that is used by in-house individuals and is characterized by being interconnected and compatible with office computer programs, including spreadsheet programs. This makes them more desirable and important in business life
Database management system
Database management systems contribute to supporting
governments and organizations as important tools for storing, organizing,
retrieving, and identifying data, and modern database management systems are
complex software applications based on the collection and capture of data from
individual sources.
Databases and their management contain a list of names and
numbers on mobile phones, and with the development of the Internet, this
network has proven that users can access a wide range of data remotely using a
few elements such as modems, personal computers, and communication programs.
And an important issue for companies.
The main responsibility is a joint responsibility between
the network administrator and the database manager and if the base is on the
network, the first line of defense to protect it is the network security
database management system known as a language that works in the data
processing.
ORCAL is a commercial program that is used in many
applications, including assisting in the process of data collection and
creation, correcting and removing barriers that limit its organization, and
these programs are used to enter new information and change the actual data at
the base and used in various applications To protect data, monitor users, deal
with system errors, and recover lost data due to these errors by managing
processes such as data recovery and setting security rules to contribute to the
way users are managed in the database.
Advantages of use
Advantages of use There are several advantages to using DBMS
to manage and manage databases, including the following: Data protection.
Strategies to enable multiple users to access data simultaneously, as well as
to prioritize between them by locking the base from specific users.
If there are any errors or failures the system is likely to
recover very quickly.
Recording various activities in activity data. The ability
to deal with it and the ability to access data only through the API.
Database
Databases are very important for databases in different
businesses and their importance is present at many points, including Databases
help greatly in speeding up the process of accessing the data contained in
them,
so the process gathers the necessary information instead of
searching here for convenience. It accesses it and employs it in various tasks
in processing or in the future.
Databases greatly help in the process of correcting this
data in the future and greatly facilitate the process of deleting or adding
additions as well as making necessary updates. Databases help to answer any
questions or inquiries directly related to the data stored and stored within
these rules at any time.
Helps to integrate and collect big data in a categorical
manner to facilitate management and retrieval.
Database support
Database Support One of the most popular languages used to
build databases is SQL (Structured Query Language). SQL has a set of
instructions or commands that can be divided into three groups according to
their nature: Or select to retrieve some records from multiple tables.
INSERT to create a
record. Delete the record. Update to change the record. DDL: Data definition
language and has the following instructions: Create a table, or (view), or
(index) or any other purpose. DROP to delete a table or any other motive.
Option to amend the schedule or any other purpose. DCL: Language of Data
Control It contains the following instructions: Grants give the user the
opportunity.
Database design
Database Design Database is a science that must analyze the
system and what information it must store. The first step in designing a
database and program is to analyze what the system wants, and we will learn
about the steps of database design.
Determine the purpose of the database: The concept of the
system must be complete in order to be aware of the purpose of the system.
Finding all the necessary information: The designer must be fully aware of all
the information that he wants to enter in the fields and tables as required by
the system without any reduction or increase.
Dividing the information into tables: This is the most important
step so that the information is distributed in the tables, so let's say there
is a registration system for the student, there is a table called Student
Information,
where there are fields like student name, principal,
address, college, etc. Inserting Fields in Tables: Generally, after designing
tables and not applicable, fields are added and information that can be added
or deleted is added before the table creation process.
Creating Tables and Primary Keys: To be able to deal with
data, each table must have a primary key and the key must be selected with an
integer field. Draw Relationships Between Tables: There are general
relationships between tables that have a relationship. The user can deal with
multiple tables.
Here, the relationship between the tables must be drawn and
applied. Design Confirmation: Confirming databases by applying certain
sentences to determine whether the data retrieval process is correct and the
advantage of this step is to know the problems, identify them, and solve them
properly.
Database type
Databases The types of databases are defined as a set of
interconnected organized data on a computer, but their importance stems from
the ability to easily and efficiently modify and update as well as deal with
large amounts of data and store them with the information organized and
processed. Four different types are used to organize data in its database.
Network Databases Network databases are increasingly named
because of the classification rules and were designed as flexible ways to
present interconnected topics and relationships, and one advantage is that they
are simpler in design and concept and require more efficient information than
stratification.
In that sense, it is possible to access data and distinguish
programs from the complexity of storage devices rather than classified models,
and may have such limitations as structural adjustment difficulties with its
size, and may have difficulty inserting, deleting, or modifying any record.
Databases are goal-based
Object-oriented database data is programmed to reveal
specific goals and topics and is different from table-based related databases;
Where reliance depends on the concept of a programming
language that focuses on the subject and is currently widely and widely used
and one of its advantages is the ability to work with different types of data
as opposed to relational systems related to a form and images in these forms,
Includes text, numbers, and other digital media. Lower maintenance costs than
other types.
0 Comments
If you have any question ask me in comment below.