0
Integrity is related to trust in terms of the data. We need to be sure that the data is being retrieved accurately. Particularly when there are multiple tables that are linked to each other, we need to be sure we can trust those links so that data can be selected from linked databases. This is all about database integrity.
Database security is making sure the database is safe. Different people may have different levels of access and some people should have no access at all. Things like passwords and other security measures will do this. Some users may be allowed to see data, but not change it. Some users may only be able to see some data that is relevant to what they need to do, but not have access to other data. So for example, in a company only the people that work in the wages department will have access to that data and the ability to change it. People in other department would not be able to do that. That is all part of database security.
What else can I help you with?
WHAT TASKS does dbms do?
A Database Management System or DBMS provides the interface between users and a database. Some of its tasks include: data integrity, security, recovery of data, support concurrent updates and update data.
What is the difference between a programming language and a database?
Programming language is to develop an application where a database is a place at which we can store the data about any objects and a software which maintains this database is called DBMS.
What is the difference between share-level and user-level security?
Share-level and User-level security is actually in the category of computers. In share-Level security systems, passwords are associated with specific objects, not with users. ex. Windows XP User-Level security is the most flexible and secure method of protecting the sensitive data, code, and design of objects in an Access database. User-Level security is for if you need more control. ex. To prevent users from modifying the design of your tables and queries.
What are the responsibilities of the DBA and the database designers?
This position takes the business requirements and models a database based on the business's needs. Does the database need to be in real-time? What kind of data will it hold? Sensitive? There's hundreds of factors that determine how the database is designed, updated, protected. Each business is different.
Contrast of database and database system?
A database is simply a collection of pieces of information (data). A text file storing names and phone numbers is a database. A database management system (DBMS) is some software that manages the data within the database such as MySQL. Both the software and the database are considered together when thinking of a DBMS.
WHAT TASKS does dbms do?
A Database Management System or DBMS provides the interface between users and a database. Some of its tasks include: data integrity, security, recovery of data, support concurrent updates and update data.
What is Difference between real time database and simple database?
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
Why database integrity?
Database integrity refers to the safety of data. For example a transaction is made from an account of rs 500 and in between of transaction there is an abrupt , then integrity of data will be maintained and transaction will not occur.
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
What is the difference between dignity and integrity?
nothing
Is there any difference between integrity and correctness of data in DBMS?
Integrity refers to the structure of the data and how it matches the schema of the database. Correctness could refer to either the integrity of the data or its accuracy (for example, a phone number being incorrect).
What happens if referential integrity is not enforced?
Without referential integrity enforcement, data inconsistencies may arise, such as orphaned records or invalid references between tables. This can lead to data corruption, incorrect query results, and difficulty maintaining and updating the database. Overall, without referential integrity, the data integrity and reliability of the database can be compromised.
What are difference between cache database and sql database?
CACHE is multidimensional and postconsonantal database and its supporting scripting
What is the difference between database management and documents management systems?
differences between document management and database technology
What is the difference between a database management system and a database?
DBMS: Set of software applications combined w/ a database
What is the difference between flat-file model and database model?
The flat-file model stores data in a single table or file without any relationships between tables. In contrast, the database model organizes data into multiple interrelated tables with defined relationships, providing more flexibility, security, and scalability. Databases also offer features like data integrity enforcement, concurrency control, and support for complex queries.
What is the Difference between manual database and electronic database?
A manual database is MANUAL and an electronic is electronic LOL! Simple :P
