In the relational model, relationships between relations or tables are created by using:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
Answer: Option D
Solution (By Examveda Team)
Option1: Composite keys are keys that consist of multiple attributes that together uniquely identify a record in a table. They are used to create relationships between tables by linking the values of these attributes in different tables.Option2: Determinants are attributes in a relation that uniquely determine the values of other attributes. They are used to establish functional dependencies and help in the normalization process.
Option3: Candidate keys are a set of attributes that can uniquely identify a tuple in a relation. They are used to create relationships between tables by ensuring data integrity and uniqueness.
Option4: Foreign keys are attributes in a table that refer to the primary key of another table. They are used to establish relationships between tables and enforce referential integrity.
In the relational model, relationships between relations or tables are created by using foreign keys. Foreign keys establish a connection between tables by referencing the primary key of another table, ensuring data integrity and enforcing referential constraints.
Flat file databases are generally in plain-text form, where each line holds only one record. True or False?