The database (Database) is an integrated set of data that is organized to meet the needs of
the wearer. DBMS (Data Base Management System) is software that handles all access to
the data base.
Database System Database = DBMS + Database
File Structure Database
1. DATA is a unit of information to be processed, where before processing collected in a
database file. The data was collected systematically according to the structure
the database file.
2. RECORD is the data that it is a unity such as Name, Address, Phone Number. Any
statements that include Name, Address and Phone Number named one record.
Setiaprecord be numbered and called the number of records (Record Number). The size
of a database file is determined by the number of records stored in it.
3. FIELD is a sub part of the Record. From the example above, the contents of the record
consists of three fields, namely fields Name, Address fields and Telephone Number field.
Differences between Traditional File management File management with Database
* Traditional File Management
1. Oriented Program
2. Rigid
3. Kerangkapan data
* File Management Database
1. Data Oriented
2. Flexible
3. Nothing happens kerangkapan data
Advantages DBMS
• Reduce duplication of data
• The data have consistently
• Much of the information of the same data
• Sharing of data
• Develop data is already integrated
• Increased data security
• In accordance with standartisasi
• Economies of scale, Accurate, timely, and relevant than with waste costs.
• the need to balance out the problems
• The data can be accounted for
• Productivity
Lack DBMS
• Complexity
• capacity, if the data is very huge.
• Cost of DBMS
• Cost of hardware
• The impact of the error way of working
Components of DBMS
Hardware
Includes PC up to a computer network. Secondary storage (disk manegtic), I / O device
ex: disk drives), device controller, I / O Channels, and others. Hardware processor and
main memory, used to support the current database system software execution.
Software
DBMS, operating system, network software (if needed) and other supporting
applications programs.
Data
Data in a database system be it a single-user system or multi-user systems must be
integrated and can be used together (Integrated and Shared). Used by the organization
and description of datadisebut schema.
Procedures
Instructions and rules that must be included in the design and use of databases and
DBMS.
People
1. DA (Data Administrator), a person authorized to make strategic decisions and policies
regarding data
2.DBA (DataBase Administrator), provide technical support for implementation of these
decisions, and responsible for the overall control system on the technical level
3.Database Designers (Logical and Physical)
Application Programmers, was responsible to create database applications using existing
programming languages, such as: C + +, Java, and others.
4.End Users, Anyone who interacts with the system online through the workstation /
terminal.
Terms in a relational database
1. relations: a table that consists of several columns and
some lines
2. attributes / fields: columns in a relation
3. tuple / record: rows in a relation
4. domain: The set of valid values for one or more attributes
5. degree (degrees): number of attributes in a relation
6. Cardinality: the number of Tupelo in a relationship