Relational Data Model Quiz

What is a Relational Data Model?

• A way of organizing data into tables

• A method for storing data in files

• A technique for data visualization

• A programming language for databases

What does a tuple represent in a table?

• A single record

• A column in the table

• A unique identifier

• A set of valid values

What is a primary key?

• A unique identifier for each record

• An attribute that links to another table

• A property of an entity

• A type of constraint

What does a foreign key do?

• Links to the primary key in another table

• Ensures uniqueness in a table

• Represents missing data

• Defines the structure of a table

What is the purpose of domain constraints?

• To restrict value range or format

• To ensure uniqueness

• To prevent NULL values

• To link tables

What is an example of a domain constraint?

• Age must be between 18 and 60

• Student_ID must be unique

• No primary key can be NULL

• Foreign key must match existing primary key

What does entity integrity ensure?

• No primary key attribute can have a NULL value

• Each table must have a unique key

• Values must follow a specific format

• Foreign keys must match primary keys

What is a referential integrity constraint?

• Ensures foreign key values match primary key values

• Restricts the range of values for an attribute

• Ensures uniqueness of a column

• Prevents NULL values in primary keys

What SQL command is used to create a table?

• CREATE TABLE

• INSERT INTO

• UPDATE

• DELETE

What happens if a foreign key value does not exist in the referenced table?

• It creates an orphan record

• It is automatically deleted

• It is allowed without any issues

• It generates an error