answersLogoWhite

0


Best Answer

Yes, a Database Management System's main advantage is that it will enforce relationships between tables in a database preventing you from entering data in one field in another table that does not already exist in another table. So for example if you have a database that tracks online purchase, the DBMS would prevent a product that does not already exist in the Products table from being added to a shopping cart table. Or an employee ID from being added to a timecard table that does not already exist in the employee table. Databases can be setup without enforced relationships, but doing so usually results in orphaned records (for instance, where and employee id exists in the timecard table that does not exist in the employee table.)

User Avatar

Wiki User

โˆ™ 2008-02-02 21:33:23
This answer is:
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
User Avatar

Add your answer:

Earn +20 pts
Q: Can you make a relationship between two tables in a Database Management System DBMS?
Write your answer...
Submit
Related questions

What is DBMS relationship?

1.what is a Relationship in database management system?


Four differences between fileprocessing system and database management system?

four differences between fileprocessing system and 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 a Relational Database Management System?

It is a data base that have relationships ie:: what is relationship between two objects


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.


What are relationship between information system lifecycle and the database system development lifecycle?

The relationship between the information system life cycle and the database system development life cycle is that the informational systems help management entities to shift and move resources from one department to another easily by using a shared database system.


About oracle database management system?

database management is a system


Differences between relational database management system and database management system?

hi so did u actually figure out some thing!


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.


Difference between fileprocessing system and dbms?

what is the differeces between fileprocessing system and database management system


How does a DBMS differ from RDBMS?

A database is to store data efficiently. DBMS is Database management system and RDBMS is Relational database management system which gives relation between every table. It (RDBMS) also follows codds rules.


Functions of a typical database management system?

Functions of a typical database management system?


Difference between management system and management information system?

Management system is usually referring to Operations, MIS is usually computer or database specific


What is the difference between data base system and a database management system?

database system is organized collection of data.data base management is a software and ti controls the data in a data base.


What is the difference between dbms and mdbms?

dbms stands for database management system and this mdbms is mulivalue database management system. if we need to store the a multidata then we have to use the mdbms


Relationship of Microsoft access to dbms?

Relationship of Microsoft access to dbms


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.


What is the Comparative study between traditional data management system and database management system?

The difference between management and comparative is that one is about sex and the other is about touching up lovers


What is a database or database management?

We use database to store the data in it. But only storing data is not sufficient . To manage the data in the database database management system is required.The database is the collection of records that are somehow related to each other. Database management is the management of that data in the database.


what are the relationship between the information system lifecycle and database system development lifecycle.?

Information system involves the entire design and database system is part of this design so database system development lifecycle is shorter.


What is differences between dbms and rdbms?

DBMS stands for "Database Management Systems" it includes all Databases. RDBMS are a special Type of DMBS. "Relational Database Management Systems". On RDBMS you have Tables. Some Tables have are in relation to other Tables. This is needed to organize complex Data. Systems like MySQL, MS Access or MS SQLServer are RDBMS. Other Types are: ODBMS - Object Database Management System ORDBMS - Object Relational Database Management System HDBMS - Hirarchical Database Management System NDBMS - Network Database Management System


What is the difference between data base and Database management system?

database is a collection of related data in any size and in any complexity whereas database management system is software for defining, constructing and manipulating databases for various reasons.


What is the difference between database system and database management system?

data is like the files that are put on table .while data base system is a system which is base on data and query.