MIS 2223 Midterm: Test 3 Study Guide Part 2

3 Pages
Unlock Document

East Carolina University
Management Information Systems
MIS 2223
Kevin Fontana

CHAPTER 11 TERMS: • Database: A collection of data organized in a manner that allows access, retrieval, and use of that data. • Database Software: (Database management system DBMS) Allows users to create a computerized database; add, modify, and delete data, sort and retrieve data; create forms and reports from the data. • Data is Organized in Levels: Characters, fields records, and files. • Character: Is one byte. Numbers, letters, space, punctuation marks, or other symbols. • Field: A combination of one or more related characters. Field name, data type, field size. • Record: A group of related fields. • Primary Key: A field that uniquely identifies each record. • Data File: A collection of related records. • File Maintenance: Refers to the procedures that keep data current (Adding records, modifying records, deleting records). • Validation: Compares data with a set of rules or values to find out if the data meets certain criteria. • File Processing: Each department has its own set of files. Redundant data. Isolated data. • Data Model: Defines how users view the organization of the data. • Query Language: Consists of simple, English-like statements that allow users to specify the data to display, print, store, update, or delete. • Structured Query Language: (SQL) A popular query language that allows users to manage, update, and retrieve data. • Form: A window on the screen that provides areas for entering or modifying data in a database. • Report Writer: Allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. • Least Privilege Policy: Requires that in a particular abstraction layer of a computing environment, every module (such as a process, a user, or a program, depending on the subject) must be able to access only the information and resources that are necessary for its legitimate purpose. • Continuous Backup: • Information System: A collection of hardware, software, data, people and procedures that work together to produce information. • System Development: A set of activities used to build an information system. • System Development Life Cycle: (SDLC) When system development activities are grouped into phases. • System Development Phases: 1.) Planning. 2.) Analysis. 3.) Design. 4.) Implementation. 5.) Support and Security. • Guidelines of System Development: Group activ
More Less

Related notes for MIS 2223

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.