The DreamHome case study

  Create a conceptual data model for the Branch user views of DreamHome documented in Appendix A. Compare your ER diagram with Figure 13.8 of the textbok and justify any differences found. Analyze the DreamHome case study and examine if there are situations that call for enhanced modeling. Present the enhanced data model of the case. Exercise 2 Answer the following questions with reference to how the ER model in Figure 17.13 maps of the book to relational tables. (a) How many relations will represent the ER model? (b) How many foreign keys are mapped to the relation representing X? (c) Which relation(s) will have no foreign key?