Chapter 5: Database and Content Management Flashcards Preview

MGMT 250: Information Technology Management > Chapter 5: Database and Content Management > Flashcards

Flashcards in Chapter 5: Database and Content Management Deck (44)
Loading flashcards...
1

Why Do You Need to Know About Databases

For one, databases are everywhere.

Every time you make a cell phone call, log on to the Internet, or buy something online using a credit card, applications behind the scenes are processing numerous databases.

2

Reasons for Learning Database Technology

1) When you participate in the development of any new business initiative, you need to know if database technology can facilitate your project goals.

2) Because databases are ubiquitous in commerce, billions of bytes of data are stored every day. You need to know how to turn that data into a format from which you can construct useful information.

3)Business is dynamic, and information systems must adapt. Often, such adaptation means that the structure of the database needs to be changed.

4)Finally, you might someday find yourself or your department in a material mess.

3

What Is the Purpose of a Database?

A database keeps track of things

4

Lists that involve a single theme can be stored in a

spreadsheet

5

lists that involve multiple themes require a

database

6

Content

can be difficult to define.

In the broadest sense, content is something of value and can be considered an asset just like other items of property.

7

Intellectual property

as a form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography.

8

One way of thinking about content management is to separate the ______ of content from the ________ of content

management

presentation

9

Content management systems (CMSs)

Information system that tracks organizational documents, webpages, raphics, and related materials

10

Database

self-describing collection of integrated records

11

Byte

Character of data (an 8 bit chunk)

12

Columns (aka fields)

Database table has multiple columns that are used to represent the attributes of an entity

13

Row (aka record)

Groups of columns in a database table

14

Table (aka file)

Group of similar rows or records in a database

15

Key

a column or group of columns that identifies a unique row in a table.

Every table must have a key.

16

Foreign keys

This term is used because such columns are keys, but they are keys of a different (foreign) table from the one in which they reside.

17

Relational databases

Databases that carry their data in the form of tables and that represent relationships using foreign keys

18

Metadata

Data that describes data

19

database application system

Applications with the standard five components that make database data more accessible and useful

Users employ a database application that consists of forms, formatted reports, queries, and application programs. Each of these, in turn, calls on the DBMS to process the database tables

20

The Database Management System (DBMS)

program used to create, process, and administer a database

21

As is the case with operating systems, almost no organization develops its own DBMS.

Instead, companies license DBMS products from vendors, such as IBM, Microsoft, and Oracle

22

DB2

Popular, enterprise-class DBMS product from IBM

23

Access

Popular personal and small workgroup DBMS product from Microsoft

24

vast majority of databases used by small and mid-sized enterprises.

DB2
Access
SQL Server
Oracle
MySQL

25

DBMS and a database are two different things

A DBMS is a software program

a database is a collection of tables, relationships, and metadata

26

Applications use the DBMS for four operations:

read, insert, modify, or delete data

27

Structured Query Language (SQL)

an international standard language for processing a database.

28

database application

a collection of forms, reports, queries, and application programs that process a database.

29

Form

Data entry forms are used to read, insert, modify, and delete database data

30

Report

Presentation of data in a structured, or meaningful, context