Relational Database Study Guide

475 Words1 Page
bulb-icon

Recommended: Relational model in database

1
Data is stored in separate tables this is the idea of a relational database.Each table stores data about a single individual.There are some rules required for relational database tables.

Every row must be constructed in the same way, that is each column must contain data of just one data type.
One column,or a combination of columns,must be able to make each row of the table unique.
This column or combination of columns is called the PRIMARY KEY.
There is no rule about the sequence of rows in a table.
There is no rule about the order of the columns.
No 2 rows in a relation can be identical.

The tables of a relational database are linked through relationships.Relationships are produced by having repeated fields.A field repeated from another table is called a FOREIGN KEY.

A non-relational database is any database that does not carry out the relational …show more content…

Data structure-In order to use unstructured data that does not fit neatly into rows and columns the non relational databases are designed to do this.As most of the data generated is unstructured this is a definite requirement.
Scaling-by taking advantage of cheap ,commodity servers the system can be scaled horizontally.
You don't have to pay any software licensing fees in advance as they are an open source.

In comparing the two ,the limitations of relational databases is that it can only contain one characteristic.Eg if we use a customers accounts with a bank all their information is stored into separate row items in separate tables.Therefore a number of tables are used for various accounts, they are linked together through primary and foreign keys.One reason why relational databases will continued to be used as there is a method applying business sense and rules at the database layer.This makes sure that when a customer is using their card it is charged to the correct bank account, using primary and foreign

Show More
Related

  • Assignment 282: Database Scenarios

    1012 Words  | 3 Pages

    Now click the “ENTER” key on your keyboard, on your computer is operating in ‘Safe Mode’.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...

    Read More

  • Pro Forma Essay

    1888 Words  | 4 Pages

    Inability of modification of data: The managing of huge data effectively and efficiently for efficient results, storing the details of the consumers etc. in such a way that the database can be modified as not possible in the current system. 2. Not user friendly: The existing system is not user friendly because the retrieval and storing of data is slow and data is not maintained efficiently.

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Creating an EcOS Database

    1468 Words  | 3 Pages

    Determine how results are to be presented and shared. These steps can help you to create a database effectively.

    Read More

  • Towers of Hanoi

    585 Words  | 2 Pages

    When placing all the results into a table I noticed that if you take a

    Read More

  • Database Case Study

    1374 Words  | 3 Pages

    You can think of database as godown or warehouse which is used to store different type of things. Technically,a database is a collection of information organized

    Read More

  • Normalization and Integrity

    1055 Words  | 3 Pages

    Inconsistently storing organization data creates a lot of issues, a poor database design can cause security, integrity and normalization related issues. Majority of these issues are due to redundancy and weak data integrity and irregular storage, it is an ongoing challenge for every organization and it is important for organization and DBA to build logical, conceptual and efficient design for database. In today’s complex database systems Normalization, Data Integrity and security plays a key role. Normalization as design approach helps to minimize data redundancy and optimizes data structure by systematically and properly placing data in to appropriate groupings, a successful normalize designed follows “First Normalization Flow”, “Second Normalization Flow” and “Third Normalization flow”. Data integrity helps to increase accuracy and consistency of data over its entire life cycle, it also help keep track of database objects and ensure that each object is created, formatted and maintained properly. It is critical aspect of database design which involves “Database Structure Integrity” and “Semantic data Integrity”. Database Security is another high priority and critical issue for every organization, data breaches continue to dominate business and IT, building a secure system is as much important like Normalization and Data Integrity. Secure system helps to protect data from unauthorized users, data masking and data encryption are preferred technology used by DBA to protect data.

    Read More

  • DB2 Case Study

    741 Words  | 2 Pages

    The DB2 databases have great self-configuring features, it doesn’t need a database installation process as it already has IBM installed, since the database has unique Single Level Storage concept of the system, responsibilities such as observing and creating table spaces or complicated partitioning of data through disk subsystems is not needed. The software also offers automatic data spreading for the entire database objects.

    Read More

  • Mysql And Open Source

    839 Words  | 2 Pages

    ... GPL and use it without fees. However, they would have to pay a fee if they wanted a commercial version of the MySQL. Commercial MySQL software could be distributed with non-open source software, included a warranty from MySQL and came with a development support. MySQL used its open source status as a viral marketing vehicle to penetrate markets. It used the booming Internet successfully for marketing purposes. Also, it identified other players in the value chain and took part in the creation of the LAMP (Linux, Apache, MySQL, PHP) protocol, which soon became an acronym for coherent OSS building blocks. This is a how a successful business model enabled MySQL to derive profit from open innovation and enabled it to create value in the chain as well as to derive value for itself.

    Read More

  • Brief History Of Databases

    1727 Words  | 4 Pages

    of multiple types of end users. The data is stored in one location so that they

    Read More

  • The Career Paths Of Computer Information System

    1119 Words  | 3 Pages

    A database comprises an information of data for producing quicker and accessed, maintained, and renewed data. The database software its storage to retain and combine data that I deal with every day. To illustrate, a data information as personal data that connected to users ' information. The database continues to be critical for organizations that keep them in the business. A database is a large number of data that I work carefully with in every database of the organization. In other words, by Computer information system, I understand database, it is my job to deliver them to correct the

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.

    Read More

  • Analysis of Database Management and Information Retrieval Systems

    1078 Words  | 3 Pages

    There are three types of Database Management System which are the relational Database Management System, the non-relational Database Management System and Object Oriented Database Management System. The relational DBMS is the most widely accepted Database Management System nowadays. The non-relational DBMS that are in large scale are still in use while the Object Oriented DBMSs are in development. Besides, more and more DBMSs are supporting basic multimedia storage and retrieval facilities.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about Relational Database Study Guide

Open Document