Database

Database is place where not only your data get store as well as relationship between data and information also been stored. The primary basis of the database is information associates with the problem is used by many users or even by a single user. Users don’t need to worry about the various type of data how it could be store on their computer. Database is prepared from information related to each other. It is expressed in tabular form. Database is proper arrangement of information. There is no use of unarranged information. Database is a collection of a large amount of data.

 

Database Terminology:

1.     Attribute :- In general, an attribute is a characteristic. In a database management system, an attribute refers to a database component, such as table. It also may refer to a database field. Attributes describe the instances in the row of database.

 

          

2.  Record :- In databases, a record is a group of related data held within the same structure. Specifically , a record is a group of fields within a table that references one particular object. The team record is frequently used synonymously with row. A record is also known as a tuple. For example a student record may include items, such as first name, roll no, address, email address, date of birth and gender.

 

3.  File :- A file is a container in a computer system for storing information. Files in computer fields are very similar in features to that of paper documents used in library and office files. There are many kind of files such as text files, data files, directory files, binary and graphic files etc and these different types of files have different types of information. But the database file is a combination of records which are interrelated with each other.

 

How to design a good database :

These days all the commercial areas nearly depends upon the database. Means all the business activities done by the computer which are very accurate and up to date. So it becomes necessary when designing a database that take care of certain things that are as follow:

1.    The data which is going to store in database must be accurate, well arranged   and complete so it could be easily fetch when required by someone.

2.     While creating database system we have to keep in mind that whether database  application is going to use on any website or any another local area or on both the result must be able to get very fast and accurate.

3.    The database design is the main aspect of the database we can’t ignore it if the  database design is not planned well a good program cannot get rid of facing problems to run on it.

                4.     Database should be design while thinking about the future problem.