AIS Exam 1 (Chapter 6)

Database

collection of related data for various uses

Relational data model

Data model that stores information in the form of related two-dimensional tables

Database Management System (DBMS)

A computer program that creates, modifies and queries the database.

Designed to manage a database’s storage and retrieval of information

Data Dictionary

Describes the data fields in each database record such as field description, field length, field type (e.g., alphanumeric, numeric), etc

Database Administrator

The person responsible for the design, implementation, repair and security of a firm’s database

Entities

Resources, events, and agents

Attributes

characteristics, properties, or adjectives that describe each class

Table/Relation

The primary construct, used for data storage with rows and columns much like a spreadsheet. Each table in a database represents either a class or a relationship between classes. Tables need to be properly linked to make a relational database.

Column

The columns in a table are called fields that represent the attributes or characteristics of the class or relationship

Rows

Are called records or tuples. The records represent all the specific data values that are associated with one instance

Entity Integrity Rule

Primary key must have data values (cannot be null)

Referential Integrity Rule

the data value for a foreign key must either be null or match one of the data values that already exist in the corresponding table

Rules with PK and FK?

Each attribute: unique name

Value of each attribute: same type

Each attribute (column) of a record (row): single-valued

All other non-key attributes: describe a characteristic of the class (table) identified by the primary key

Tables (MS Access)

Store data which consists of a series of rows (records) and columns (attributes) connected by relationships (links between tables by foreign keys)

Queries

Retrieve and display data derived from records stored within the database

Forms

Enter data into tables and view existing records, powered by queries

Reports

Integrate data from one or more queries and tables, cannot edit database info

Enterprise Systems (ERP)

information systems integrate and automate business processes across a firm’s value chain located within and across organizations

ERP challenges

Integrating

• various modules within the enterprise system

• with external systems such as the information system of a supplier and/or customer

• with the firm’s own existing legacy systems

Converting

• data from existing legacy systems to the enterprise system

Implementing

• any big project at a firm

Cloud Computing

Internet-based computing where shared resources, software, and information are provided to firms on demand