Skip to main content

What is database and explain characteristics of database ?

Data: A data is a piece of information or facts. A data can be in any form like numbers, texts, piece of paper, measurements and bytes. For example, Student name, age, class, roll no. image etc. A file, pdf and document can also be a data.

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects.

OR

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.

Key features of DATABASE.
  • Database is always well ordered.
  • Database is interlinked.
  • It is stored only once.
  • Easy retrieval of information
  • Made up of fields, records and files
For example a phone book carrying thousand of numbers in it is the basic example of database. In phone book you can search any number without any problem because all the numbers are arranged in a systemic order.
Other Examples are: Electric Service Provider, Address Book and Bill Book Etc.

 Characteristics of database

 Self Describing nature
A database is of self describing nature; it always describes and narrates itself. It contains the description of the whole data structure, the constraints and the variables.
It makes it different from traditional file management system in which definition was not the part of application program. These definitions are used by the users and DBMS software when needed.

Represent Some Aspects of real world applications
A database represents some features of real world applications. Any change in the real world is reflected in the database. If we have some changes in our real applications like railway reservation system then it will be reflected in database too.
For example, let us take railway reservation system; we have in our mind some certain applications of maintaining records of attendance, waiting list, train arrival and departure time, certain day etc. related to each train.

Manages Information
A database always takes care of its information because information is always helpful for whatever work we do. It manages all the information that is required to us. By managing information using a database, we become more deliberated user of our data.

 Easy Operation implementation
All the operations like insert, delete, update, search etc. are carried out in a flexible and easy way. Database makes it very simple to implement these operations. A user with little knowledge can perform these operations. This characteristic of database makes it more powerful.

Multiple views of database
Basically, a view is a subset of the database. A view is defined and devoted for a particular user of the system. Different users of the system may have different views of the same system.
Labels:

Comments

Post a Comment

Popular posts from this blog

Define the following terms: Entity, Attribute, Attribute Value, Relationship Instance, Composite Attribute, Multi-valued Attribute, Derived Attribute, Complex Attribute, Key Attribute, Value set(Domain), Recursive Relationships?

Entity – An entity can be a real-world object, either animate or inanimate, that can be easily identifiable. For example, in a school database, students, teachers, classes, and courses offered can be considered as entities. All these entities have some attributes or properties that give them their identity. Attribute – In general, an attribute is a characteristic. In a database management system (DBMS), an attribute refers to a database component, such as a table. It also may refer to a database field. Attributes describe the instances in the row of a database. Attribute Value – Attribute value is the real data of a particular entity for each of its attributes. In other word, associated with each real world entities are certain attributes that describe that entity; value of these attributes for any entity is called attribute value. For example, attribute value of first_name of attribute of student_name can be Gyanendra.  Relationship Instance – Each relationship instance ri...
Post a Comment
Read more

Define Primary Key, Candidate Key and Super Key?

Super Key Super Key is defined as a set of attributes within a table that uniquely identifies each record within a table. Super Key is a super-set of Candidate key. Example - Suppose we have a table that holds all the managers in a company, and that table is called Managers. The table has columns called ManagerID, Name, Title, and DepartmentID. Every manager has his/her own ManagerID, so that value is always unique in each and every row. This means that if we combine the ManagerID column value for any given row with any other column value, then we will have a unique set of values. So, for the combinations of (ManagerID, Name), (ManagerID, TItle), (ManagerID, DepartmentID), (ManagerID, Name, DepartmentID), etc – there will be no two rows in the table that share the exact same combination of values, because the ManagerID will always be unique and different for each row. This means that pairing the Manager ID with any other column(s) will ensure that the ...
1 comment
Read more

Discuss the difference between the ER model and Relational Model?

E-R Model and Relational Model both are the types of Data Model. Data Model describes a way to design database at physical, logical and view level. The main difference between E-R Model and Relational Model is that E-R Model is entityspecific, and Relational Model is table specific. Let us discuss some differences between E-R Model and Relation model with the help of comparison chart shown below.
Post a Comment
Read more