Fillin the Blanks Database 11 | American Baptist College - Edubirdie

University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2024
Views:

369

Pages:

1
Author:

Muthia M.

Fillin the Blanks 1. (FOREIGN) keys are fields that define one-to-one or one-to-many relationships between tables. [Establishing Relationships] 2. One-to-many relationships use( PRIMARY a ) key in one table and a non-primary key in another table. [Establishing Relationships] 3. Entity-relationship diagrams (ERDs) are a way ( VISUALIZE to ) relationships between tables. [Entity Relationship Diagrams] 4. Relationships should be ( DESIGNED) before a database is built. [Entity-Relationship Diagrams] 5. Referential integrity ensures that a primary key value exists ( PRIMARY in a TABLE) before the corresponding foreign key value is allowed. [Referential Integrity] 6. Records in a foreign key table that have no match in a primary key table are called ( ORPHANED) records. [Referential Integrity]

Related Documents

Fillin the Blanks Database 11

Fillin the Blanks Database 11 - Page 1

of 1

Recommended Documents

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

New Documents from this Course

Quiz 2 Python for Data Analyst

Quiz 2 Python for Data Analyst

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Quiz 1 Python for Data Analyst

Quiz 1 Python for Data Analyst

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Python Practice #5

Python Practice #5

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Python Practice #4

Python Practice #4

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Input and Output Operation in Python

Input and Output Operation in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Python Data Operator (Assignment Operators and Comparison Operators)

Python Data Operator (Assignment Operators and Comparison Operators)

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Operations using Data Types and Operators in Python

Operations using Data Types and Operators in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Intersect, Distinct, Alias, Computed Column and Sort

Intersect, Distinct, Alias, Computed Column and Sort

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Data Protection Measures

Data Protection Measures

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Datamart to Looking for the Profit Every Month

Datamart to Looking for the Profit Every Month

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment