Database Design - Essay Example

The organizations activities are supported by the database that is created for it. For example, your local gas station has register pumps that work off of a database. This database has all the prices for every type of gas or diesel fuel sold. The gas station database is also hooked up to the cash registers on the inside of the station. So once you pump your gas outside, the database at the pumps store the information such as fuel cost, amount pumped and possibly credit card information if you decided to pay at pump.

We Will Write A Custom Essay Sample On
ANY TOPIC SPECIFICALLY
FOR YOU

For Only $13.90/page


order now

Now all of this information can be accessed through his database from the inside of the gas station and possibly the gas stations headquarter office. Databases are used to keep an accurate account of data for whatever the enterprise needs account of. Next question we have is “What is database architecture? “. Database architecture uses programming languages to design a certain type of software for a business or organizations use. This software helps break down the information for easy viewing. Through my research I found that there are three tiers on database architecture.

These tiers are external, conceptual ND internal levels. A quick run through for each tier, external level is for the users view that controls the programs and may be inputting the information. Conceptual level is the community view level that can be described as your screen showing you your bank account information. You can change the database (as much as you would like to) but you are able to view the data, and the last level is the internal level, which is the storage level or memory section. There are many different programs out there that help employers build their own databases such as Microsoft Access.

Microsoft Access makes database building easy and secure for anyone to use. It also stores your data automatically in an SQL database. An SQL database is a type of database language that allows it to be viewed from multiple applications and locations. Making your database easily accessible and useable throughout your office or workspace. I’m an aircraft maintainer and we use the system TACOMA. This is our database system with all of our tools and equipment logged into it as well as all of the personnel who need to use these parts.

In order to get a tool you must check it out in the database under the name of the individual using it. This is the way we keep track of our tools and nothing can come up missing as long as we have the database and tool accountability. This database falls under external and conceptual tiers. External tier would be the level of the system where the program user checks tools in and out to the individual requiring them. The Conceptual tier is used when the individual looks at his name on the screen and can view every tool he has check out under his name.