12B Exit Slip 1

What does an ERD (Entity-Relationship Diagram) represent?

• Database queries

• Relationships between entities in a database

• Table formatting in SQL

• The physical structure of a database

Which SQL statement is used to create a new table in SQLite?

• CREATE TABLE

• NEW TABLE

• ADD TABLE

• MAKE TABLE

In an ERD, what symbol represents a many-to-many relationship?

• 1:1

• 1:M

• M:N

• None of the above

Which data type is NOT valid in SQLite?

• INTEGER

• VARCHAR(255)

• BOOLEAN

• DATE

What does the PRIMARY KEY constraint do in SQLite?

• Ensures unique values in a column

• Prevents NULL values

• Links two tables together

• Limits the size of the column

What is the correct syntax to insert a new record into a table called students with columns (id, name, age)?

• INSERT students VALUES (1, 'Alice', 20);

• INSERT INTO students (id, name, age) VALUES (1, 'Alice', 20);

• ADD INTO students VALUES (1, 'Alice', 20);

• INSERT DATA INTO students (id, name, age) VALUES (1, 'Alice', 20);

Which SQL command ensures that a column cannot contain duplicate values?

• NOT NULL

• UNIQUE

• CHECK

• INDEX

What is the purpose of the FOREIGN KEY constraint in SQLite?

• To ensure values in a column are unique

• To prevent NULL values

• To establish a relationship between two tables

• To define a table’s primary key

What is the correct SQL command to define a primary key when creating a table?

• PRIMARY_KEY

• DEFINE PRIMARY

• PRIMARY KEY

• SET PRIMARY