What rules have to be enforced based on entity type

Assignment Help Database Management System

Reference no: EM1369523

There are many kinds of relationships in a design model of a database. The most common are one-to-one (1:1) and one-to-many (1:N) and many-to-many (N:M). Some of the entity types can be ID-Dependent, Strong, Weak, or Subtype Entities.

1. Why is it important to classify each of these types in an ERD Model?

2. What rules would have to be enforced based on the entity type? Pick one entity type and discuss what enforcement is needed by the database or application.

Reference no: EM1369523

Questions Cloud

Explain what factors should be considered in price setting : Explain What factors should be considered in price setting and Which of these factors is most important? Why and Why is adapting the price of a product important?

What is retained earnings : What is retained earnings. What items increase balance in retained earnings. What items decrease balance in retained earnings.

Elimination of an import quota : China's entry into World Trade Organization is likely to create more competition in local and foreign firms, as well as provide China greater access to the market of exports.

How demand curve facing in a perfectly competitive market : Demand curve facing a firm in a perfectly competitive market each firm is so small and re are so many firms that none can affect price.

What rules have to be enforced based on entity type : What rules would have to be enforced based on entity type? Choose one entity type and discuss what enforcement is needed by the database or application.

Explain what specific actionable recommendations : Explain What specific, actionable recommendations would you give for improving customer satisfaction for each company?

Calculate the price elasticity of demand : A major cereal manufacturer decides to lower prices from $3.60 to $3.00 per 15-ounce box. If quantity demanded increases by 18 percent, determine the price elasticity of demand?

How many standard errors it is away from zero : how many standard errors it is away from zero. If it is not very far from zero n we might ignore it; if it is far away from zero n we might consider it important. But how far is ‘far'.

If an economist refers to a lemons market what you infer : If an economist refers to a ‘lemons market,' what should you infer. A. She is referring to a market for fruit. B. She is referring to any market with asymmetric or hidden information.

User Account

All Pages