Preview

Relational Databases

Good Essays
Open Document
Open Document
750 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Databases
Relational Databases
Lee Rudd

Abstract Data for our programs are stored in various formats. The most commonly used format is in the form of a database since databases are not dependent on a single program or hardware platform. These databases are stored in five structures of hierarchical, network, relational, multidimensional, and object-oriented. Hierarchical structure organizes data in a one to many relationship. The network goes of the hierarchical structure by organizing data in a many to many relationship. The relational structure organizes the data in tables and allows the end user to determine the relationship at run time. Multidimensional takes the relational structures concept and uses multi dimensions to organize the data. Object-oriented structure has not only the attributes of the entity, but also contain the operations that can be performed on it.

Keywords: Database, Relational, Hierarchical, Network, Multidimensional, Object-oriented. There are many ways to store and access data. One of these ways is using a data base. A database is an integrated collection of logically related data elements that are organized into a common pool of data elements (O 'Brien & Marakas, 2011). These elements are stored in such a way that they are not dependent on any one program or any piece of hardware. Thus allows data to be shared easily between programs. A database uses a database management system or DBMS that use one of five specific data structure that allows the end user access to the data in the database. The five data structures are hierarchical, network, relational, object-oriented, and multidimensional. The first databases used the hierarchical data structure to store and gather the data. This structure the data relations are stored in a tree like records are dependent and arranged in multilevel with one root record and various subordinate levels. Any data element in the database can be found by starting at the root record and



References: O 'Brien, J. A., & Marakas, G. M. (2011). Management information systems. (10th ed.). New York, NY: McGraw-Hill/Irwin.

You May Also Find These Documents Helpful

  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    3. The database scheme: the specifications of the logical structure of the data stored in the database.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Better Essays

    The differences in the architectures are based on how the tables and records are related. Relational architecture is a very popular database. It is also the most mature and widely used database system in production. Relational databases can be used to track patient care in the form of treatments, outcomes of those treatments, and critical indicators of a patient 's current state such as blood pressure, heart rate, and blood glucose levels. They can also be used to interconnect with multiple informational systems throughout a healthcare facility. Relational databases have the potential to eliminate paper storage and transfer of information and to answer important questions about healthcare efficacy. Relational systems serve as the repositories of record behind nearly all online transactions and most online content management systems including social networks. This database also serves as a well-understood point of reference for new extensions and revolutions in database systems that may arise in the future. Another type of database architecture is the Object-oriented model. This model is powerful and quite complex. With the relatively new object-relational database model is the wide spread and simple relational database model extended by some basic object-oriented concepts. These allow them to work with the relational database model but also have some advantages of the…

    • 754 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Database Design Paper

    • 429 Words
    • 2 Pages

    A few models that most databases are built around are a flat database, network database, hierarchical database, and a relational database. The relational type database is the most commonly used but certainly not the only flavor. The specific situation will determine which type of database is best suited.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    This exercise will introduce you to the basic building blocks of any database – fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer vendors, the more applicable use of databases involves the creation of many tables linked together with a common field or “key.” Regardless of the size of the database, the data is stored in the same way – in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.…

    • 1190 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    “Databases are a mean for storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns.” “A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows).” “Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database.” “A Database Management System (DBMS) handles the way data is stored, maintained, and retrieved.” “In the case of a relational database, a Relational Database Management System (RDBMS) performs these tasks. Oracle, 2014)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 Pages
    Better Essays
  • Satisfactory Essays

    What is a database: A database is a group of data that has been organised in a table or group. This makes it easy to find data, but also allows you to not have any duplicates in a group. A database is used in a school or college to store students date of births. This allows the school to be able to see how old the students are. The database can also be password protected to keep the data safe.…

    • 557 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Database is a place to store lots of data, imagine it as a giant virtual filling cabinet that can be organized in many ways. There’s software called (DBMS) which stands for database management system which allows the user to manage data in database such as; create, delete or update.…

    • 1351 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Database Administrators

    • 1626 Words
    • 7 Pages

    A database consists of a file or a set of files. The information in these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage, and each field typically contains information pertaining to one aspect or attribute of the entity described by the database. Using keywords and various sorting commands, users can rapidly search, rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregates of data.…

    • 1626 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Databases are very important to every person in the world today. Whatever you do in you daily routine you are bound to come in contact with some form of database and our world has become so dependent on it that most people won’t even realize the importance of databases. A database is a bunch of files that are usually integrated electronically together to make up one big file. The database stores all of these files in one location and numerous people can access this information all at the same time if they have the proper access from the database administrator.…

    • 1084 Words
    • 5 Pages
    Better Essays
  • Good Essays

    information system

    • 1242 Words
    • 5 Pages

    In all information systems, data resources must be organized and structured in some logical manner, so that they can be:…

    • 1242 Words
    • 5 Pages
    Good Essays
  • Better Essays

    The purpose of a database is to provide an organized model of maintaining, storing, managing and retrieving information. The concept is largely based on the use of tables to hold information much like that of a spreadsheet. These tables are arranged in columns and rows where each row pertains to a specific dataset or record and each column represents a specific attribute of the data set. Although databases are similar to spreadsheets, databases are much more powerful and useful in the way data is manipulated, gathered and presented.…

    • 1185 Words
    • 5 Pages
    Better Essays