Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 2 (30 points) A NEW HOME database is required to maintain information regarding new home builders and the models that they offer at varies
Problem 2 (30 points) A NEW HOME database is required to maintain information regarding new home builders and the models that they offer at varies subdivisions. A homebuilder may offer the same model at more than one subdivision, and the price that they offer a model may be different at each subdivision. Each subdivision has lots that are identified by a lot number. Each lot has an associated street address, size in square feet and possibly an additional premium for that lot. A premium is usually assessed if the lot is larger than the average lot or is on a cul de sac or corner within the subdivision. When a lot is sold, there is a homebuilder's model associated with the sale. The status of the sale is also recorded. Generalize some assumptions based on the high-level introduction to the NEW HOME enterprise so that you can design an ER-model according those assumptions. Assume the following based on the high-level introduction to the NEW HOME enterprise: The characteristics of a homebuilder include a unique identification number, a name, and an address and phone number for the headquarters of that homebuilder. wn into the street address, city, and zip code. The sate is not recorded in this enterprise, since the state is assumed. A homebuilder offers several models. The characteristics of a model include an identification number for the model that is unique for its homebuilder. A model also has a name and square footage. Whether the model is a single story or two story home is also recorded. A model may be offered at various subdivisions. The price that a model is offered at a given subdivision is recorded. The characteristics of a subdivision include its name, which is assumed to be unique, and the city and zip code where the subdivision is located. The state is assumed to be local to the enterprise. The characteristics of a lot include a lot number that is only unique for its subdivision. Each lot has an associated street address, size in square footage, and a possible premium. A sold lot has a particular homebuilder's model associated with it. The status of the sale indicates whether the house construction is pending or completed. Draw an ER diagram for the New Home database. Specify key attributes of each entity type and structural constraints on each relationship type. Specify any additional assumptions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started