Use an example to explain the difference between a logical process models and physical process models.
Logical model portrays your model elements and how they identify with one another. A physical model depicts every entity in point of interest, including data about how you would actualize the model utilizing a specific item. In a logical model portraying a man in a family tree, every individual node would have attributes, for example, name, date of birth, spot of birth, and so forth. The logical chart would likewise demonstrate unique attribute or blend of attributes called a primary key that depicts precisely one section inside of this entity. The physical model for the person would contain implementation details. These details are things like data types, indexes, constraints, etc. The physical model for the individual would contain usage subtle elements. These points of interest are things like data types, indexes, constraints and so forth.
A wealthy businessman owns a large number of paintings that he loans to museums all over the world. He is interested in setting up a system that records what he loans to whom so that he does not lose track of his investments. He would like to keep information about the paintings that he owns as well as the artists who painted them. He also wants to track the various museums that reserve his art, along with the actual reservations. Obviously, artists are associated with paintings, paintings are associated with reservations, and reservations are associated with museums.
a. Which four entities would belong on this data model?
An Entity can be any article, place, individual or class. In E-R Diagram, an entity is spoken to utilizing rectangles. Consider a sample of an association. Worker, chief, division, item and numerous more can be taken as elements from an association.
4 entities are:
1) Artist
2) Paintings
3) Reservations
4) Museums
b. Which are some of the basic attributes for each entity?
Basic