The database is a collection of data that is located in a place, where the data is interrelated, and can later be utilized.

There is some  Basic Operations of Database. To facilitate understanding, I will do it as a parable data base cabinets. For example, database like a cupboard. Things we can do with cupboard or Basic Operations of Database, namely:

1. Creating a cupboard itself. Out of what material, the improtant thing is the cupboard is set up. After that so we can fill it with stuff that we like (create database).
2. Discard the cupboard or wipe out the closet. If in this case, the contents inside the cupboard and even then go missing. (drop the database).
3. To fill the cupboard, we have to split the cupboard, so the cupboard is fairly and according to our wishes. Whether it's clothing, food, or other equipment (create table).
4. We can also remove the contents inside the cupboard without having to dispose inside it. Because someday, we can use the cabinet to another place (drop table).
5. In each section of the cabinet, we can perform the charging operation (insert).
6. Other operations that can be done on the cabinet, namely: decision (select).
7. Changes in the contents section of the cabinet (update).
8. And the latter is the deletion (delete)

That is a brief explanation about Basic Operations of Database, which can be performed on a database. If something is missing, please understandable. May be useful ..

The database is a repository of data within an information system. The database has advantages and disadvantages to its use in the real world. In this post, I will discuss about the advantages and disadvantages of database usage. 

Here are the advantages and disadvantages of database usage which I briefly from several sources:

1. Advantages of database usage:

• Inconsistencies data can be controlled, so that there is no duplicate data.
• Maintaining data alignment.
• Data can be used together (share)
• Facilitate the application of standardization
• Facilitate the implementation of restrictions security
• Maintaining data integrity.

2. Disadvantages of database usage:

• Expensive in implementation
• Complicated / complex
• Damage to the database system can be affecting the departments concerned.

That was a brief description about The Advantages and Disadvantages of Database Usage. If there are errors or omissions please add or justified. May be useful.

The database is a repository of data within an information system. In the use of database, there is some of term that layman does not know. In this post, I will discuss about The Term that Used in Database.
 

Here is The Term that Used in Database:

1. Enterprise, this term defines an organization or company. Such as: universities, hospitals, hotels, etc.
2. Entities, are objects that are distinguished by other objects. The entity is the contents of the enterprise. Example: The academic system at a university enterprise is mahaiswa, KHS and payment.
3. Attribute / field, each entity has an attribute or a designation to represent these entities with other entities. Example: Entity students have the attributes of NPM, nama_mahasiswa and address.
4. Data Value (the data content), is the term to mean the data or information stored on each attribute. Example: attribute nama_mahasiswa: Ade Perdhana, while the data value for NPM: 0735010090.
5. Record / tuple, is a collection elemenn-elements that are interrelated and provide an information about an entity in full. Record is a horizontal row on a table in the database. Example: a record represents a single data or information = NPM, nama_mahasiswa, address.
6. File, a collection of records that have the same attributes but different data valuenya.
7. Key data elements, is an identifier uniquely identifying an entity from other entities.
8. Database Management System (DBMS), which defines the terms of the database software. Such as Oracle, MySQL, SQL Server, etc..

That was a brief explanation of The Term that Used in Database. If there are errors or omissions please justified or added. May be useful.

In this post, I will discuss a bit about what it's database. For more detail, let us look at the picture below.

  In the picture above, a filing cabinet is the basis or place, while the employees, purchasing, production and sale of the data. So the database can be inferred a data storage medium. Where in the cabinet, the data is laid out neatly.

So, the System Database are:

     The set of group data (files) that are interconnected are organized in such a way that can later be used again quickly and easily
     A collection of related data stored together and without repetition (redundancy) is not necessary, to meet the various needs
     Collection of files / tables / archives interconnected stored in electronic storage media.

Not all forms of electronic data storage (computer) can be called a database. We can save the document contains data in text files (with word processing programs), but can not be called as a database. Because in it there is no sorting & grouping data according to the type / function will complicate the search data so that data later.

The highly featured in the database is a setting / sorting / grouping / organization of data that we will save according to the function / type. Sorting / grouping / organization can form a number of files / separate tables or in the form of defining kolom-kolom/field-field data in each file / table.

May be useful ..