Bus 188 CH 4 Keywords ractice Exam Questions and Answers Solved 100% Correct!!, Exams of Computer Science

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

Typology: Exams

2024/2025

Available from 02/11/2025

Martin-Ray-1
Martin-Ray-1 🇺🇸

4.7

(12)

9.8K documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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
pf3

Partial preview of the text

Download Bus 188 CH 4 Keywords ractice Exam Questions and Answers Solved 100% Correct!! and more Exams Computer Science in PDF only on Docsity!

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
  • creates a set that can be saved as a table or used as it is
  1. Structured Query Langauge - Answer: ✅- used in programming and designed for managing data held in a relational database management system (RDBMS)
  2. normalization - Answer: ✅- process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity
  • everything else should NOT be redundancy BUT the foreign key

10.database administrator (DBAs) - Answer: ✅- use specialized software to store and organize data

  • role may include capacity planning, installation, configuration, database design, migration, performance, monitoring, security, troubleshooting, as well as backup and data recovery

11.NoSQL - Answer: ✅- mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases

12.database management system - Answer: ✅- software that handles the storage, retrieval, and updating of data in a computer system

13.Data independence - Answer: ✅- change programs without altering data

14.data integrity - Answer: ✅- keeping data accurate and correct as it is gathered and stored in the computer system