Information Systems For Business An Experiential Approach 1st Edition By Craig Van – Test Bank

$20.00

Pay And Download

 

Complete Test Bank With Answers

 

 

 

Sample Questions Posted Below

 

 

 

 

 

Chapter 5: Storing and Organizing Information

Test Bank
Multiple Choice
1. In a relational database, a unique identifier is known as a:
a. primary key
b. foreign key
c. DBMS
d. data
e. composite key
2. In a relational database, a field that references a unique identifier in a related table is known as a:
a. primary key
b. foreign key
c. field
d. record
e. composite primary key
3. A ______ or row in a table is a set of fields that all pertain to the same thing.
a. record
b. field
c. column
d. database
e. tuple
4. A ______ or column in a table represents some characteristic of the thing contained within a table.
a. field
b. record
c. row
d. link
e. tuple
5. Which of the following is not a disadvantage of using a spreadsheet over a database?
a. Unnecessary data duplication
b. Difficulty in data retrieval and search
c. Ease of use
d. Poor data integrity
e. Inconsistent data
6. How does a DBMS (Database Management System) typically manage a database?
a. By providing the means for creating, maintaining and using databases.
b. By storing different types of information including text, numbers, documents, images and videos.
c. By evaluating business intelligence for managers.
d. By manipulating data such as reducing inventory when a product is ordered.
e. By hiring a DBA to oversee the data in the system.
7. Stephanie has put together a list of guests as well as the gifts each guest brought to both her wedding shower and wedding. What is the best method for her to store this data?
a. Database
b. Spreadsheet
c. Filing cabinet
d. Document
e. PowerPoint
8. For large and complex amounts of information, storing the information is best achieved by using what?
a. A spreadsheet
b. A database
c. A file
d. A document
e. A smartphone app
9. For the purpose of displaying and analyzing information, a _________ is often the most effective solution.
a. database
b. table
c. spreadsheet
d. PowerPoint presentation
e. piece of paper
10. When working on a small database for your office what would the easiest DBMS choice be?
a. Microsoft Access
b. Oracle
c. MySQL
d. Microsoft SQL Server
e. Tableau
11. What is a disadvantage of unnecessary redundancy?
a. None, all data must be unique.
b. Redundancy can lead to inconsistencies.
c. Redundancy is only permitted within outdated database versions.
d. Inability to delete records.
e. Inability to find records.
12. The key component of a relational database is establishing a relationship or cross referencing tables. How is this task accomplished?
a. Identifying a unique primary key
b. Establishing a foreign key
c. Identifying data redundancy
d. Using one table for the database
e. Creating a composite key
13. When ensuring data consistency by eliminating data redundancy, you are following a set of rules known as what?
a. Application development
b. Software development life cycle
c. Normal form
d. Database management
e. Foreign key creation
14. Netflix has countless copies of the newest movies released, as well as countless members that are willing to rent the newest movie. What type of relationship would this example mostly likely be?
a. One to one
b. One to many
c. One to two
d. Many to many
e. Recursive
15. The town of Mamou has two judges that hear all of the traffic violations from the previous week. Each judge can only preside over one violation at any given time. The database that has been developed has a JUDGE table and a VIOLATION table. What type of relationship exists between these tables?
a. One to one
b. One to many
c. One to two
d. Many to many
e. Recursive
16. Your technology firm has been contacted by a local accounting firm about designing a database to organize clients and workload. The managing partner of the Accounting firm has described the way that the firm handles business and you have decided that the best method to begin your work is to create a diagram called __________.
a. an entity relationship diagram
b. a decision flow chart
c. a gantt chart
d. database architecture
e. an entire relationship diagram
17. Why is the entity relationship diagram (ERD) or database schema necessary, even if you never design or build a database?
a. To understand the structure of the database
b. To identify tables
c. To understand rows
d. To define fields
e. To communicate data fields to end users
18. You have finally decided to open your widget store in your hometown and now have to choose a location for your new business. Which of the following online databases would be the most effective source of information?
a. United States Census Bureau
b. Monster.com
c. Itunes.com
d. Compustat
e. Federal Reserve Economic Data
19. An online database serves a different purpose than a typical relational database. Which of the following best describes the purpose that online databases serve?
a. Points to source of information
b. Does not require a primary key
c. Contains only one table
d. Cannot use a multi-tier architecture
e. Does not need to be stored locally
20. If a table contains the primary keys from two separate but related tables, what would these keys be called?
a. Intersecting keys
b. Foreign keys
c. Composite primary keys
d. Merged keys
e. Borrowed primary keys
21. You are entering your last year of college and are interested in finding information about which particular industry to enter upon graduation. Which of the following online databases would be the most effective source of information?
a. United States Census Bureau
b. United States Bureau of Labor Statistics
c. Itunes.com
d. Compustat
e. Federal Reserve Economic Data
22. You are entering your last year of college and are interested in finding information the companies you have interviews lined up with. Which of the following online databases would be the most effective source of information?
a. United States Census Bureau
b. United States Bureau of Labor Statistics
c. The Business and Company Resource Center
d. Compustat
e. Federal Reserve Economic Data
23. In a new position you were hired into upon graduation, you are asked to gather historic financial information about competitive firms to be used in forecasting future performance. Which of the following online databases would be the most effective source of information?
a. United States Census Bureau
b. United States Bureau of Labor Statistics
c. Itunes.com
d. Compustat
e. Federal Reserve Economic Data
24. Which of the following is least likely to utilize a database?
a. iTunes
b. Windows Media Player
c. Monster.com
d. Facebook.com
e. Home inventory list
25. __________ handle the processing of data in a multi-tiered architecture.
a. Databases
b. Applications
c. The DBMS
d. Managers
e. End-users
26. What are databases good at, as compared to spreadsheets?
a. Finding information
b. Analyzing and displaying information
c. Storing and organizing information
d. Make sense of the information
e. Sharing information with others
27. A table in a database contains information about Employees. The portion of the table that would contain the Employee First Name for all Employees would be known as what?
a. Field
b. Record
c. Row
d. Link
e. Tuple
28. A table in a database contains information about Employees. The portion of the table that would all of the information about one Employee would be known as what?
a. Record
b. Field
c. Column
d. Database
e. Tuple
29. A table in a database contains information about Employees. The EmployeeID uniquely identifies each entry in the table. What is this known as?
a. Primary key
b. Foreign key
c. DBMS
d. Data
e. Composite primary key
30. A table in a database contains information about Employees. The DeptNum repeats itself multiple times in this table but links each employee to another table that contains the information about that particular department. What is DeptNum known as?
a. Primary key
b. Foreign key
c. DBMS
d. Relationship
e. Composite primary key
31. In a relational database, the link between two tables by a primary key and a foreign key is known as what?
a. A partnership
b. A connection
c. A reference
d. A relationship
e. A composite primary key
32. In a relational database, a primary key is sometimes made up of multiple fields. What is this known as?
a. Primary key
b. Foreign key
c. Field
d. Record
e. Composite primary key
33. when a many-to-many relationship is found in a relational database it is necessary to create a new table to link these together to eliminate the many-to-many relationship. What is the newly created table called?
a. An intersection table
b. A joining table
c. A many-to-many table
d. A dummy table
e. A composite table
34. At Joe’s Outdoor Supply Shop, each customer has one account. The customer information and the account information are stored in separate tables. What type of relationship would this example mostly likely be?
a. One to one
b. One to many
c. One to two
d. Many to many
e. Recursive
35. Database tables are made up of what?
a. Headers and footers
b. Relationships and identifiers
c. Primary keys and foreign keys
d. Attributes and characteristics
e. Records and fields
Reflective Short Answer Questions
1. Your local bank is redesigning the relational database that is used to track customers’ personal information. If you were hired to design the database for the bank, what kind of fields would be included in a Customer table and what field would you suggest as the primary key?
A: Fields: AcctNum, Name, Address, PhoneNum, Balance, PK-AcctNum
Rubric: 3 (Proficient)-Including a proper PK and similar fields at or around answer
2 (Adequate)- Including a proper PK, fewer fields or fields that do not belong
1 (Limited)-No PK identified or no PK included, incorrect fields

The following is a table used for a sporting goods store to track the type of shoes that are available for sale. Use this table to answer questions 2-4
ShoeID Brand Type Price Color
1001 Nike Air Max $100.00 Blue
1002 Reebok Instant $55.00 White
1003 Puma Classic $80.00 Brown
2. How many records are included in this table?
A: 3
3. How many fields are included in this table?
A:5
4. Which field is the best choice for the primary key?
A: ShoeID
5. What is an entity relationship diagram? When would an ERD be created and what information would the ERD contain?
A: A visual diagram that provides a view that shows tables, fields, and relationships.
The diagram is a key to understanding the structure of the database, which is useful when retrieving data from a database.
Rubric: 3 (Proficient)-Both correct statements
2 (Adequate)- One correct statement
1 (Limited)-No correct response
6. Consider the Amazon.com learning activity from class, what kind of information would you collect from customers? How would you collect information on orders placed by customers? What are the likely foreign keys?
A: Customer data collection: CustID, Name, Address Order:OrderID, CustID, Item, Price FK-CustID
Rubric: 3 (Proficient)-All correct statements present
2 (Adequate)- Most fields identified, but no FK identified
1 (Limited)-No correct response present

  1. The intramural sports department at your school is creating a database to keep track of the teams, student athletes, and the sports that are played. A team can only play one sport, but can have a number of student athletes. A student athlete can play on more than one team and a sport must have many teams. What relationships exist between these entities?
    A: Student athlete to team- many to many, Team to sport- one to many
    Rubric: 3 (Proficient)-Both relationships correctly identified
    2 (Adequate)- One relationship correctly identified
    1 (Limited)-No relationships correctly identified
    8. A multi-tiered architecture is a very popular solution today.Describe an example of a simple multi-tiered architecture. Clearly identify the differences in the application tier and database tier.
    A: Application tier manipulates data, database tier contains data
    Rubric: 3 (Proficient)-Both descriptions correctly identified
    2 (Adequate)- One description correctly identified
    1 (Limited)-No description correctly identified

There are no reviews yet.

Add a review

Be the first to review “Information Systems For Business An Experiential Approach 1st Edition By Craig Van – Test Bank”

Your email address will not be published. Required fields are marked *

Category:
Updating…
  • No products in the cart.