Properties of a database management systemQuestion Shall Overcome in mind why we use database system
The answer is there are basically 6 important features of a database-
- Usability and
CompletenessThis 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.
Integrity:Database integrity ensure that data entered into the database is
- Valid and
Accurate- Data Accuracy refers that well you must be right value and must be represented in a consistent manner.
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.