4.10.2 Relational Databases
Studied by 1 person
Learn
Practice Test
Spaced Repetition
Match
Flashcards1/8
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
9 Terms
What are the degrees of database relationships?
- One-to-one
- Many-to-many
- One-to-many
What are entity relationship diagrams?
Diagrams to graphically represent relationships between tables in a database
What is the symbol for a one-to-one relationship?
What is the symbol for a one-to-many relationship?
What is the symbol for a many-to-many relationship?
What is a primary key?
An attribute that provides a unique identifier for every entity in a database table
What is a foreign key?
An attribute which is the primary key in another related tableW
What is a composite primary key?
A primary key made up of multiple attributes
How are many-to-many relationships linked?
A new link table is created to model the relationship
Note 
Flashcards (30)