DATABASES
FILE PROCESSING SYSTEMS
SYSTEM DEVELOPMENT
APP DEVELOPMENT, LANGUAGE & TOOLS
TECH FACTS
100
A Database
What is a collection of data organized in a manner that allows access, retrieval, and use of that data?
100
System used to store and manage data in which each department or area within an organization has its own set of files.
Define file processing system
100
Information System
What is a collection of hardware, software, data, people, and procedures that work together to produce information?
100
programming language
What is a set of words, abbreviations, and symbols that enables a software developer to communicate instructions to a computer or mobile device?
100
Renewal by Andersen
Where does Tony Schramel work?
200
Database Software
What is another term for database management system (DBMS)?
200
Redundant data and Isolated data.
Name two weaknesses of the file processing system.
200
1. Planning 2. Analysis 3. Design 4. Implementation 5. Support and Security
What are the five stages of system development life cycle (SDLC)?
200
4GL (fourth-generation language)
What does "4GL" stand for?
200
(Skills Assessment Manager)
What does SAM stand for?
300
Text, number, currency, date, AutoNumber, Memo, Yes/No, hyperlink, object, and attachement.
Name three common data types?
300
Reduced data redundancy, improved data integrity, shared data, easier access, reduced development time.
Name 1 advantage of a Database approach.
300
Systems Analyst
Who is responsible for designing and developing an information system?
300
HTML (Hypertext Markup Language)
What does HTML stand for?
300
Cengage has confirmed that the SAM 2016 subscription that you purchased from the bookstore is valid for 180 days from the time that you register the code. (So, until approximately February 2017.)
How long will the SAM 2016 site and textbooks be available to students after this class ends?
400
Fields that contain numeric characters whose values will not be used in calculations, such as postal codes or phone numbers, usually are assigned a text data type.
Why do some fields that store only numbers have a text data type?
400
A database that stores data in tables that consist of rows and columns.
Define relational database
400
With direct conversion, the user stops using the old system and begins using the new system on a certain date.
What happens when a user goes through a direct conversion?
400
integrated development environment (IDE)
Because they include tools for building graphical interfaces, an editor for entering program code, a compiler and/or interpreter, and a debugger (to remove errors), most object-oriented application development tools, such as Visual Studio, are referred to as what?
400
Bill Gates & Paul Allen
Who co-founded microsoft?
500
Validation
______ ius the process of comparing data with a set of rules or values to determine if the data meets certain criteria.
500
Growth of online commerce, social, and government applications; increased use of mobile devices, emergence of the internet of things, development of cloud computing, and availability of internet connectivity through wired and wireless networks.
Name 1 recent technology trend that resulted in activities that generate large quantities of data.
500
Implementation Phase
Members of the system development team perform four major activities in this phase: (1) develop programs and apps, (2) install and test the new system, (3) train users, and (4) convert to the new system.
500
WML (wireless markup language)
What allows web developers to design pages specifically for microbrowsers?
500
November 30th
"Computer Security Day" is on what day?