Database Systems

Database Systems 1

Database Systems

Name

University of Phoenix

Instructor

Week 1 Individual Assignment

Database Systems 2

Abstract

Database Systems affect businesses around the United States more than we think it does. Databases ensure that the information saved can be accessed at a later time and proper backing up of files on another server will be protected too. Understanding how each database system works and its correlation to different businesses is important. This paper includes information on Rochester Gas and Electric’s database systems and how it is used on a day to day basis.

Database Systems

There are many types of database systems and the way each is used in a business/company setting. The following below show the different types of databases and what each does.

- Relational Databases – The relational database system has columns and rows that give information that is “related” to the person, object, or item being described. Each row gives information on a person, vehicle, cell phone type, etc. But each column will give more information on the row that was entered. For example, if the information is being described as different types of cell phones the row can state the cell phone maker like Apple, Audiovox, Nokia, Blackberry, or LG. Then the column can give specific information on the model such as the storage space, camera phone, GPS enabled, etc.

- Hierarchical Databases – The hierarchical databases are mainly based on a tree-like structure because of how the files/folders are aligned in the C:\ also known as the root directory. The root directory does show all of the different files and

Database Systems 3

folders that are aligned in each specific category. The root directory holds documents and settings, temporary files, and Windows directory. Users, who have access to the windows directory probably shouldn’t because of the information of files listed and if deleted can cause a...