Basic Concept And Terminology Of DataBases

OVERVIEW:

In the previous data basic I have discussed Files and Reports in detail. In fact, the concept of databases evolved from the old, traditional working of File Management System (FMS).

Comments

Post a Comment

Popular posts from this blog

Microsoft Access-Forms And Reports

OVERVIEW Access Forms creates the user interface to your table. Although you can use Datasheet to perform many of the same functions as forms. Forms are used as an alternative way to enter data into a database table. It provides a different way of viewing table data. Access enables us to create forms that can be used to enter, maintain, view, and print data.               The Form is constructed from a collection of individual design elements called controls or control objects. Control are the components we see in the windows dialog boxes of the access and other windows applications like buttons, check boxes etc. We use text boxes to enter and edit data, labels to hold field names and object frame to display graphics.               A Form Wizard is provided to assist you in the construction of forms. Four types of forms can be created. These include single-column ( displaying one record at a time in a verti...
Read more »facebook

Data Integrity And Normalization

OVERVIEW: Data Integrity: Database integrity refers to the correctness and consistency of data. It is another form of database protection. While it is related to security and precision, it has some broader implications as well. Security involves protecting the data from unauthorized operations, while integrity is concerned with the quality of data itself. Integrity is usually expressed in terms of certain constraints which are the consistency rules that the database is not permitted to violate. Following two are the most important constraints in relational database: (i)       Entity Integrity: is a constraint on primary values that states that no attribute of a primary key            should contain nulls. (ii)      Referential integrity: is a constraints on foreign key values that states that if a foreign key                  exist in a relation, then either the foreign k...
Read more »facebook

Data Base

 A   Data Base is a collection logically related data sets or file . No r maly, these files /data sets are of different nature, used for specific purposes. these may be organized in various ways to meet processing and retrieval requirements of the organizations or users.                                      A  Data base system is just a computerized record keeping system. A data base itself can be regarded as a kind of electronic file cabinet, a warehouse or a repository for a collection of computerized data files. the user of he database normally has he following facilities to enjoy. Adding new , blank file to the database. Inserting new data into the existing files. Retrieving data from existing files. Updating data in existing files. Deleting data from existing files. Removing existing files, empty or otherwise from the database. A database syste...
Read more »facebook