Ch. 4 Flashcards
What is data?
Raw bits and pieces of information
What is quantitative?
Numeric
What is qualitative?
Descriptive
What is information?
Is when data is given context and is more specific
What is knowledge?
Developed when information has been aggregated and analyzed to make decisions, set policies, and spark innovation
What is wisdom?
The combination of knowledge and experience and may take years to develop
What are databases?
Organized collection of related information to generate knowledge for decision making purposes
What is relational database?
Data is organized into one or more tables such as Microsoft Access. Relational databases use Microsoft Access installed on one machine with one use access at a time.
What are tables?
A collection of fields
Ex. Student ID, course ID, grade earned
What is a record?
An instance in the table Ex. your specific information in the table
Design is a critical first step in creating a database. What things should you recognize in creating this design?
- Understand the goal and how the database will be used
- Identify the data needed as part of accomplishing this goal
- Identify how the data is related to each other
- Identify tables and fields to organize the data
What is text? (a field in a database)
Non-numeric data less than 256 characters
What is a number? (a field in a database)
Numeric data
What is yes/no? (a field in a database)
Stores 0 for no or false and 1 for yes or true
What is date/time? (a field in a database)
Number data type that can be interpreted as a number or a time