answersLogoWhite

0

A Database Management System or DBMS is compromised of many related tables of data. Tables are simply two dimentional (rows and columns) of data, similar to a spreadsheet. Joins are used to combine tables of data based on related columns within those tables. By using JOINS, a database becomes multi-dementional. Joins are simply a structured way to combine related data in different tables within the database system.

Example an employee table might contain the following fields:

EmployeeID (the Primary Key)

LastName,

FirstName,

MiddleName,

HireDate,

DepartmentID (a foreign key to the Department table)

Manager_EmployeeID (a foreign key relating back to a different employee record in the employee table)

Department Table:

DepartmentID,

DepartmentName,

DepartmentManager_EmployeeID (Foriegn Key relating to the employee table)

In the Employee sample table, the EmployeeID serves as the primary key, which uniquely identifies the entire row of data. Joins for the Employee table would typically be done on related tables, such as the Department table via the DepartmentID, or even back on the Employee table itself using the Manager_EmployeeID, relating the EmployeeID to the Manager_EmployeeID. If the EmployeeID is in another table as a foreign key then joins can also be done to those tables as well.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Why do Database Management is related to MS Access?

Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.


About oracle database management system?

database management is a system


What is a database management system?

Database management system is a software system that creates,expands and maintains the database.


Are database and database management system identical?

No. Database is a data itself, organized according to rules of database management system. And Database Management System is a software used to organize a database, and to acces it too.


Functions of a typical database management system?

Functions of a typical database management system?


What are the differences between database management system Vs relational dbms?

the database management system analysis the data or record but relational database management system links the database to each other.


What is full form of rdbms?

Relational Database Management System Relational Database Management System


Is a database and a database management system the same why why not?

A database is a collection of data. A database management system controls how those data are collected, stored and retrieved.


Four differences between fileprocessing system and database management system?

four differences between fileprocessing system and database management system


What do you means DataBase Management System?

A system that allows you maintain and administer a database.


History of database management system?

top 10 significant people,event,history development in database management system


What are the main functions of a database management system?

create the database

Trending Questions
What is vision statement for oracle? What is System for Award Management (SAM)? WHAT IS THE BEST WAY TO OVERCOME IMAGINED RISK? Why is standardization and quality control difficult to manage throughout the service delivery process? What are the advantages and problems this tripartite model of the executive office might have brought about had it been adopted? What are the 3 reasons why we study Operations Management? What are the three primary characteristics of a stakeholder? What is the function of production department? Management by exception? What factors can cause established controls to lose effectiveness? What should an information system achieve for an organization in order for it to be considered a strategic information system? What are content management systems typically used for? What are the key differences between project management and process management, and how do these differences impact the overall success of a project? Why did vertical integration increase the power of corporations? The role of the social or people-oriented leader is to a. Earn a profit b. Reduce tension and boost morale c. Lead by working hard d. None of the above? What approach should an organization adopt for managing uncertainty in a simple and dynamic environment? what is the salary for business administration? Who has the best project management certificate program? What are the primary functions of a strategic leader in an organization? What are examples of principle of fayol's unity of command?