Database Design

Question 1

These include tables, columns (fields), data types, keys (primary and foreign), and relationships.

Answer 1

Structures

Question 2

The core unit where data is stored in rows and columns. Each table
represents an entity (e.g., customers, products).

Answer 2

Tables

Question 3

CustomerName, CustomerAge, CustomerHeight are characteristics of entities also referred to as _______.

Answer 3

Attributes/Columns/Fields

Question 4

Establishes a relationship between two tables.

Answer 4

Foreign Key

Question 5

These are the constraints that enforce data integrity and business
logic.

define how data can be created, stored, and manipulated, ensuring that
operations align with organizational policies.

Answer 5

Business Rules

Question 6

Enforced directly within the database through constraints, triggers, and stored
procedures.

Example: A university database enforces that a student cannot register for
more than 21 credits per semester. This can be implemented using a trigger
that checks the total credits during registration.

Answer 6

Database-oriented Business Rules

Question 7

Implemented within the application logic rather than directly in the database.

Example: An e-commerce platform may restrict product returns to within 30
days of purchase. This rule is enforced by the application’s order management
module rather than the database itself.

Answer 7

Application-oriented Business Rules

Question 8

the specifications that the database must fulfill to align with business needs and user expectations. This phase involves gathering and analyzing data requirements from stakeholders to define

Answer 8

Database Requirements

Question 9

These describe what the database should do for users to accomplish their tasks (e.g., storing customer orders, managing employee records).

Answer 9

Functional Requirements

Question 10

These are set of specifications that describe the system’s operation capabilities and constraints

Answer 10

Non-functional Requirements

Question 11

3 Non-Functional Requirements

Hint: PSS

Answer 11

Performance
Scalability
Security

Question 12

Using indexing to optimize query performance. Which of the 3 Non- Funtional Requirements does this consider?

Answer 12

Performance

Question 13

Design the database to accommodate increasing data volume.

Answer 13

Scalability

Question 14

Implement user access control and data encryption.

Answer 14

Security

Question 15

Criteria of a Good Database Design

Answer 15

Ensures data integrity, efficiency, and scalability.

Question 16

Ensures that data remains accurate and consistent across tables and transactions.

Answer 16

Data Integrity and Consistency

Question 17

Eliminates redundancy and improves data integrity by organizing
tables so that each table contains data related to a single entity or concept.

Answer 17

Normalization

Question 18

The database should be designed to handle growth in data volume and
user load.

Answer 18

Scalability

Question 19

refers to the correctness, consistency, and accuracy of data in a database. It
ensures that data remains reliable and valid over its lifecycle.

Answer 19

Data Integrity

Question 20

Ensures that each row in a table is uniquely identifiable.

Answer 20

Entity Integrity

Question 21

Ensures that relationships between tables remain consistent.

Answer 21

Referential Integrity

Question 22

Ensures that the values in a column fall within a specified range, type, or set.

Answer 22

Domain Integrity