Database Systems – Chapter 1

Front

What are the main components of a Database System?

Back

Hardware, Software, Data, Users, Procedures.

Front

What does a table in a database represent?

Back

A table stores data in rows (records) and columns (fields) and represents one entity (e.g., Students, Products).

Front

What is a Primary Key?

Back

A Primary Key uniquely identifies each record in a table.

Front

What is a Foreign Key?

Back

A Foreign Key refers to a primary key in another table to create relationships.

Front

What are the four system databases in a DBMS?

Back

Master, Model, MSDB, TempDB.

Front

What are the main functions of a DBMS?

Back

Data storage, retrieval, updates, security, access control, backup, recovery, data integrity, consistency, and multi-user transaction management.

Front

What are the types of DBMS?

Back

Hierarchical DBMS, Network DBMS, Relational DBMS (RDBMS), Object-oriented DBMS (OODBMS).

Front

How does a DBMS differ from a file system in data management?

Back

DBMS has lower data redundancy, stronger security, enforces data integrity, and supports multi-user access compared to file systems.

Front

What are the key considerations for planning a well-designed database?

Back

Follow normalization rules (1NF, 2NF, 3NF), use unique primary keys, establish relationships with foreign keys, avoid redundant data, and ensure consistency.

Front

What are indicators of a poorly designed database?

Back

Excessive data redundancy, many NULL values, no clear primary keys, inconsistent relationships, and hard-to-maintain structure.