RDBMS Basics Practice Test: Relational Database Design — Flashcards

Quiz questions on relational design features, functional dependency theory and decomposition, decomposition algorithms and normal forms.

Relational database design (RDD) is the process of modeling data into tables with rows and columns, with each row representing a record and each column representing an attribute. The three stages of database design are conceptual, logical, and physical. 

Here are some key terms related to RDD:
Attribute: The primary storage unit in a database
Column: Represents an attribute of data
Row: Represents a record
Relation: Also known as a table or file
Primary key: A unique identifier of a row
Foreign key: A reference to a primary key of another existing table 

Normalization is the process of organizing data in a database. It involves creating tables and establishing relationships between those tables to protect the data and make the database more flexible. For example, a relational database might have a Customer table and an Order table. The Customer table might contain data about the customer, such as their Customer ID, name, billing address, and shipping address. The primary key of the Customer table is its Customer ID, and each row in the table can use a foreign key to create a relationship between the Customer table and the Order table.
 

Related test: RDBMS Basics Practice Test: Database Design and the ER Model