Data modeling with powerpoint
use the case information in the attached “requirements document” to create a correct Entity Relationship Diagram of the “CTC” business (see the requirements document for all assignment and submission details).
Using the attached “starting point” PowerPoint template as a starting point, completely and correctly specify all Entities, Relationships and Attributes as described in the lecture and lab materials on Entity Relationship Diagramming.
Include all relevant facts from the case into the model, including primary keys, volume estimates, data-types for all fields, descriptive labels on relationships, and italicization of foreign key fields. There is no need to create or assume any new business entities or attributes other than those required for the case. Your final model should have exactly NINE entities and, if printed (not required), should fit on ONE 8.5” x 11” page.
NOTE: In the “starting point” diagram, the number of lines with ‘x’s indicates the total number of expected attributes (including all primary and foreign keys). For best results, do not re-arrange or re-organize the provided template.
