Skip to main content

List all the advantage of database and explain any file?

Advantages of Database
As database is required in every field, so it has many advantages, Few of these advantages are as.
  • Minimal Redundancy
  • Privacy and Security
  • Easy Searching
  • Integrity
  • Consistency
  • Simplicity
  • Full Control
  • Data Migration

Sharing Of Data

In DBMS, Data can be shared in between authorized user of database. All the users have their own right to access the database up to a level. Database Administration has complete access of database. He can assign users to access the database. Others users are also authorized to access database and also they can share data between them. Many users have same authority to access the database.

      Data Consistency

DBMS controls data redundancy which in turn controls data consistency. Data consistency means if you want to update data in any files then all the files should not be updated again. As in DBMS, data is stored in a single database so data becomes more consistent in comparison to file processing system. Also updated values are available to all the users immediately.

      Data Integrity

Data integrity means unification of so many files into a single file. In DBMS data is stored in different tables. A database contains different tables that are linked to each other. Many users feed entries in these tables so it is important to maintain data items and association between data items. DBMS allows data integrity that makes it easy to decrease data duplicity Data integration reduces redundancy as well as data inconsistency.

      Search Capability

Users of database may require to fetch data from the database. There are numerous queries users may ask about the data. Search speed of the database must be fast to produce quick results. If users execute any query then it is required that he get fastest results from the database. It is an objective of database to maintain flexible search capability.

      Security

Data security means protecting your precious data from unauthorized access. Data in database should be kept secure and safe to unauthorized modifications. Only authorized users should have the grant to access the database. There is a username set for all the users who access the database with password so that no other guy can access these information. DBMS always keep database tamperproof, secure and theft free.

      Privacy

Privacy means up to what extent a user can access the data. It is predetermined by the DBA that who will access the data and up to what level he will be able to access it. Let say when you make a Facebook page then you have the power to give rights to other users that who will be the promoter, editor and admin.

      Simplicity


Simplicity means to represent the overall logical view of data in a simple and clear manner. DBMS is very simple for its users who use it. All the operations like insert, delete, create and update are very easy to implement.
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