Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Please answer in 300 to 500 word for the below questions .(Object oriented analy

ID: 3818440 • Letter: P

Question

Please answer in 300 to 500 word for the below questions .(Object oriented analysis and design)
1)Design is a model-driven activity that aims to arrive at the specifications of the solution.? And 2)Logical modeling represents the solution without reference to a specific technology.
Physical modeling maps the logical modeling to specific technologies. Please answer in 300 to 500 word for the below questions .(Object oriented analysis and design)
1)Design is a model-driven activity that aims to arrive at the specifications of the solution.? And 2)Logical modeling represents the solution without reference to a specific technology.
Physical modeling maps the logical modeling to specific technologies. Please answer in 300 to 500 word for the below questions .(Object oriented analysis and design)
1)Design is a model-driven activity that aims to arrive at the specifications of the solution.? And 2)Logical modeling represents the solution without reference to a specific technology.
Physical modeling maps the logical modeling to specific technologies.

Explanation / Answer

1. Using a model in your software development approach does not mean you are doing Model-Driven Development. The key concepts of MDD are abstraction and automation. The model of a software application is defined on a higher abstraction level (than 3GL languages) and this model is converted into a working application using automated transformation or interpretation.

One of the main aims of the MDA is to separate design from architecture and realization technologies facilitating that design and architecture can alter independently. The design addresses the functional (use case) requirements while architecture provides the infrastructure through which non-functional requirements like scalability, reliability and performance are realized. MDA envisages that the platform independent model (PIM), which represents a conceptual design realizing the functional requirements, will survive changes in realization technologies and software architectures.

2.

When a data modeler works with the client, his title may be a logical data modeler or a physical data modeler or combination of both. A logical data modeler designs the data model to suit business requirements, creates and maintains the lookup data, compares the versions of data model, maintains change log, generate reports from data model and whereas a physical data modeler has to know about the source and target databases properties.

A physical data modeler should know the technical-know-how to create data models from existing databases and to tune the data models with referential integrity, alternate keys, indexes and howto match indexes to SQL code. It would be good if the physical data modeler knows about replication, clustering and so on.

The differences between a logical data model and physical data model is shown below.

Represents business information and defines business rules

Represents the physical implementation of the model in a database.

Entity

Table

Column

Primary Key

Primary Key Constraint

Alternate Key

Unique Constraint or Unique Index

Inversion Key Entry

Non Unique Index

Rule

Check Constraint, Default Value

Relationship

Foreign Key

Logicl Data Model Physical Data Model

Represents business information and defines business rules

Represents the physical implementation of the model in a database.

Entity

Table

Attribute

Column

Primary Key

Primary Key Constraint

Alternate Key

Unique Constraint or Unique Index

Inversion Key Entry

Non Unique Index

Rule

Check Constraint, Default Value

Relationship

Foreign Key