Relational Database: [Essay Example], 607 words GradesFixer
exit-popup-close

Haven't found the right essay?

Get an expert to write your essay!

exit-popup-print

Professional writers and researchers

exit-popup-quotes

Sources and citation are provided

exit-popup-clock

3 hour delivery

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

Relational Database

Download Print

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.

Remember: 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 November 28, 2020, 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 28 Nov. 2020].
Relational Database [Internet]. GradesFixer. 2018 Oct 26 [cited 2020 Nov 28]. 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 100% plagiarism FREE essay in 30sec

    Recieve 100% plagiarism-Free paper just for 4.99$ on email
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample
    close

    Sorry, we cannot unicalize this essay. You can order Unique paper and our professionals Rewrite it for you

    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

    GradesFixer.com uses cookies. By continuing we’ll assume you board with our cookie policy.