DBMS Flashcards
What is database?
Database is the organized collection of data, which can be easily managed and accessed.
Define DBMS
DBMS are the collection of programs used for creating and managing databases.
Types of database
- Relational database
- Hierarchical database
3.Network database
advantages of dbms
- No redundant data (duplicate data)
- Data integrity and consistency
- High data security
Define RDBMS
A relational database management system is a database management system that stores data in multiple tables and links each other to share, retrieve, and organize.
Advantages of rdbms
- Reduced data redundancy and inconsistency
- Data integrity and high security
Define MS access
MS access is the RDBMS developed by Microsoft used to create, organize, store, and manage data in database.
Advantages of Ms access
- It can import data from multiple sources.
- It supports many high level language that works on windows os
extension of ms access
.accdb
Objects of Ms access database
- Table
- Query
- Form
- Report
Elements of table
- Field
- Row
- Column
- Record
Define field in database
Field in database is heading under which similar information are stored.
Define record
Record is the collection of related data that are treated as single unit of information.
Define column
Column is that field that is managed vertically.
Define rows
Row is the record that is managed horizontally
Define query
Query is the request for data and information
Define form
Form is the object of database which allows entering data, display and update data in customized format.
Define report
Report is the object of database which displays the data in manageable format for printing.
Define data integrity
Data integrity is the accuracy, completeness, and quality of data and its maintenance over time.
Define data consistency
Data consistency is the accuracy, completeness and correctness of data stored in database
What does data redundancy mean?
Data redundancy mean the repetition of same data in multiple place within database.
application fields
- Business field
- School and office.
- Banking and finance
features of rdbms
- Reduced data redundancy and inconsistency
- Data integrity and enhanced sercurity
- Data stored in tabular structure enhance the representation of data
difference between data redundancy and data inconsistency.
data redundancy refers to repetition of data in database and it leads to increased storage requirements.
Data inconsistency refers to the different values of same data in a database. and it leads to incorrect or inaccurate query results.
define primary key
Primary key is a special field, or combination of field, that uniquely identifies each record.
two importance of primary key
- It prevents duplication of data.
- It creates referential integrity constraints to establish relation between tables.
