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