MIS Module 5

A database is used instead of a spreadsheet when ________.
Click the card to flip 👆
1 / 20
Terms in this set (20)
A database is used instead of a spreadsheet when ________.
lists involve data with multiple themes
Lists that involve data with multiple themes can be stored in a spreadsheet.
false
The purpose of a database is to keep track of lists of data that involve multiple themes.
True
In a data model, a(n) ________ is something that a user wants to track.
entity
Which of the following is the smallest element in a database?
byte
In a database, ________ are grouped into columns.
bytes
The columns in a database are also called ________.
fields
The rows in a database are also called ________.
records
A group of similar rows or records is known as ________.
a table
Which of the following data elements is placed higher than records in the database hierarchy?
file
A primary key in a database is a ________.column or group of columns that identifies a unique row in a tableMaria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.primary keyColumns that are keys to different tables than the ones in which they reside are called ________.foreign keysRelational databases represent relationships using ________.foreign keysMetadata is/are ________.data that describes dataA(n) ________ is a program used to create, process, and administer a database.database management systemWhich of the following is an example of a database management system?AccessIdentify an open source DBMS product.MySQLWhich of the following is true of MySQL?It is license-free for most applications.The modification or deletion of data in a database is an example of ________ operations of a database management system.processing