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 18 people
899 days ago
5.0(1)
note Note
studied byStudied by 32 people
794 days ago
5.0(1)
note Note
studied byStudied by 1 person
28 days ago
5.0(1)
note Note
studied byStudied by 103 people
856 days ago
5.0(1)
note Note
studied byStudied by 3 people
761 days ago
5.0(1)
note Note
studied byStudied by 10 people
693 days ago
4.5(2)
note Note
studied byStudied by 39 people
953 days ago
5.0(1)
note Note
studied byStudied by 11 people
776 days ago
5.0(1)

Explore top flashcards

flashcards Flashcard (33)
studied byStudied by 3 people
792 days ago
5.0(1)
flashcards Flashcard (62)
studied byStudied by 5 people
765 days ago
5.0(1)
flashcards Flashcard (82)
studied byStudied by 10 people
56 days ago
5.0(1)
flashcards Flashcard (40)
studied byStudied by 5 people
171 days ago
5.0(1)
flashcards Flashcard (20)
studied byStudied by 115 people
507 days ago
5.0(1)
flashcards Flashcard (25)
studied byStudied by 12 people
468 days ago
5.0(1)
flashcards Flashcard (25)
studied byStudied by 2 people
661 days ago
5.0(1)
flashcards Flashcard (38)
studied byStudied by 38 people
8 days ago
5.0(1)
robot