What is database?-Database(DB)-Data Definition and Database Mining-DB
What is database?
A database is a program that consists of one or more related files. There are several data related to each other. In simple words, the database means data format. Otherwise, we can say more about the database where the data can be stored. The information stored in a file stacked before the invention of the computer, the data is now stored in the database. There are different programs to make a database.
Characteristics of the database (DB) or characteristics:
- Ascending and descending.
- sorting, and indexing can be arranged.
- All the information can be stored.
- It is possible to provide data security.
- You can control the data centrally.
- The data can be expressed in the form of a graph or table.
- It can be created in a report form.
DBMS means complete data management system.
RDBMS – Relational database management system.
What is DBMS?
DBMS is a program or softw are. Complete the DBMS database management system . It is possible for DBMS to create a database, change the database, save it, manage it, and control it.
What is the field?
The smallest part of the record is called Field.
What is the record?
How many fields are called registers?
What does the key mean?
What is called the field with which a record different from any other record is recorded in the database.
Three types of keys. Such as:
- What is the main key?
- What is the foreigner?
- Composite primary key
What is it called mainly DB?
With the help of a field, a record can be unique or uniquely identified is called primary in the database. For example, the roll number of a class is unique, the primary roll number is the primary number. Someone’s mobile number and what can be called primary.
What is the foreign name?
If a primary key of one table is used as the general key of another table, what is externally called?
What is the composite primary?
The primaries that are made with two or more fields are called composite primaries.
What is a classification or time?
The classification of the data in the database or the classification of the data in the database is called classification.
What does the key mean?
What is called the field with which a record different from any other record is recorded?
Three types of keys.Such as:
- What is the main key?
- What is the foreigner?
- Composite primary key
What is it called the Primary key?
With the help of a field, a record can be unique or uniquely identified as what is called primary. For example, the roll number of a class is unique, the primary roll number is the primary number. Someone’s mobile number and what can be called primary.
What is the foreign key?
If a primary key of one table is used as the general key of another table, then its called a foreign key.
What is the composite primary?
The primaries that are made with two or more fields are called composite primaries.
What is a classification or time?
The classification of the data in the database is called classification.
Ascending Order → Say Acceleration.
The decreasing order means → nomenclature.
What are the characteristics of a Database (DB)?
After the new data entry, it must be ordered again.
- If the database file is sorted, the original data file will be stored in the formatted memory.
- It takes a relatively long time to find the data in the classification.
There is no need for additional zoos in memory.
What is DATA indexing in Database (DB)?
The databases in the database are considered as indexing in combination.
Mark the indexing properties.
- After updating the new data in the indexing, it is automatically updated.
The indexing of the database file creates a new index file.
Finding data in indexing takes less time.
- Additional memory space is required in the indexing.
What is the DATABASE relationship?
To establish a relationship with another table in data is called a database relationship.
The relationship can be divided into four main categories.
Such as
- One to one
- One to many
- Many to one
- Many to many
Benefits of access to the database or DB :
- The maximum use of space avoiding duplication of the same information. Suppose that, in a school database, there are three types of tables. In the first table, the information about the test result of the students. Your salary information on the second table. Third table your personal information You can see, in each table, the names of the students are mentioned. However, by using the Database Management System, we can save student names only in one place, and then we can provide references to that site.
- Dissolve information discrepancy. The information stored separately may have interruptions or logical incompatibility. When the information is stored in DBMS, any discrepancy of information can be identified. For example, the title of the image of the same person can not be different. It was found, by sending the same image or information, two different people used two different names. It is possible to detect using DBMS.
- Several users can work with the same information at the same time
- Confirm the security of the information. After renewing the information, make sure it is not deleted before saving it. For example, after updating 200 data to a database, electricity can be released before it can be stored. The solution to this problem is in DBMS. DBMS maintains a list of information changes. When necessary, information is retrieved through those pre-selected indices.
- Create self-sufficient information. This means that the information does not depend on information management programs. It will be useful to know that the information created by a DBMSA can be used in other DBMS.
- Find the information in the shortest time.
- Create a database easily and in a short time. (website)
