Dbm380 Week2 Indvidual Assignment Uop

Individual Assignment: Database Design

DBM380/ Database Concepts

University of Phoenix

January 9, 2012

Database Design

Database systems are simply a collection of various related information that is cataloged through tables or some standard to present items or information about something or someone where each separate table would have different attributes for said item or items. My company uses various different types of databases to include inventory management pricing, location, and stock as well as employee information like pay rates, contact information, and other things like this. These tables are usually created with software such as Microsoft ACCESS or EXCEL. From what has been gathered database architecture has three parts of operation which are presentation logic, processing logic, and storage logic. This sounds simple enough and if one had to describe what this means one would say that the presentation logic is what a user sees on the screen, processing logic is where the system is in input and retrieval mode, and storage logic is where the information is and retrieved from. (Morgan, 2007)

At first in my workplace I thought we had a one-Tier database although all information is updated on all of the PCs in the shop so it has to be a two-tier due to the network involvement. Relational database architecture is what we have been talking about this week which is defined as “an application of mathematical set theory to the problem of effectively organizing data” (Microsoft, 2012). Simply put, data is organized with these tables as stated before and bridged together to strengthen and make data retrieval more fluid. The displays on ones screen compared to what is actually done with the tables are two totally different looking entities as well. On the table one will only see the data itself whereas the data itself can be displayed many different ways. A user can have this data displayed with pie charts, graphs, and many other...