Database Design

Database Design

Bobby Watson

DBM/380

March 27, 2014

Jean Baptiste

Database Design

Databases are the foundation to collecting and storing information that is pertinent to an integrated computer system. The importance of databases cannot be understated and must be the prime focus of the information technology organizations in all forms of business. It is probably best described in our text:

“A database is a shared, integrated computer structure that stores a collection of:

• End-user data-that is, raw facts of interest to the end user.

• Metadata, or data about data, through which the end-user data are integrated and managed” (Rob, Coronel, & Morris 2013 p.33).

Another definition states that “A database consists of one or more tables to store data, one or more forms to enter data into the tables, and one or more reports to output the data into the table data as organized information” (Grauer, Mast, & Poatsy, 2011, p. 69).

The use of databases vary among business users, but can, and are, used by most computer users on a daily basis. Many computer users have an extensive music, and or, photo collections. These collections are stored in what amounts to extensive databases that manage the location and specifics about each piece of data. Each of these files also include data that is not necessary for individuals to view at a specific point, but can be important when performing analysis of the database, or a file, at times. This data is considered Metadata. Metadata contains information concerning file size, type, date stored, etc.

A Database Management System (DBMS,) contains the software necessary to manage and deliver the data to the customer in a relevant manner. It allows sharing, improved security, data integration and performs with an enhanced consistency while providing data access. But probably the most important aspect of all is that it allows the end user to become more productive.

Databases are used every day. Every day that you use a computer...