Database Basic Concept

Database Basic Concept

A Database consist of some used tables to save a data,

For example: pregnant Database Shop some tables be like: master tables customer, tables of sale master, tables of goods master, sale detail tables, tables of receivable, etcetera.

Table

A tables is corps record and field.

  • Record is representation a intact data.

  • Field is the information in one record.

Front-End

Is a link [among/between] user with used database to data process to be kept. Data process work well from and to Database itself.

Front end can be created use some programming languages be like under this:

  • Visual Basic
  • Visual C++
  • Visual Foxpro
  • Java

Marginally front application end divided become 2 category, that is :

  1. Decision Support Front End Application which only presenting and print the taken away from information Database either through predefined or user defined query.
  2. Transaction Processing Front End Applications including ability to edit, to add, and vanish record from database. Application this type of differentiated to Traditional DBMS, non-traditional DBMS and client/server DBMS.

Back-End

Back-End are Database itself

Some DBMS to be made [by] a Backend is as follows:

  • Microsoft Access ( desktop database)
  • Microsoft SQL Server ( server database, that is the database support the mechanism client server)

Download PDF File

No comments: