Question

Give the terms for each of the following:
a) Collection of logically related records.
b) DBMS creates a file that contains description about the
data stored in the database.
c) Attribute that can uniquely identify the tuples in a
relation.
d) Special value that is stored when actual data value is
unknown for an attribute.
e) An attribute which can uniquely identify tuples of the
table but is not defined as primary key of the table.
f) Software that is used to create, manipulate and maintain
a relational database.​

Answer 1

Answer:

a) Database

b) Meta Data

c) Primary Key or Super Key

d) NULL

e) Alternate Key

f) Database management system(DBMS)

Explanation:

Answer 2

Given below are the terms used for the following.

Explanation:

1. Relational Database: a relational database is a type of database that consists of a number of tables that can relate to each other.
2. Meta-database: Meta-database is a database model for meta-data. Meta-data is the data that store information about other data.
3. Primary or Unique Key: both of these keys are used to identify uniqueness in a row but a primary key cannot take a NULL value whereas unique can.
4. NULL: Whenever an attribute is not given a data value the default value of 'NULL' is stored in the said attribute.
5. Unique Key: As mentioned above unique can also identify uniqueness but it's not a primary key as it can take a 'NULL' value for a column and prevents duplication of data in the column.
6. RDBMS(Relational Data-Base Management System).