INSY Exam 1 Questions with Complete Solutions 2024/2025

INSY Exam 1 Questions with Complete
Solutions 2024/2025

Structural Dependence - ANSWERSaccess to a file is dependent on its structure



data dependence - ANSWERSdata access changes when data storage characteristics change



one-to-many - ANSWERStake primary key from one, throw to many side



many-to-many - ANSWERSMake new table with both primary keys



one-to-one - ANSWERSone foreign key



Ternary M-to-M General Rule - ANSWERSAt least 2 chicken feet



Ternary One-to-Many - ANSWERSMany gets both primary keys from one side



Ternary M-to-M - ANSWERSwill have foreign key if there is a one side



relvar - ANSWERSVariable that holds a relation



closure - ANSWERSuse of relational algebra on existing tables to produce new relations



"current" - ANSWERSmember/customer



select - ANSWERSlists rows