
Database Concepts Flashcards

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

10 questions
Show all answers
1.
FLASHCARD QUESTION
Front
Relational Database
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 Wayground
5 questions
Unit 2: Working with Tables

Flashcard
•
8th Grade
9 questions
Bivariate Data Vocab

Flashcard
•
8th Grade
10 questions
Les adjectifs de couleur

Flashcard
•
6th - 8th Grade
10 questions
Y8 IT/CO2 Database Homework 1 Flashcard

Flashcard
•
7th Grade
10 questions
Access

Flashcard
•
8th Grade
10 questions
🧠Atoms and the periodic table

Flashcard
•
7th Grade
10 questions
Ratio Tables

Flashcard
•
6th Grade
9 questions
Les adjectifs de couleur

Flashcard
•
6th - 8th Grade
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

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

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade