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

  • Better Essays

    References: O 'Brien, J., & Marakas, G. (2008). Management information systems (8th Edition ed.). The McGraw-Hill Companies.…

    • 1317 Words
    • 6 Pages
    Better Essays
  • 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
  • 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
  • Better Essays

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

    • 1167 Words
    • 4 Pages
    Better Essays
  • Good Essays

    O 'Brien, J.A., & Marakas, G.M. (2008). Management information systems (8th ed.). New York, :…

    • 761 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    System |Purposes |Examples |Uses | |Word processor |The word processor, Invented in the early 1900s an updated prototype of the typewriter, creates a document in digital format but goes one step further than the typewriter and stores the information. Word processors can track changes and make corrections as you type. |Microsoft word which widely used for in the business and personal world. Word perfect, Word pad, and Word open office writer |One of the biggest uses for me is writing my papers for class. The fast connivance to proof read and spell check save me time. Allows the user to save and share his document. Word processors gives the option of making comparisons of documents; in cases where several users may be working on the same documents, the comparison feature allows for differences in the documents to be easily viewed, making editing more streamline(brown). | |Hierarchical database |Hierarchal data can be organized data where each level of the data is organized, resembling a tree. Data can be arranged in a repeating series that ties or links the data together.Its designed to process and manipulate data in a number that takes advantage of the hierarchical(Prabhakran & Rajamani). |A family tree can be organized in a structured form. Prabhakaran & Rajamani). |This type of Data base is used mostly to save and retrieve information efficiently. | |Flat Database |A system where information can be stored. Flat files are simple data that files that take up very little space that other files.Flat files are like spread sheet where rows on the…

    • 1437 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    As we know, database is structured collection of data; computer based databases are usually organized into one or more tables. A table stores data in a format similar to a published table and consists of a series of rows and columns.…

    • 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
  • Powerful Essays

    Concept of Dbms

    • 1140 Words
    • 5 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities.…

    • 1140 Words
    • 5 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

    References: O’Brien, J.A. & Marakas, G.M. (2008). Management Information Systems (8th ed). New York: McGraw-Hill.…

    • 1069 Words
    • 5 Pages
    Good 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
  • Best Essays

    References: O 'Brien, J. A. & Marakas, G. M. (1999). Management Information Systems (9th edition). 190-…

    • 4105 Words
    • 17 Pages
    Best Essays
  • Good Essays

    Relational Database

    • 632 Words
    • 3 Pages

    To create a family reunion database using Microsoft Access, we first need to break down the information currently available to us.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    A database is a means of storing information in such a way that information can be retrieved from it. Thus a database is typically a repository for heterogeneous but interrelated pieces of information. Often a database contains more than one table. Codebooks and dictionaries can also be considered as tables. A dictionary is a reference book on any subject, the items of which are arranged in alphabetical order. Codebook is a list of replacements for words or phrases in the original message. A code is a system for hiding the meaning of a message by replacing each word or phrase in the original message with another character or set of characters. The list of replacements is contained in a codebook. An alternative definition of a code is any form of encryption which has no builtin flexibility, i.e. there is only one key, namely the codebook. Databases contain organized data. A database can be as simple as a flat file (a single computer file with data usually in a tabular form) containing names and telephone numbers of one’s friends, or as elaborate as the worldwide reservation system of a major airline. There are many ways to approach the design of a database and tables. The database layout is the most important part of an information system. The more design and thought put into a database, the better the database will be in the long run. We should gather information about the user’s requirement, data objects, and data definitions before creating a database layout. Traditionally, there are four different DBMS data models: the hierarchical data model, the network data model, the relational data model, and the objectoriented data model.…

    • 2737 Words
    • 11 Pages
    Powerful Essays