Reference no: EM13772357
1) Define an ERD for the following narrative. The database should track homes and owners. A home has a unique home identifier, a street address, a city, a state, a zip code, a number of bedrooms, a number of bathrooms, and square feet. A home is either owner occupied or rented. An owner has a social security number, a name, an optional spouse name, a profession, and an optional spouse profession. An owner can possess one or more homes. Each home has only one owner.
2) Refine the ERD from problem 1 by adding an agent entity type. Agents represent owners in the sale of a home. An agent can list many homes, but only one agent can list a home. An agent has a unique agent identifier, a name, an office identifier, and a phone number. When an owner agrees to list a home with an agent, a commission (percentage of the sales price) and a selling price are determined.
3) In the ERD from problem 2, transform the attribute, office identifier, into an entity type. Data about an office include the phone number, the manager name, and the address.
4) In the ERD from problem 3, add a buyer entity type. A buyer entity type has a social security number, a name, a phone, preferences for the number of bedrooms and bathrooms, and a price rage. An agent can work with many buyers, but a buyer works with only one agent.
5) Refine the ERD from problem 4 with a generalization hierarchy to depict similarities between buyers and owners.
6) Revise the ERD from problem 5 by adding an offer entity type. A buyer makes an offer on a home for a specified sales price. The offer starts on the submission date and time and expires on the specified date and time. A unique offer number identifies an offer. A buyer can submit multiple offers for the same home.
|
Explain why oligopolists have an incentive to collude
: Explain why oligopolists have an incentive to collude or form a cartel and Explain why oligopolists in a collusive agreement might have an incentive to renege on such an agreement.
|
|
Analyze the roles and responsibilities of law enforcement
: Analyze the roles and responsibilities of law enforcement and the regulatory system, and determine which law enforcement office or regulatory agency is the most effective and which is the least effective
|
|
Fixed money growth rule
: We mentioned Milton Friedman's advice that central bankers should follow a "fixed money growth rule," where the broad money supply (M1 or M2) grows the same rate every year. What is the difference between a fixed money growth rule and nominal GDP tar..
|
|
Discuss the tactics of the prosecution
: From the e-Activity, provide a brief one or two (1 or 2) sentence summary of the crime you researched. Discuss the tactics of both the prosecution and the defense drawing on material from this week's readings
|
|
Define an erd for the narrative
: Define an ERD for the following narrative. The database should track homes and owners. A home has a unique home identifier, a street address, a city, a state, a zip code, a number of bedrooms, a number of bathrooms, and square feet. A home is eith..
|
|
To reduce the costs of revolving insurance disputes
: To reduce the costs of revolving insurance disputes, insurers have required that the customers use arbitration. Arbitrators are required to be knowledgeable about medicine and insurance contracts. Why might you participate that the arbitration mechan..
|
|
Importance of using interrogatories for personal injury case
: Explain the importance of using interrogatories for a personal injury case. Identify two (2) ways in which your supervising attorney could use the opposing party's responses to further her case. Provide a rationale for your response
|
|
Describe one literary element being used in the essay
: Describe one literary element being used in the essay. Explain why you think that literary element is used well by the writer.
|
|
Insurance coverage tend to increase rational ignorance
: Why are many consumers apt to be rationally ignorant about their options? Why would insurance coverage tend to increase rational ignorance? Why are so many economists opposed to licensure of medical facilities and personnel?
|