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...
Activity-based management is not suitable for service companies as it deals with the proper allocation of manufacturing overhead costs
Indicate whether the statement is true or false
Most messages merely present one or more positive attributes about a product or reasons to buy it. Which of the following best describes this approach to communicating a message?
A) Supportive arguments B) Two-sided message C) Refutational arguments D) Reporting bias