Server support referential integrity relational database consisting of separate tables that can be combined on the basis of general information Consider the following example : the database contains a table of customers and orders table that are associated customer number field contained in both tables as shown by Dell Computer Repairs Sydney.
Since there may be more than one order per customer, value tables – one -to-many. When tables are connected, the customer table is the parent, and the orders table – a subsidiary. If the parent record is deleted, and its corresponding child records – no, we say that the children of the orphaned. Referential integrity means that none of the table are not allowed entry, orphans. Recording can be orphaned in three ways
