Preview

Relational Database Concepts and Applications: Research Paper

Good Essays
Open Document
Open Document
672 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Database Concepts and Applications: Research Paper
Research Paper
University of Maryland University College
CMIS 320 6381 Relational Database Concepts and Applications
Professor Kevin W…..
By
Bob Bobson
March 7, 2014

Introduction
In order to successfully transition from our current paper and email based equipment request method to a completely paperless online system, we must build and implement a relational database. A relational database will allow us to store, filter, make changes to, and share of the data that is needed in our new online equipment ordering system.
Relational Database Overview
“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)”
Why We Should Implement a Relational Database
“Establishing a relational database management system is a great way to increase data integrity, efficiency, ask questions, sort and filter data, provide stronger security, and share information in one concise design which is very user friendly if developed correctly. Relational databases allow the ability to cross-reference data stored by the business and as a result provide a higher level of integrity.” “The key to success is in the foundation of the database's design.” “Relationships of data must be accurately assessed and once this connection is established, the rest falls into place rather smoothly. (Goessl, 2009)”


References: Barrodale Computing Services Ltd. (2011). Applications of Object Relational Database Management Systems at BCS. Retrieved from Barrodale Computing Services Ltd. (BCS): http://www.barrodale.com/docs/ORDBMS%20Applications%20at%20BCS.pdf Goessl, L. (2009, November 23). Business Advantages of a Relational Database. Retrieved from Inside Business 360: http://www.insidebusiness360.com/index.php/business-advantages-of-a-relational-database-15806/ Oracle. (2014). A Relational Database Overview. Retrieved from Java Tutorial: http://docs.oracle.com/javase/tutorial/jdbc/overview/database.html .
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Database: Relational Model and Entity Course Field
    • 421 Words
    • 2 Pages

    Database: Relational Model and Entity Course Field

    8. What is a relational database? A data base that organizes data into overlapping tables. They follow a set of very specific rules that ensure data contained in the database will be consistent.…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Database Plan for Riordan Manufacturing Material Ordering
    • 2376 Words
    • 10 Pages

    Database Plan for Riordan Manufacturing Material Ordering

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
    Read More
  • Good Essays

    Cis 111
    • 790 Words
    • 4 Pages

    Cis 111

    “The benefits of using the relational model would result in an easy to use, flexible, high performance database at a low cost.” (Anita, 2010) Therefore, allowing them to participate in the entire design process of the logical construction. The relational model provides an easy and flexible way of manipulating data with a system that offers:…

    • 790 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Database Environment Week 2
    • 799 Words
    • 3 Pages

    Database Environment Week 2

    References: Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.…

    • 799 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Week 2 Individual Database Design Paper
    • 624 Words
    • 3 Pages

    Week 2 Individual Database Design Paper

    References: What are Relational Databases, and Why Should I Care? . (n.d.). Index of /. Retrieved May 14, 2012, from http://dewey.library.nd.edu/mylibrary/manual/ch/ch16.html…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Relational Database Case Study
    • 1287 Words
    • 6 Pages

    Relational Database Case Study

    Failure by the system to provide needed reports to its owner (anomalies in data redundancy), system malfunction by showing no record of bills paid or payable in the system and inability of the system to update, record, delete information pertaining to customers were some of the major concerns faced by the management. The new system worked on the concept of relational databases i.e. data integrity was the key to the success of the database. If not implemented the right way, the consequences of the database would be failure in data integration, data sharing, increased amounts of data redundancies and other anomalies such as a defective system with many data inconsistencies. The new system failed to show records of customer data because of improper linking between foreign keys in the system. A foreign key is an attribute used to link tables in a database. However the new system should have used query databases to retrieve stored data and also made sure that it followed the referential integrity rule; thereby, ensuring data…

    • 1287 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    02
    • 4219 Words
    • 33 Pages

    02

    An ORDBMS is more advanced than a simple RDBMS since the user can also create reports.…

    • 4219 Words
    • 33 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    The Healthcare Database System
    • 754 Words
    • 4 Pages

    The Healthcare Database System

    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
    Read More
  • Better Essays

    Analyzing the use of databases in the workplace
    • 807 Words
    • 4 Pages

    Analyzing the use of databases in the workplace

    In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.…

    • 807 Words
    • 4 Pages
    Better Essays
    Read More
  • Powerful Essays

    Cis515
    • 3200 Words
    • 13 Pages

    Cis515

    Following the successful expansion of the retail environment to several new stores there is a clear need for an enterprise wide relational database especially with the envisaged increase in sales as a result of current marketing activity.…

    • 3200 Words
    • 13 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Replenish & Restore
    • 5013 Words
    • 21 Pages

    Replenish & Restore

    The database supports a wide variety of data, primarily intended to be used in an appointment booking system. It holds client specific details, appointment details and product and treatment details. The limitation of the database system is that it does not fully support a payment system e.g. it does not hold client credit card details, but functionality can be added by linking into the existing appointment and product purchase tables.…

    • 5013 Words
    • 21 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Three Benefits of a Relational Database
    • 402 Words
    • 2 Pages

    Three Benefits of a Relational Database

    Three main benefits of a relational database are report generation, data storage, and data integrity. When putting information in a relational database the possibilities for running reports from the tables that have been created in the database are endless. As long as the information is organized well, the end user can create queries to generate reports based on the data that has been entering into the database. Another great benefit for creating a relational database is the data storage. Data is stored in tables that have a primary key which holds the identification of that data. It assures the end user that there is no duplication of data and helps to reduce data redundancy. Data integrity assures the end user or database administrator that the data that created follows the rules that are applied so that when reports are generated or queries are created that the data that the end user sees is accurate and good. If integrity rules are created with the relational database then it limits the end user of the type of data they can enter into those fields within those tables.…

    • 402 Words
    • 2 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Coronel PPT Ch01
    • 1962 Words
    • 13 Pages

    Coronel PPT Ch01

    ©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.…

    • 1962 Words
    • 13 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Describing & Storing Data from Dbms
    • 1240 Words
    • 5 Pages

    Describing & Storing Data from Dbms

    The user of a DBMS is ultimately concerned with some real-world enterprise, and the data to be stored describes various aspects of this enterprise. For example, there are students, faculty, and courses in a university, and the data in the university database describes these entities and their relationships.…

    • 1240 Words
    • 5 Pages
    Good Essays
    Read More

Related Topics