Preview

Relational Data Base Model

Good Essays
Open Document
Open Document
875 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Data Base Model
What are the advantages and limitations of Relational Database Model?
Advantages:
he relational database model was first introduced by E.F. Codd of IBM in 1969. In the relational model, data are structured into tables (i.e., "relations") consisting of rows and columns. Each row contains a single record comprised of individual data elements (or "attributes") organized in columns containing elements of the same kind according to the rules defined for that column. Alternate database models include the network, hierarchical, flat file, and object-oriented models.
1. Simplicity o The relational model structures data in a manner that avoids complexity. The table structure is an intuitive organization familiar to most users, particularly those who have worked with physical or software spreadsheets, check registers or other tabular data. Data are organized naturally within the model, simplifying the development and use of the database.
Ease of Data Retrieval o Under the relational model, accessing data in a database does not require navigating a rigid pathway through a tree or hierarchy. Users can query any table in the database, and combine related tables using special join functions to include relevant data contained in other tables in the results. Results can be filtered based on the content of any column, and on any number of columns, allowing users to easily retrieve meaningful results. Users can choose which columns to include in the results so that only relevant data are displayed.
Data Integrity o Data integrity is an essential feature of the relational model. Strong data typing and validity checks ensure data fall within acceptable ranges, and required data are present. Referential integrity among tables prevents records from becoming incomplete or orphaned. Data integrity helps to ensure accuracy and consistency of the data.
Flexibility
o The relational database model is naturally scalable and extensible, providing a flexible structure to meet changing

You May Also Find These Documents Helpful

  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Ilab Instructions

    • 2258 Words
    • 10 Pages

    Relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    big bang theory vs relgion

    • 4383 Words
    • 18 Pages

    To clarify what's out there to be investigated, Southall begins the handbook in earnest by defining the terms, since ghosts, spirits and poltergeists are not interchangeable and represent quite different phenomena.Ghosts and apparitions are a kind a recording on the environment - a residual energy that can come from a person, animal or even an inanimate object. We can experience these lingering energies by sight, sound, smell and touch. Spirits are what people most often think of as "ghosts." A spirit is the "actual sentient presence, or soul, of an individual or individuals who have remained in the material world after his or her physical body has died." Southall continues by describing different types of spirits and the reasons they may have stayed behind.…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Good Essays

    One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    week 4 Discussion 1

    • 447 Words
    • 2 Pages

    Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.…

    • 447 Words
    • 2 Pages
    Satisfactory 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

    Cis 111

    • 790 Words
    • 4 Pages

    “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
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.…

    • 160 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Relational Database Paper

    • 547 Words
    • 3 Pages

    I think a few of the most important concepts in a relational database design are: Primary Key (PK) - A column with a unique value for each row. From a design perspective a PK is a requirement. Primary Keys allow you to quickly and easily associate data from multiple tables that are related. Foreign Key (FK) - When you want a row in one table to be linked to a row in another table, you place a FK column in the child table and use the value of the parent row's PK as the value of the FK field. One-To-One…

    • 547 Words
    • 3 Pages
    Satisfactory 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

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

    Relational Databases

    • 750 Words
    • 3 Pages

    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…

    • 750 Words
    • 3 Pages
    Good Essays
  • Good Essays

    First normal form (1NF) sets the very basic rules for organized databases. These rules eliminate duplicative columns from the same table and creates separate tables for each group of related data and identify each row with a unique column or set of columns known as the primary key. The basic objective of the first normal form defined by Codd was to permit data to be queried and manipulated using a “universal data sub-language” such as SQL. One of Codd’s important insights was that the structural complexity could always be removed, leading to a much greater power and flexibility in the way queries could be formulated and evaluated.…

    • 505 Words
    • 3 Pages
    Good Essays