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

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Show more

New Documents from this Course

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Show more