Chapter 6: Foundatons of Business Intelligence: Database & Information Management Flashcards
What is knowledge?
Knowledge is the awareness and understanding of a set of information
What is a database?
This is a collection of related data organized in a way that makes it valuable and useful
A relational database model uses a collection of tables to represent data and relationships
What is the hierarchy of data in a database?
- Field
- Record
- File
- Database
What is an Entity?
An Entity is an observation
What is a File?
This is a collection of records for an Entity, also called tables
What is a record?
A record is a field describing a single instance, usually represented in the rows of a table
What is a field?
These are attributes from an Entity. Represented in the columns
What is SQL?
SQL refers to Structured Query Language and it is a standard language to communicate with data systems.
What is normalization?
Normalizaiton is the process of streamlining complex groups of data to minimuze redundant elements and increase flexibility and stability of your database
What are the three different types of SQL commands?
- Data Definition Language ( creating, deleting, altering databases and tables)
- Data Manipulation: retrieving, inserting changing records
- data content: user and permission maangement (access)
What are the requirements for 1NF?
- Domain of each attribute only contains atomic values
- Value of each attribute only contains a single value from a domain
What are the requirements of 3NF?
- Satisfies 2NF
- No transitive dependencies
What does an Entity relationship model do?
It describes relationships between subjects of interest and is visualized in an entity-relationship diagram.
What are the requirements for 2NF?
- Satisfies 1NF
- There are no partial (transitive) dependencies on composite key
What concepts are entity-relationship diagrams based on?
- Entities and entity sets
- Attributes
- Relationships and relationships sets
- Cardinalities
What are entity sets?
Notion of a table in a database
What are entities?
These are things of interest to organization
What are attributes?
These describe properties of an entity