close
This essay has been submitted by a student. This is not an example of the work written by professional essay writers.

Relational Database

downloadDownload printPrint

Pssst… we can write an original essay just for you.

Any subject. Any type of essay.

We’ll even meet a 3-hour deadline.

Get your price

121 writers online

blank-ico
Download PDF

Relational Database

A relational database is one whose symbols are organized into a collection of relations.

Types of Relational Models

A database model provides the means for specifying particular data structures, for constraining the data sets associated with these structures, and for manipulating the data. The specification of structure and constraints is done using a data definition language (DDL), and the specification of manipulation is done using a data manipulation language (DML). The most prominent structures that have been used for databases to date are graphs in the network, semantic, and object-oriented models; trees in the hierarchical model; and relations in the relational model.

In general, there are three types of relationships in a relational database:

One-to-many the most common type of relationship is one-to-many. This means that for each occurrence in each entity, the parent entity, there may be one or more occurrences in a second entity, the child entity, to which it is related. (Silberschatz, Korth and Sudarshan, 2011)

The One-To-Many Model One-to-many the most common type of relationship is one-to-many. This means that for each occurrence in each entity, the parent entity, there may be one or more occurrences in a second entity, the child entity, to which it is related.

The One-to-One Model In a one-to-one relationship, a row in a table is related to only one or none of the rows in a second table. These relationships are not as common as one-to-many relationships, because if one entity has an occurrence for a corresponding row in another entity, in most cases, the attributes from both entities should be in a single entity. Note that in a one-to-one model, the concepts of child and parent tables are interchangeable. Each table relies on the other to form the complete picture of each patient or employee. (Hernandez, 2013)

The Many-to-Many Model In a many-to-many relationship, one row of a table may be related to many rows of another table, and vice versa. Usually, when this relationship is implemented in the database, a third entity is defined as an intersection table to contain the associations between the two entities in the relationship.

Columns or Attributes

In database tables, each column or attribute describes some piece of data that each record in the table has. The terms column and attribute are used fairly interchangeably, but a column is really part of a table, whereas an attribute relates to the real-world entity that the table is modeling. In Figure 2 you can see that each employee has an employeeID, a name, a job, and a departmentID. These are the columns of the employee table, sometimes also called the attributes of the employee table.

Rows, Records, Tuples

Look again at the employee table. Each row in the table represents a single employee record. You may hear these called rows, records, or tuples. Each row in the table consists of a value for each column in the table.

Keys

Keys are a very important concept in a successful database design. Keys come in five basic flavours: Super Keys, Candidate Keys, Primary Keys, Foreign Keys, and Keys. Note: This is not a full explanation of keys and how to use them, there is a section on keys later in this document. A Super Key is a column (or set of columns) that can be used to identify a row in a table. A Key is a minimal Super Key. For example, look at the employee table. We could use the employeeID and the name together to identify any row in the table. We could also use the set of all the columns (employeeID, name, job, departmentID). These are both Super Keys.

infoRemember: This is just a sample from a fellow student.

Your time is important. Let us write you an essay from scratch

100% plagiarism-free

Sources and citations are provided

Find Free Essays

We provide you with original essay samples, perfect formatting and styling

Cite this Essay

To export a reference to this article please select a referencing style below:

Relational Database. (2018, October 26). GradesFixer. Retrieved August 5, 2021, from https://gradesfixer.com/free-essay-examples/relational-database/
“Relational Database.” GradesFixer, 26 Oct. 2018, gradesfixer.com/free-essay-examples/relational-database/
Relational Database. [online]. Available at: <https://gradesfixer.com/free-essay-examples/relational-database/> [Accessed 5 Aug. 2021].
Relational Database [Internet]. GradesFixer. 2018 Oct 26 [cited 2021 Aug 5]. Available from: https://gradesfixer.com/free-essay-examples/relational-database/
copy to clipboard
close

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

    By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.

    close

    Attention! This essay is not unique. You can get a 100% Plagiarism-FREE one in 30 sec

    Receive a 100% plagiarism-free essay on your email just for $4.99
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample
    close

    Sorry, we could not paraphrase this essay. Our professional writers can rewrite it and get you a unique paper.

    close

    Thanks!

    Your essay sample has been sent.

    Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

    thanks-icon Order now
    boy

    Hi there!

    Are you interested in getting a customized paper?

    Check it out!
    Having trouble finding the perfect essay? We’ve got you covered. Hire a writer
    exit-popup-close

    Haven't found the right essay?

    Get an expert to write you the one you need!

    exit-popup-print

    Professional writers and researchers

    exit-popup-quotes

    Sources and citation are provided

    exit-popup-clock

    3 hour delivery

    exit-popup-persone