Module 3 - Relational Database Components

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/5

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 12:07 PM on 4/9/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai

No analytics yet

Send a link to your students to track their progress

6 Terms

1
New cards

Tables

primary unit of storage in a relational model, representing collection of related data values

2
New cards

Columns

is the smallest named unit of data that can be referenced in a relational database

3
New cards

Data Types

is a category for the format of a particular column

4
New cards

Constraints

rule placed on a database object that restricts the allowable data values for that database object in some way

5
New cards

Integrity Constraints

a constraint promoting accuracy of a data within a database

  • NOT NULL constraints'

  • CHECK constraints

  • Constraints Enforced with Triggers

6
New cards

Views

a stored database query that provides a database user with a customized subset of the data from one or more tables in the database