https://youtu.be/kV_i1P8pr9M

Properties of a database management system

Question Shall Overcome in mind why we use database system
The answer is there are basically 6 important features of a database-
  • completeness,
  • Integrity,
  • Flexibility,
  • Efficiency,
  • Usability and
  • Redundancyless

Completeness

This property is basically ensure that user can access the data that they want including Ad-Hoc queries.
What is exactly a Ad-Hoc queries: They are those queries which cannot be determined prior to the moment the query is issued.

For example :
  • 1) display bar chart, Pie chart for a vendor and his stocks.
  • 2) showing plot chart and stackbar chart for an employee.
bar Chart

Integrity:

Database integrity ensure that data entered into the database is
  • Accurate
  • Valid and
  • Consistent.

Accurate- Data Accuracy refers that well you must be right value and must be represented in a consistent manner. data accuracy
Valid- it refers that a test should be correct like AGE of a PERSON 200 -> not valid.
Consistent:- The consistent of data consistency of data rapid that if a person changes his phone number it should be changed everywhere in database where his telephone data is saved. Data Consistancy

Flexibility:-

This feature in ability of upgrading and changing the functionality of a database. data flexibilty

02-Properties Of DataBase Part-1-DBMS Tutorials





    CLICK HERE TO Download This PDF NOTES




Facebook Likes

Youtube