Relations, tuples, and attributes in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a relation with attributes.

DBMS Theory

CREATE TABLE Students ([1] VARCHAR(50), Age INT);

Drag options to blanks, or click blank then click option'

AName

BTuple

CAttribute

DRelation

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Tuple' or 'Relation' instead of an attribute name.

The code defines a table with an attribute called Name. Attributes are the columns in a relation.

2fill in blank

medium

Complete the code to insert a tuple into the relation.

DBMS Theory

INSERT INTO Students VALUES ('Alice', [1]);

Drag options to blanks, or click blank then click option'

A'Student'

B20

C'Age'

DRelation

Attempts:

3 left

💡 Hint

Common Mistakes

Using attribute names or relation names instead of actual data values.

The code inserts a tuple with values 'Alice' and 20 into the Students relation. Tuples are rows of data.

3fill in blank

hard

Fix the error in the relation definition by completing the blank.

DBMS Theory

CREATE TABLE Employees (ID INT, [1] VARCHAR(100));

Drag options to blanks, or click blank then click option'

AAttribute

BRelation

CTuple

DName

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Tuple' or 'Relation' as attribute names.

The second attribute should be a valid column name like Name. 'Tuple' and 'Relation' are not valid attribute names.

4fill in blank

hard

Fill both blanks to create a tuple with correct attribute values.

DBMS Theory

INSERT INTO Products VALUES ([1], '[2]');

Drag options to blanks, or click blank then click option'

A101

BLaptop

CProduct

DRelation

Attempts:

3 left

💡 Hint

Common Mistakes

Using attribute or relation names instead of actual data values.

The tuple inserted has an ID of 101 and a product name 'Laptop'. These match the attributes of the Products relation.

5fill in blank

hard

Fill all three blanks to define a relation and insert a tuple correctly.

DBMS Theory

CREATE TABLE [1] (ID INT, [2] VARCHAR(50));
INSERT INTO [3] VALUES (1, 'John');

Drag options to blanks, or click blank then click option'

ACustomers

BName

DRelation

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Relation' as a table or attribute name.

The relation is named Customers with attributes ID and Name. The tuple inserted belongs to the Customers table.