MIS Exam 2 Questions & Answers
100% CORRECT7
Composite Key - ANSWERS -Two or more primary keys used in a table.
how many foreign keys can you have per table? - ANSWERS -253
Redundancy - ANSWERS -The duplication of data or storing of the same data in more than one
place
Redundancy wastes space and means corrections must be made in multiple places. Leads to
inconsistencies.
Navigation Pane - ANSWERS -the main way you view and access all your database objects and it
displays on the left side of the Access window by default
Database - ANSWERS -- A collection of data organized in a manner that allows access, retrieval
and use of that data.
- Databases record data in a way that lets them produce information.
- Databases are part of most information systems.
- Examples of databases: Amazon, the phone book, iTunes, finance.yahoo.com, UNH Library
online databases.
Database Management Systems (DBMS) - ANSWERS -- DBMS - an application used to interact
with database
- Create and edit a database with a DBMS
- GUI for click & drag interaction instead of coding
- Popular DBMS include:
, -- Microsoft Access (this is what we will use)
-- ORACLE
-- IBM DB2
-- Microsoft SQL Server, MySQL
What 4 objects do we work with in Access - ANSWERS -Forms, reports, queries, and tables
Primary Key - ANSWERS -a field that uniquely identifies a record in a table
a table can only have one primary key
two ways to view a table and what they each show - ANSWERS -1. Datasheet view, lets you see
all the records in the table.
2. Design view lets you edit the field properties and add fields
two ways to view a query and what they each show - ANSWERS -1. Datasheet view lets you see
the records returned when the query is run.
2. Design view lets you design the query
tables - ANSWERS -Used to store data. Every field in a table has a data "type"
Queries - ANSWERS -- Data manipulation; recombine data from different tables into one; filter,
analyze to answer questions
- Answer questions you have about your data.
forms - ANSWERS -- GUI interface for data entry/visualization
- Allow you to easily enter or view data in a database.
- Form shows one record at a time.
100% CORRECT7
Composite Key - ANSWERS -Two or more primary keys used in a table.
how many foreign keys can you have per table? - ANSWERS -253
Redundancy - ANSWERS -The duplication of data or storing of the same data in more than one
place
Redundancy wastes space and means corrections must be made in multiple places. Leads to
inconsistencies.
Navigation Pane - ANSWERS -the main way you view and access all your database objects and it
displays on the left side of the Access window by default
Database - ANSWERS -- A collection of data organized in a manner that allows access, retrieval
and use of that data.
- Databases record data in a way that lets them produce information.
- Databases are part of most information systems.
- Examples of databases: Amazon, the phone book, iTunes, finance.yahoo.com, UNH Library
online databases.
Database Management Systems (DBMS) - ANSWERS -- DBMS - an application used to interact
with database
- Create and edit a database with a DBMS
- GUI for click & drag interaction instead of coding
- Popular DBMS include:
, -- Microsoft Access (this is what we will use)
-- ORACLE
-- IBM DB2
-- Microsoft SQL Server, MySQL
What 4 objects do we work with in Access - ANSWERS -Forms, reports, queries, and tables
Primary Key - ANSWERS -a field that uniquely identifies a record in a table
a table can only have one primary key
two ways to view a table and what they each show - ANSWERS -1. Datasheet view, lets you see
all the records in the table.
2. Design view lets you edit the field properties and add fields
two ways to view a query and what they each show - ANSWERS -1. Datasheet view lets you see
the records returned when the query is run.
2. Design view lets you design the query
tables - ANSWERS -Used to store data. Every field in a table has a data "type"
Queries - ANSWERS -- Data manipulation; recombine data from different tables into one; filter,
analyze to answer questions
- Answer questions you have about your data.
forms - ANSWERS -- GUI interface for data entry/visualization
- Allow you to easily enter or view data in a database.
- Form shows one record at a time.
