Introduction to Database Modelling Concepts

Information Technology

An overview of database fundamentals, covering data types, entity-relationship modelling, schema design, normalization, and performance optimization techniques like hashing and indexing.

Databases Data Modelling Software Engineering

15 Questions Medium Ages 18+ Apr 8, 2026

Practice Test PDF Answer Key PDF

Choose a Study Format

Quiz

Test your knowledge with multiple-choice questions and instant feedback.

Flashcards

Flip through cards to review terms, definitions and key concepts.

True or False

Quickly decide if statements are true or false to reinforce understanding.

Match Game

Race against time to match questions with their correct answers.

Study Guide

Read through all topics and answers as a comprehensive study reference.

Listen Mode

Listen to questions and answers read aloud — great for audio learners on the go.

Embed This Study Set

Add this interactive study set to your website or blog — all 6 formats included.

<div data-quixly-id="1393"></div>
<script src="https://www.quixlylearn.com/assets/embed/widget.js"></script>

Learn more about embedding →

About this Study Set

This study set covers Information Technology through 15 practice questions. An overview of database fundamentals, covering data types, entity-relationship modelling, schema design, normalization, and performance optimization techniques like hashing and indexing. Every question includes the correct answer so you can learn as you go — pick any format above to get started.

Questions & Answers

Browse all 15 questions from the Introduction to Database Modelling Concepts study set below. Each question shows the correct answer — select a study format above to practice interactively.

1 What is considered raw data without context?

A A processed report
B 1, John, 25, USA
C A structured table
D A database schema

2 Which of the following is a characteristic of good data?

A Subjectivity
B Redundancy
C Accuracy
D Complexity

3 What does a database schema define?

A The hardware specifications
B The structure and organization of data
C The user password policy
D The network speed

4 Which diagram is used to represent entities and their relationships graphically?

A Flowchart
B ER Diagram
C Venn Diagram
D Pie Chart

5 What is a primary key in a database?

A A non-unique attribute
B A foreign link to another table
C A unique identifier for an entity
D A type of database index

6 Which of the following is an example of an M:M relationship?

A One student to one ID
B One employee to one department
C Many students to many courses
D One customer to one order

7 What is the primary goal of database normalization?

A To increase data storage
B To reduce redundancy and anomalies
C To change data types
D To delete all data

8 Which anomaly occurs when adding new data leads to issues due to missing values?

A Insertion Anomaly
B Update Anomaly
C Deletion Anomaly
D Retrieval Anomaly

9 What is the purpose of hashing in databases?

A To encrypt user passwords
B To improve data retrieval efficiency
C To create new tables
D To delete duplicates

10 Which type of index is built on the primary key of a table?

A Secondary Index
B Multilevel Index
C Primary Index
D Heap Index

11 Which database type stores data in a non-tabular form?

A Relational
B NoSQL
C SQL
D Schema-based

12 What does the CRUD acronym stand for in DBMS operations?

A Create, Read, Update, Delete
B Calculate, Report, Understand, Distribute
C Compile, Run, Undo, Debug
D Construct, Retrieve, Use, Delete

13 What is a collection of similar entities called?

A Entity Set
B Schema
C Hash
D Index

14 Which normal form requires the elimination of transitive dependencies?

A 1NF
B 2NF
C 3NF
D BCNF

15 What is the function of a foreign key?

A To uniquely identify a row
B To link entities together
C To sort the database
D To store image data

📱

Study on the go

Download Quixly and access all study formats on your phone — anywhere, anytime.