Part 1 of CS437

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 / 20

encourage image

There's no tags or description

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

21 Terms

1
Numeric Data Types

Int, Decimal, Bit, and Float

New cards
2
String (Character) Data Types

Char, Varchar

New cards
3
Date and Time Data Types

DATE, TIME, DATETIME

New cards
4
Database Management System (DBMS)
Software that manages and controls access to databases.
New cards
5
Functions of a DBMS
Creating databases, modifying data, reading data, enforcing constraints, controlling concurrency, performing backup and recovery.
New cards
6
Inner Join
Returns only rows with matching values from both tables.
New cards
7
Outer Join
Returns all rows from one table and matching rows from another table.
New cards
8
LEFT JOIN
Includes all rows from the left table and matches from the right.
New cards
9
RIGHT JOIN
Includes all rows from the right table and matches from the left.
New cards
10
FULL JOIN
Includes all rows from both tables; MySQL does not support this natively.
New cards
11
First Normal Form (1NF)
Ensures each column contains atomic values and each row is unique.
New cards
12
Second Normal Form (2NF)
Ensures no partial dependencies on non-key attributes.
New cards
13
Third Normal Form (3NF)
Ensures no transitive dependencies between attributes.
New cards
14
Boyce-Codd Normal Form (BCNF)
Stronger than 3NF; every determinant is a candidate key.
New cards
15
Fourth Normal Form (4NF)
Addresses multivalued dependencies to minimize redundancy.
New cards
16
Fifth Normal Form (5NF)
Further reduces redundancy in relational databases.
New cards
17
Domain Integrity Constraint
Defines valid values for a column (e.g., Age should be a positive integer).
New cards
18
Referential Integrity Constraint
Ensures foreign key values reference valid primary key values.
New cards
19
NULL values in foreign keys
Allowed if relationships are optional to prevent orphan records.
New cards
20
Data Integrity Impact
Prevents orphan records and ensures relational consistency.
New cards
21

Column Data Types

Numeric, String, Date and Time, Boolean

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