Describe object-relational mapping. What are the steps and what is the major difference between relational modeling and a pure object-oriented database?
What will be an ideal response?
In object-relational mapping we use a software layer that mediates between object-oriented languages and relational DBMSs. Mapping to a relational database is the application of relational and normalization rules to classes and their relationships.
The following are the general steps that should be followed to transform an object-oriented model into a relational one. Entity classes form the majority of tables. Class attributes become table attributes (or columns). A table must have a primary key. Repeating attributes must be separated into tables. Associations are mapped by a primary-foreign key pairs. Multiplicity is mapped through foreign keys. To map to a relational database, aggregation must be flattened into association. In the inheritance chain, only classes with non-derived attributes are selected for mapping.
The major difference is that object-oriented model allows repeating attributes and the relational model does not.
You might also like to view...
Located in The Hague, the International Court of Justice (ICJ) is the judicial arm of the:
A) United States. B) European Union. C) United Nations. D) Netherlands. E) United Kingdom.
Answer the following statements true (T) or false (F)
1. People with a low tolerance for ambiguity and an orientation toward task and technical concerns in making decisions have an analytical decision-making style. 2. A person with a directive decision style is efficient, logical, practical, and systematic in her approach to solving problems. 3. A directive individual takes longer to make a decision than an analytical one. 4. The conceptual style of decision making is the most people oriented of the styles.
Marketers can gather market feedback on the effectiveness of direct marketing efforts by
measuring response rates with different tactics. Indicate whether the statement is true or false
Belgium has been noted to have adequate legislation with respect to racial and ethnic discrimination, Yet the UN Committee on the Elimination of Racial Discrimination in its March 2002 meeting expressed concern in regards to Belgium. What was the committee concerned about?
a. Expiring legislation leaving many citizens unprotected from harassment b. Difficult access of ethnic minorities to housing and employment c. The legislation did not cover protections for sexual orientation d. There was weak enforcement of existing legislation