Intro Flashcards
What is database
Is a collection of related data
Types of database language
Data definition language- (DDL)
Data manipulation language(DML)
Data control language (DCL)
Define DDL
Is a database language that describes data structures and data in a database.
Define DML
Is a database language that consists of commands that operate on the data within the database.
The SQL is composed of which DML statements
Select
Update
Insert
Delete
Define DCL
Refers to SQL commands used for data security
Database models definition
Is a format of a database.
Examples of database models
- Hierarchical model
- Network model
- Relational model
- Object model
- Semi-structured model
Explain hierarchical model
Organizes data in a tree structure
Xplain Network model
Is a database model that allows multiple records to be linked to the same owner file
Explain DBMS
A software package that facilitates the creation and maintenance of computerized database.
Importances of DBMS
- To give access to data in a simple way
- To authorize an access of information to multiple users
- To handle data present in a database.
Features of DBMS
—Data Security: Prevents unauthorized users from viewing or updating the database
- Data integrity
- Data independence
- Interactive query
RDBMS in full
Relational database management system
RDBMS meaning
Is a form of DBMS that stores data in form of related tables
