Flashcards in Chapter 5: Database and Content Management Deck (44)
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.
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.
What Is the Purpose of a Database?
A database keeps track of things
Lists that involve a single theme can be stored in a
lists that involve multiple themes require a
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.
as a form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography.
One way of thinking about content management is to separate the ______ of content from the ________ of content
Content management systems (CMSs)
Information system that tracks organizational documents, webpages, raphics, and related materials
self-describing collection of integrated records
Character of data (an 8 bit chunk)
Columns (aka fields)
Database table has multiple columns that are used to represent the attributes of an entity
Row (aka record)
Groups of columns in a database table
Table (aka file)
Group of similar rows or records in a database
a column or group of columns that identifies a unique row in a table.
Every table must have a key.
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.
Databases that carry their data in the form of tables and that represent relationships using foreign keys
Data that describes data
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
The Database Management System (DBMS)
program used to create, process, and administer a database
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
Popular, enterprise-class DBMS product from IBM
Popular personal and small workgroup DBMS product from Microsoft
vast majority of databases used by small and mid-sized enterprises.
DBMS and a database are two different things
A DBMS is a software program
a database is a collection of tables, relationships, and metadata
Applications use the DBMS for four operations:
read, insert, modify, or delete data
Structured Query Language (SQL)
an international standard language for processing a database.
a collection of forms, reports, queries, and application programs that process a database.
Data entry forms are used to read, insert, modify, and delete database data