Glossary

Question 1

RDBMS

Answer 1

Relational Database Management

Question 2

SQL

Answer 2

Structured Query Language

Question 3

DIKW

Answer 3

Data, Information, Knowledge, Wisdom(pyramid)

Question 4

DBMSs

Answer 4

Database Management Systems

Question 5

Traversal

Answer 5

Process of visiting each node in a data structure and performing some action

Question 6

Primary key

Answer 6

uniquely identifies each row and column or set of columns in the table

Question 7

Foreign key

Answer 7

a set of constraints in DBMS that establish relationships between tables and also ensure consistency and integrity of data

Question 8

Node

Answer 8

an item of data that can be accessed by two or more routes

Question 9

Delimiter

Answer 9

character separating columnar data

Question 10

JSON

Answer 10

JavaScript Object Notation

Question 11

API

Answer 11

Application programming interface

Question 12

Constraint

Answer 12

used to specify rules for the data in a table (primary key, foreign key, check, etc.)

Question 13

Changelog

Answer 13

log or record of all notable changes made to a project

Question 14

Attributes

Answer 14

the data connected with the entity(columns)

Question 15

Entity

Answer 15

real world thing or object (rows)T

Question 16

Tuple

Answer 16

row in a database

Question 17

ERD

Answer 17

Entity relation diagram

Question 18

Data redundancy

Answer 18

Having the same data, but at different places

Question 19

UNF table

Answer 19

Unnormalised form table

Question 20

Determinant

Answer 20

Any attribute that can be used to determine the values assigned to other attribute(s) in the same row.

Question 21

non-prime attribute

Answer 21

Attributes that are not part of any candidate key