The type of data stored in each column is defined by its data type
A well-designed database schema ensures efficient data organization and defines relationships between data.
True
What are the two main components of a table in a relational database?
Rows and columns
In a table named Customers, each row represents a single customer and each column specifies attributes like Name, Email, and Phone.
True
The data type used for storing alphanumeric characters is text
Storing a phone number as a Number data type ensures leading zeros are preserved.
False
What is an example of a one-to-one relationship between tables?
Person and passport
What is a relational database?
Data stored in tables
Relational databases organize data in a structured way.
True
The type of data stored in a column is defined by its data type
A well-designed database schema is crucial for data organization and relationships.
True
An individual record in a table is called a row
In a one-to-one relationship, each row in table A corresponds to exactly one row in table B
What is the purpose of a primary key in a relational database?
Unique identifier for rows
Primary keys are defined within a single table, while foreign keys link data between tables.
True
Order the following normal forms from lowest to highest dependency requirements:
1️⃣ 1NF
2️⃣ 2NF
3️⃣ 3NF
One function of a DBMS is to allow users to manipulate data
What is a relational database?
Stores data in tables
The fundamental building blocks of a relational database are tables
What do rows in a relational database represent?
Individual records
Relational databases organize data in a structured way for efficient storage and retrieval.
True
What is a database schema?
Database structure
Each individual record in a table is referred to as a row
What is a data type in a database?
Data format and size
Which data type is used for storing numeric values in a database?
Number
Order the three main types of relationships between tables in a relational database from simplest to most complex.
1️⃣ One-to-One
2️⃣ One-to-Many
3️⃣ Many-to-Many
A many-to-many relationship occurs when each row in table A can relate to multiple rows in table B, and vice versa, such as a student enrolling in multiple courses
Individual records in a table are called rows
What does a database schema define?
Structure of a database
Order the following relationships from least to most complex:
1️⃣ One-to-One
2️⃣ One-to-Many
3️⃣ Many-to-Many
What are the three key components of a table in a relational database?
Rows, columns, table name
Match the data type with its description:
Text/String ↔️ Stores alphanumeric characters
Number ↔️ Stores numeric values
Date/Time ↔️ Stores date and time information
Boolean ↔️ Stores binary values (true/false)
Why is choosing appropriate data types important in databases?
Ensures efficient storage
Relationships between tables are crucial for ensuring data consistency and integrity.
True
A foreign key in one table references the primary key of another table
What is the primary goal of normalization in databases?