CS 303: Database Management Part 1
Computers represent data in a finite manner. What does this mean?
There is a limit to how much data they can represent.
What purpose does a junction table serve?
To simplify a many-to-many relationship
What kind of data can be stored in a Boolean data type?
True/False
_____ is another word for a database record.
Tuple
How many child records or tables can a parent table have?
Unlimited
In a database, what type of field would you use for the names of customers?
Varchar
How would a grocery chain manage a database containing information on thousands of customers?
With a DBMS
How would a university that needs to have records of student grades store this information ?
With a database table
What is the diagram symbol for a database?
a cylinder
Each column in a database table is also called _____?
a field
A database management system is _____.
a software application that allows the creation and editing of a database while allowing multiple concurrent access of users
Which of these is the best general definition of a database?
a structured collection of data
Data integrity restrictions serve to _____.
control data input formats and ensure data-entry validity
When duplicate versions of the same data appear in different places, _____.
data redundancies have occurred
All of the following can refer to a type of software that is used to store data, except _____.
database
Data redundancy results from _____.
identical data appearing in multiple places in the database
The type of database that stores journals and magazine articles is called a _____.
library database
Which database type is the simplest type and is organized into rows and columns in a text file?
text database
Database security comprises protection of the data within the database from _____.
users accessing restricted areas in the database and from unauthorized external access
How many parent tables can a child record or table have?
1
Where is a multi-user database typically located?
A central computer server
What is a database?
A computer mechanism for storing and retrieving data
Which picture of a storage device is often used as a 'Save' icon in many programs?
A floppy disk
A field in a database table whose values are the same as the primary key of another table is called:
A foreign key
Which of these could use a hierarchical database most efficiently?
A group of students organized by homeroom
_____ is a field in a database table (or a combination of fields) that has a unique value.
A primary key
What rough shape does a hierarchical database take?
A pyramid
A database is comprised of tables, which each have columns and rows. Housed in one specific column and row is one unit of data called:
A record
Ultimately, what is at the 'top' of a hierarchical database?
A single parent table
What best describes the structure of a relational database?
A spider web
What is a query?
A statement that displays or alters data in a database
What does a database model provide?
A systematic way to organize data
Which of the following is NOT true about a database field?
A table can have more than one field with the same name.
Flat-file databases can become _____.
All are correct
Which of the following is a characteristic of data storage devices?
All of the answers are correct.
How do we know that social media probably makes use of relational databases?
All of these answers are correct.
A relationship between two or more tables is also known as:
An association
What is the difference between analog and digital data?
Analog data are continuous, while digital data are discrete.
How many people can, in theory, use a multi-user distributed databases?
Anyone at any site who has been authorized by the database manager
How many tables are in a given hierarchical database?
As many as you need
What are data?
Basic facts or values
What is data?
Basic facts or values
_____ refers to how many records in a table are related to the number of records in another table.
Cardinality
Which of these is NOT an organizational part of a database?
Cell
If you were going to put 'start_date' as a category in a database, where would it go?
Column
In a database, the data in _____ run vertically (down the page) and the data in _____ run horizontally (across the page)
Columns; Rows
Which of the following is an advantage of a hierarchical data model?
Conceptual simplicity
The database administrator has already set permissions for several people to use the system. Three of the users need to be able to use the database at the same time. What function does the administrator need to set?
Concurrency
What type of language is ''delete'' in SQL?
DML or database manipulation language
The following terms all describe a set of records:
Data Set, Table, File
What is the primary advantage of using a distributed database?
Data access and faster processing
What is the difference between data and information?
Data are basic values or facts, while information consists of organized data used to answer question or solve problems.
Which of the following statements is false with respect to distributed databases?
Data at any site is only available to users at that site.
What is the difference between data and information?
Data refer to basic values or facts, while information consists of organized data used to answer questions or solve problems.
What, at its core, does a relational database allow?
Data to be linked to other tables by relationships in the data
What is a collection of databases that work together called?
Data warehouse
A ________ is an organized collection of data.
Database
What does the acronym DBMS stand for?
Database Management System
If you need to store the prices of items sold, what data type would you use?
Decimal
In relational database theory, which term is best associated with normalizing data in a real-world scenario?
Decompose
In the following data set, what would best denote the relationship between Department name and department? DepartmentID DepartmentName 100 Payroll 200 Finance 300 Materials
DepartmentID -> DepartmentName
When normalizing data, what statement describes an accurate step to take?
Each tuple is reliant only on a primary key
Which of these is most like a hierarchical database?
Family tree
Which of the following is NOT a factor in the number of storage devices available?
Features
_____ is an example of a flat-file database tool.
FileMaker
I have a flat-file table with seven records for a customer. Her name changes. How do I update the data?
Fix each record
Which of the following categories is concerned exclusively with electronics-based storage?
Flash
What is TRUE about flash memory?
Flash memory is portable and can retain data without power
Which of the following uses platters and heads?
Hard drives
In the database example shown here, which fields are numeric (numbers only):
ID and Rating
The names of each employee in a database would most likely be stored where?
In rows
Even though tables aren't related in a flat-file database, they should have a(n) _____.
Index
What would a company most likely use a relational database for?
Inventory management
What is an advantage of a database application over a spreadsheet?
It is faster
Why is a relational database useful in government intelligence?
It limits who can see what information.
In a database, what happens to unnecessary data when it is not queried?
It remains on the database, but doesn't show up in the database application.
Each database row must have which of the following?
Key
What device was the first electronic data storage device?
Manchester Mark I Williams-Kilburn tube
A database of auto parts has two tables. The first table includes all the different parts. The second table includes all the different types of vehicles. Some parts can be used in more than one vehicle, while all vehicles consist of more than one part. This describes which type of table association?
Many-to-many
What makes a relational database so effective ?
Multiple tables can be linked together.
Which of the following database models uses parent-child relationships where each child can have multiple parents?
Network database model
Which of the following is a category of dynamic storage?
None of these
Which of the following DBMS models would be used to manage a collection of audio files ?
Object-oriented
Which of these would be a logical use for a hierarchical database?
Organizing books by genre, then author
What is the basic relationship in a hierarchical database?
Parent-child
What are the three fundamental elements of a database management system?
Physical database, database engine and database schema
Which of the following can NOT be repeated in a set of database records?
Primary keys
Some of the first data storage devices were punched cards. How do they work?
Punched cards use the presence or absence of a hole at a specific location on the card to transmit data to a machine or application
Which building most resembles a typical hierarchical database?
Pyramid
Which of the following is NOT a potential advantage of a database management system (DBMS)?
Reduces data storage needs
In the following table, the what best describes the data in the SourceName column? SourceName Description Rate BrokersMQ Southside brokeragefirm. 2553 BrokersMQ Southside brokerage firm. 0035 DealsADay Cheap stuff. 00005
Redundant
What does RDBMS stand for?
Relational Database Management System
The data in a flat file database have no _____ between them.
Relationships
Which of the following is NOT one of the uses of a database application?
Selling products
Which is NOT a typical example of the types of data that can be stored into a database?
Social media posts
There are two types of data storage devices available: _____ and _____.
Static, Dynamic
In the data storage sense, what does 'denormalized' mean?
Storing data in large chunks
What is a database field?
The columns in a database table
What is the main difference between a database and a database application?
The database application contains the collection of information and data, while the database is the software used to organize this data.
