Chapter 6 DATABASESDatabases Maintains Information About
Chapter 6: DATABASES
Databases – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
Database Management System (DBMS) – creates, reads, updates, and deletes data in a database while controlling access and security (see figure 6.9).
Query-By-Example (QBE) tool – helps users graphically design the answer to a question against a database
Managers typically interact with OBE tools
Structured-Query-Language (SQL) – Asks users to write lines of code to answer questions against a database
MIS professionals have the skills required to code
Relational Database Model (RDMS) – allows users to create, read, update, and delete data in a relational database.
Entity (also called a table) – stores information about a person, place thing transaction, or event.
Attributes (also referred to as columns or fields) – are the data elements associated with an entity.
Primary Key – is a field (or group of fields) that uniquely identifies a given record in a table. In the table RECORDINGS, the primary key is the field, RecordingID, that uniquely identifies each record in the table. Primary keys are critical because they provide a way of distinguishing each record in a table. (i.e. searching a customer by ID number , see figure 6.10)
Foreign Key – is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
Data Warehouse – is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. The primary purpose of a DW is to combine information, more specifically strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and under-take business analysis. A key idea is to collect information from multiple systems in a common location that
Databases – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
Database Management System (DBMS) – creates, reads, updates, and deletes data in a database while controlling access and security (see figure 6.9).
Query-By-Example (QBE) tool – helps users graphically design the answer to a question against a database
Managers typically interact with OBE tools
Structured-Query-Language (SQL) – Asks users to write lines of code to answer questions against a database
MIS professionals have the skills required to code
Relational Database Model (RDMS) – allows users to create, read, update, and delete data in a relational database.
Entity (also called a table) – stores information about a person, place thing transaction, or event.
Attributes (also referred to as columns or fields) – are the data elements associated with an entity.
Primary Key – is a field (or group of fields) that uniquely identifies a given record in a table. In the table RECORDINGS, the primary key is the field, RecordingID, that uniquely identifies each record in the table. Primary keys are critical because they provide a way of distinguishing each record in a table. (i.e. searching a customer by ID number , see figure 6.10)
Foreign Key – is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
Data Warehouse – is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. The primary purpose of a DW is to combine information, more specifically strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and under-take business analysis. A key idea is to collect information from multiple systems in a common location that