What does it mean by related data in a database?

5 pts.
Tags:
Database
Relational databases
What does it mean by related data in a database?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Relational data is the key to a database.

It basically means that the data in one table relates to the data in another table.

In an HR database you’ve got two tables, Employee and Department.

<pre>CREATE TABLE Department
(DepartmentId INT,
DepartmentName varchar(50))

CREATE TABLE Employee
(EmployeeId INT,
FirstName varchar(50),
LastName varchar(50),
DepartmentId INT)</pre>

These tables are related to each other through the DepartmentId column in each table.

The first table is the MASTER and the second is the DETAIL table, it is important that the Department column to be unique (primary key) in the master table, for to have a clear one to many (or 0) relation between the records from the two tables.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    But do not forget that the term RELATIONAL (as in RDBMS) has nothing to do with the way data is related to other data. Steve -------------
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following