Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Whats the master / detail relationship in database?

user-image
Question added by Deleted user
Date Posted: 2014/07/19
Rami Nasr
by Rami Nasr , Analyst Programmer , AUC -The American University in Cairo -

Databases that are efficiently designed include multiple tables. The goal of table design is to store all the information you need in an accessible, efficient manner. Therefore, you want to break down a database into tables that identify the separate entities (such as persons, places, and things) and activities (such as events, transactions, and other occurrences) important to your application. To better define your tables, you need to identify and understand how they relate to each other. Creating several small tables and linking them together reduces the amount of redundant data, which in turn reduces potential errors and makes updating information easier.

 

http://techpubs.borland.com/books/jbuilder/jbuilder2/jbuilder/database/prov_masterdetail.html

João Nhimi
by João Nhimi , Manager , Sinceridade service

for more efficient database,

You need to determine the tables by categories, delimit the activities and determine the primary and foreign keys.

have more precision in the tables relate, depending on the degree of liability.

Muktar SayedSaleh
by Muktar SayedSaleh , Software Engineering Manager , AIRASIA

one to many relationshipexample:categories - > products relationship :)that's it !

More Questions Like This