Bus 188 CH 4 Keywords ractice Exam
Questions and Answers Solved 100%
Correct!!
1. field - Answer: ✅- vertical part of a table that holds data for one attribute
of an entity in a database or spreadsheet
- automobiles will have columns for make, model and color
2. foreign key - Answer: ✅- contains value that corresponds to values in the
primary key of another table
EX: orders table which each order has a customer ID number that
corresponds to a record in a customer's table
3. table relationships - Answer: ✅- one to one, one to many, many to many
4. Referential Integrity - Answer: ✅- a property of data stating that all of its
references are valid
- in relational database context, it requires that if a value of one
attribute (column) of a relation (table) references a value of another
attribute, then the references value must exists
5. Schema - Answer: ✅- structure described in a formal language supported
by the database management system (DBMSO)
- refers to the organization of data as a blueprint of how the
database is constructed
6. SQL - Answer: ✅- languages used to ask questions on the database
7. SQL Join - Answer: ✅- combines columns from on more tables in a
relational database
