MIS Assignment: Database and Spreadsheet Analysis - University Name

This assignment focuses on the application of Management Information Systems (MIS) principles, specifically concerning database and spreadsheet concepts. It covers topics such as entity classes, business rules, and data dictionaries, which are fundamental to database design. The assignment also delves into spreadsheet functionalities, including lists, columns, rows, and cells, and how they can be used to organize and analyze data. The questions address how these components interact, providing insights into data management, and the creation of pivot tables for data summarization. The assignment aims to reinforce understanding of data structures and information management techniques within a business context.

Running head: MANAGEMENT INFORMATION SYSTEM
Management information system
Name of the student:
Name of the university:
Author note:

1MANAGEMENT INFORMATION SYSTEM
1. Entity class are statements concerning the information you need to work with and the
relationships within the information.
2. Why would you define business rules for a database?
Answer: To ensure that information is entered into the database correctly
3. An organization wishes to store information about its employees in a database. The
employees, in this case, constitute a data dictionary.
4. What is the first step in designing and building a database?
Answer: Defining entity classes and primary keys
5. Which of the following is true about an entity class?
Answer: It represent a group of information that is separate from every other information
in the database.
6. What is the intersection of a row and column in a spreadsheet called?
Answer: Cell
7. Which spreadsheet term defines a collection of information arranged in columns and
rows?
Answer: List
8. Which of the following is a characteristic that a list must possess?
Answer: the list may not contain any blank columns
9. Which of the following is true of lists?
Answer: A list must not have a blank row unless it has verbal information
10. In a list made using spreadsheet software, which of the following would be a label?
Answer: an entry made in the first row of the third column
11. The administration department of a university makes a list of the professors currently
employed by the university (first column), the departments to which they belong (second

2MANAGEMENT INFORMATION SYSTEM
column), and their ages (last column). Which of the following entries would most likely
be contained in the fourth row of the third column?
Answer: Dr. Ridley Donovan
12. A company makes a list of its customers using spreadsheet software. It has four columns
containing information on customer id (4-Digit), customer name, date of most recent
purchase, and address respectively. Which of the following represents information stored
in the third column of the list?
Answer: 7714, Wendy Dickens, 12/12/27, #17 downing street, sacramento, CA
13. Should a spreadsheet list contain any blank rows?
Answer: yes between group of records
14. A pivot table is a description of a list by column.
15. A list definition table:
Answer: describes a list by column