Database

Chapter 1 Database Systems Discussion Focus

Written by Gary Black

Chapter 1 Database Systems Discussion Focus

How many of them have bought anything using a credit card during the past? Chapter 1 Database Systems Discussion Focus

Chapter 1 Database Systems Discussion Focus

Chapter 1 Database Systems Discussion Focus

None of those transactions would be possible without a database. How many have shipped a document or a package via an overnight service or via certified or registered mail? Databases are important because we depend on their existence to perform countless transactions and to provide information.

You can use the web to look up a few insurance quotes or compare car prices and models. Also an important distinction between data and information.  “Data vs. Information.”

Discuss how important it is that the (database) transactions are made successfully, accurately, and quickly. That part of the discussion points to the importance of database design. If you want to have the keys to the information kingdom, you’ll want to know about database design and implementation.

Databases don’t manage themselves … and that point leads to the importance of the database administration (DBA) function. There is a world of exciting database employment opportunities out there.

Discuss each of the following terms:

data

Raw facts from which the required information is derived. Data have little meaning unless they are grouped in a logical manner.

field

A character or a group of characters (numeric or alphanumeric) that describes a specific characteristic. A field may define a telephone number, a date, or other specific characteristics  that the end user wants to keep track of.

record

A logically connected set of one or more fields that describes a person, place, event, or thing. For example, a CUSTOMER record may be composed of the fields CUST_NUMBER, CUST_LNAME, CUST_FNAME, CUST_INITIAL, CUST_ADDRESS, CUST_CITY, CUST_STATE, CUST_ZIPCODE, CUST_AREACODE, and CUST_PHONE.

file

Historically, a collection of file folders, properly tagged and kept in a filing cabinet. Although such manual files still exist, we more commonly think of a (computer) file as a collection of related records that contain information of interest to the end user. For example, a sales organization is likely to keep a file containing customer data. Keep in mind that the phrase related records reflects a relationship based on function. For example, customer data are kept in a file named CUSTOMER. The records in this customer file are related by the fact that they all pertain to customers. Similarly, a file named PRODUCT would contain records that describe products – the records in this file are all related by the fact that they all pertain to products. You would not expect to find customer data in a product file, or vice versa.

  1. What is data redundancy, and which characteristics of the file system can lead to it?
  2. Discuss the lack of data independence in file systems. What is data independence, and why is it lacking in file systems?
  3. What is a DBMS, and what are its functions?
  4. What is data independence, and why is it important?

Often you can conduct searches and find the answers online. This post is a sample of what a college class offers a student in the subject. Contact your local community or four year college for classes available in your area.

If you want more details or to discuss this post then contact author here

Here is a Amazon listed book featuring Database Systems: Design, Implementation, and Management

About the author

Gary Black

Leave a Comment