Home
Explore
Exams
Search for anything
Search for anything
Login
Get started
Home
Part 2 of CS347
Studied by 0 people
0.0
(0)
Add a rating
View linked note
Learn
A personalized and smart learning plan
Practice Test
Take a test on your terms and definitions
Spaced Repetition
Scientifically backed study method
Matching Game
How quick can you match all your cards?
Flashcards
Study terms and definitions
1 / 14
There's no tags or description
Looks like no one added any tags here yet for you.
15 Terms
View all (15)
Star these 15
1
Exclusive Subtypes
An entity must belong to only one subtype, represented with disjoint constraints.
New cards
2
Inclusive Subtypes
An entity can belong to multiple subtypes, represented with overlapping constraints.
New cards
3
Discriminator Attribute
Used to determine which subtype an entity belongs to, e.g., 'Person_Type' in a 'Person' table.
New cards
4
Intersection Table
Used to resolve many-to-many relationships by creating two 1:M relationships.
New cards
5
Many-to-Many Relationship
A relationship where multiple entities in one table can relate to multiple entities in another table.
New cards
6
Denormalization
The process of combining normalized tables into a single table for performance optimization.
New cards
7
SQL Trigger
An automated database action executed when a specified event occurs.
New cards
8
View
A virtual table derived from a query that simplifies complex queries and enhances security.
New cards
9
Subquery
A nested query used to retrieve information from one or more tables based on values from another query.
New cards
10
Cardinality
Defines the maximum and minimum number of entities that participate in a relationship.
New cards
11
DDL (Data Definition Language)
Used to define and modify database structures like tables.
New cards
12
DML (Data Manipulation Language)
Used to manipulate data in tables, including INSERT, UPDATE, DELETE operations.
New cards
13
Normalization
The process that eliminates redundant data and reduces update anomalies.
New cards
14
JOIN
Combines rows from two or more tables based on related columns, often used for query optimization.
New cards
15
Bridge Table
Another term for junction tables that facilitate many-to-many relationships in databases.
New cards
Explore top notes
Chapter 11: The Prokaryotes: Domains Bacteria and Archaea
Note
Studied by 18 people
899 days ago
5.0
(1)
Preview
French Exam-Places
Note
Studied by 32 people
794 days ago
5.0
(1)
Preview
Untitled Flashcards Set
Note
Studied by 1 person
28 days ago
5.0
(1)
Preview
Module 14: Amino Acids
Note
Studied by 103 people
856 days ago
5.0
(1)
Preview
Retinitis pigmentosa
Note
Studied by 3 people
761 days ago
5.0
(1)
Preview
Chapter 9: Factor Markets, Market Failure, and the Role of the Government
Note
Studied by 10 people
693 days ago
4.5
(2)
Preview
Chapter 8: Photosynthesis
Note
Studied by 39 people
953 days ago
5.0
(1)
Preview
🪱
3.2 The Nature of Reality: Material or Non-Material?
Note
Studied by 11 people
776 days ago
5.0
(1)
Preview
Explore top flashcards
Spanish 2 Vocabulary 1A
Flashcard (33)
Studied by 3 people
792 days ago
5.0
(1)
Preview
Family - sociology
Flashcard (62)
Studied by 5 people
765 days ago
5.0
(1)
Preview
English Poetry Test
Flashcard (82)
Studied by 10 people
56 days ago
5.0
(1)
Preview
BIOL 1107 Exam 2
Flashcard (40)
Studied by 5 people
171 days ago
5.0
(1)
Preview
ESO 1 - Les parties du corps
Flashcard (20)
Studied by 115 people
507 days ago
5.0
(1)
Preview
LIT Vocab Weeks #9-12
Flashcard (25)
Studied by 12 people
468 days ago
5.0
(1)
Preview
✅Os occipital
Flashcard (25)
Studied by 2 people
661 days ago
5.0
(1)
Preview
Vocab 9B
Flashcard (38)
Studied by 38 people
8 days ago
5.0
(1)
Preview