
S4: ERD AND SQL

Quiz
•
Computers
•
11th Grade
•
Easy

Kieran Kyle
Used 2+ times
FREE Resource
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an Entity Relationship Diagram (ERD)
A diagram showing the layout of a database
A drawing that shows how entities in a database are connected
A chart showing the processing speed of a database
A graph of user access to a database
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a database what is an entity?
A command to retrieve data
A specific type of attribute
An individual item or object
A type of database software
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are attributes in a datase?
Rules for how data is stored
The relationships between entities
Properties or characteristics of an entity
Diagrams that represent database structure
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does a one to many relationship in a database represent?
One entity is related to many attributes
One entity is connected to many other entities
Each entity can have only one attribute
Each entity can be part of only one database
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of an SQL SELECT statement?
To modify data in a database
To create a new table in a database
To retrieve data from a database
To delete data from a database
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In an ERD, what symbol typically represents a one to many relationship?
A single line connecting two entities
A crow's foot symbol next to one of the entities
A circle connecting two entities
A square symbol near one of the entities
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these is an example of an entity in a school database?
A students name
A grade in a test
The Student table
The relationship between students and classes
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
QUIZ 3 - MySQL (Database, table, select, update)

Quiz
•
9th - 12th Grade
15 questions
Learning SQL

Quiz
•
11th - 12th Grade
15 questions
DATABASE SERVER

Quiz
•
11th Grade
15 questions
Introduction to MySQL

Quiz
•
11th - 12th Grade
10 questions
Database - ERM - A Level AQA

Quiz
•
11th Grade - University
15 questions
Databases

Quiz
•
10th Grade - University
10 questions
PRETEST BASIS DATA KELAS 11

Quiz
•
11th Grade
15 questions
A-Level Comp Sci 9618 Databases

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade