Database Design | MCQs

Explanation

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes that uniquely specify a tuple in a relation.

Informally, a primary key is "which attributes identify a record", and in simple cases are simply a single attribute: a unique id.

A field is also known as a column

that stores the same type of data and hence can be called a category of data.

***************

vu FIA CBT PAPER 15-12-2021

Explanation

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Explanation

An Alternate key is any candidate key not chosen as the primary key.

It can still uniquely identify records, but isn't used as the main identifier.

Explanation

The address field contains letters, numbers, and symbols (e.g., "House #42, Street 8").

So, it must be stored as an alpha-numeric data type to handle such mixed content.

Explanation

BCNF is a stronger version of the 3rd Normal Form; it handles certain anomalies that 3NF does not.

It ensures that every determinant is a candidate key, improving data integrity.

Explanation

In databases, semantic description defines what kind of data an attribute should store.

Storing "Physics" as an employee name violates the expected semantic meaning of a name (e.g., "John", "Ali").

Explanation

In database lingo, these columns are called attributes.

A database attribute is a column name and the content of the fields under it in a table.

while 

Each row in a data set (called a tuple)

Explanation

A primary key uniquely identifies each record (row) in a database table.

It ensures data integrity by preventing duplicate and null entries in the key column.

Explanation

A record is complete information about a database.

The database is Consist of many different files linked with each other for the retrieval of information.

Explanation

The Cascade Delete option is a database feature that automatically deletes all related records in a child table when a record is deleted from a parent table.

This helps maintain data consistency and integrity by ensuring that all related data is removed when a primary record is deleted.