Part 2 of CS347

studied byStudied by 0 people
0.0(0)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions

1 / 14

encourage image

There's no tags or description

Looks like no one added any tags here yet for you.

15 Terms

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

note Note
studied byStudied by 17 people
312 days ago
5.0(1)
note Note
studied byStudied by 38 people
379 days ago
5.0(1)
note Note
studied byStudied by 21 people
759 days ago
5.0(1)
note Note
studied byStudied by 56 people
798 days ago
5.0(4)
note Note
studied byStudied by 411 people
345 days ago
5.0(2)
note Note
studied byStudied by 20 people
898 days ago
5.0(1)
note Note
studied byStudied by 14 people
899 days ago
5.0(1)

Explore top flashcards

flashcards Flashcard (147)
studied byStudied by 56 people
850 days ago
5.0(1)
flashcards Flashcard (31)
studied byStudied by 16 people
87 days ago
5.0(1)
flashcards Flashcard (90)
studied byStudied by 26 people
422 days ago
5.0(2)
flashcards Flashcard (46)
studied byStudied by 5 people
395 days ago
5.0(1)
flashcards Flashcard (297)
studied byStudied by 602 people
832 days ago
5.0(2)
flashcards Flashcard (26)
studied byStudied by 3 people
815 days ago
5.0(1)
flashcards Flashcard (42)
studied byStudied by 11 people
548 days ago
5.0(1)
flashcards Flashcard (38)
studied byStudied by 7 people
638 days ago
5.0(1)
robot