Adding redundant associations for efficient access, Database Management System

Adding Redundant Associations for Efficient Access

Redundant associations do not add any type of information, therefore during design we should actually examine structure of object model for implementation and try to establish whether we could optimize critical parts of completed system. New associations can be added? Or old associations can be removed? The derived association does not require adding any information to the network, they help increasing model information in efficient mode.


Posted Date: 8/30/2013 1:33:38 AM | Location : United States

Related Discussions:- Adding redundant associations for efficient access, Assignment Help, Ask Question on Adding redundant associations for efficient access, Get Answer, Expert's Help, Adding redundant associations for efficient access Discussions

Write discussion on Adding redundant associations for efficient access
Your posts are moderated
Related Questions
explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base

it can be possible to create any table without primary key

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

What is the function of a Domain? A domain defines the technical settings of a table field. A domain describes a value range, which sets the permissible data values for the

How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information