Relational Database

Database Concepts Flashcards

Flashcard
•
Computers
•
7th Grade
•
Hard
Пламен Георгиев
FREE Resource
Student preview

10 questions
Show all answers
1.
FLASHCARD QUESTION
Front
Back
A type of database that stores and organizes data in tables (relations) with rows and columns, and establishes relationships between tables.
2.
FLASHCARD QUESTION
Front
Table
Back
A collection of related data organized in rows (records) and columns (fields). Each table represents an entity, such as Customers or Orders.
3.
FLASHCARD QUESTION
Front
Primary Key
Back
A unique identifier for each record in a table. It ensures no two rows have the same value for the primary key column(s). Example: CustomerID in a Customers table.
4.
FLASHCARD QUESTION
Front
Foreign Key
Back
A column or set of columns in a table that refers to the primary key of another table. It establishes a relationship between two tables. Example: CustomerID in an Orders table.
5.
FLASHCARD QUESTION
Front
SQL (Structured Query Language)
Back
A standard language used to communicate with and manipulate relational databases. It includes commands like SELECT, INSERT, UPDATE, and DELETE.
6.
FLASHCARD QUESTION
Front
Index
Back
A database object that improves the speed of data retrieval operations on a table. It works like an index in a book, allowing faster lookup of rows.
7.
FLASHCARD QUESTION
Front
Normalization
Back
The process of organizing data in a database to reduce redundancy and improve data integrity. It involves dividing tables and defining relationships between them.
Create a free account and access millions of resources
Similar Resources on Quizizz
5 questions
E-Banking

Flashcard
•
6th - 7th Grade
10 questions
std7

Flashcard
•
7th Grade
10 questions
Ratio Tables

Flashcard
•
7th Grade
10 questions
Math Multiplication Word Problems

Flashcard
•
6th Grade
10 questions
Constant of Proportionality

Flashcard
•
7th Grade
9 questions
Graphing Vocab & Parts

Flashcard
•
7th Grade
10 questions
English K1 singular and plural nouns

Flashcard
•
KG
10 questions
Ratio Tables

Flashcard
•
6th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Computers
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
6 questions
Earth's energy budget and the greenhouse effect

Lesson
•
6th - 8th Grade
36 questions
SEA 7th Grade Week 3 Review FINAL 2025

Quiz
•
7th Grade
20 questions
Multiplying and Dividing Integers

Quiz
•
7th Grade
15 questions
Fast food

Quiz
•
7th Grade
10 questions
Area and Circumference of a Circle

Quiz
•
7th Grade