Some Keywords and Definitions in DBMS

Useful keywords and definitions in DBMS / Two Mark definitions in DBMS / Need to know definitions in DBMS

 

• 1NF (First Normal Form)

• 2NF (Second Normal Form)

• 3NF (Third Normal Form)

A

• Access time

• ACID

• Arity

• Atomic Attribute

• Atomicity (ACID property)

• Attribute

• Attribute Domain

B

• Buffer Cache

• Buffer manager

C

• Candidate key

• Cardinality (in SQL)

• Cardinality Ratios

• Cascadeless schedule

• Composite Attribute

• Conceptual Schema

• Consistency (ACID property) 

• Correlated sub-query

 D

• Data Abstraction

• Database Languages

• Data Control Language (DCL)

• Data Definition Language (DDL)

• Data Dictionary

• Data Manipulation Language (DML)

• Data Redundancy

• Data Transfer Rate

• DBA Functions

• Degree of a relation (table)

• Degree of a relationship

• Derived Attribute

• Descriptive Attribute

• Durability (ACID property)

E

• Entity Set

• Entity integrity

 F

• Foreign Key

• Functional Dependency

• Functions of Database Administrator

• Full Functional Dependency

G

H

I

• Instance

• Isolation (ACID property)

J

K

L

• Logical Data Independence

• Logical Schema

• Lost Update problem (concurrency control)

M

• Many-to-Many Relationship

• Many-to-One Relationship

• Mapping Cardinality

• Multi-Valued Attribute

N

• Non-Prime Attribute (Non-Key attribute)

• Normalization

O

• One-to-Many Relationship

• One-to-One Relationship

P

• Partial Functional Dependency

• Partial Participation

• Participation

• Physical Data Independence

• Physical Schema

• Primary Key

• Prime Attribute

Q

R

• Recoverable schedule

• Referential integrity

• Rotational latency

S

• Schema

• Seek time

• Selectivity

• Simple Attribute

• Single-Valued Attribute

• Strong Entity Set

• Super Key

T

• Total Participation

• Trivial Functional Dependency

• Type of relationship

U

V

W

• Weak Entity Set

X

Y

Z

*********

Go to Database Management Systems home

important keywords in RDBMS

define concepts in database management systems

two mark questions in RDBMS

database management systems glossary

Encyclopedia  of relational database management systems