Group_Activity_1_DataModel_Scenarios - Group Activity #1...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Group Activity #1 DUE DATE : Tuesday, 3/1/2011 Instructions : As we saw in chapter 4 of our textbook and with our hands-on practice using MS Access 2007, entity- relationship diagrams are a key step in building any database. Without a solid understanding of the entities, attributes of each entity, and relationships between entities, building a functional database that effectively solves the business problem becomes extremely difficult. Modeling data can also be a difficult concept to understand without a lot of practice. As such, each group will be tasked with creating an entity-relationship diagram for their assigned topic. Each group (and individual members) will be evaluated as follows: 15 points : The entity relationship (ER) diagram must be created using PowerPoint and turned in via hard-copy or via email by the due date. Use the examples from chapter 4, the in-class lecture, and from the in-class net lab as guides. Your ER diagram should be normalized, should have proper relationships between the entities, should show that you know how to solve a many-to-many relationship (if applicable to your business scenario) and should demonstrate that you have an understanding of the data needs for your assigned problem. Each group will also create a list of five questions (possible queries) that your data model has the capability to address. For example, if I am building an order fulfillment database (as in your NetLab assignment), the data model offers the capability (if implemented correctly) to answer questions such as “how many orders is employee Tom Mattson responsible for fulfilling and is he behind schedule on any of those orders?” The final deliverable should be a two slide PowerPoint presentation with the first slide containing your ER diagram and the second slide containing the five questions that your model can answer. HINT : Think about the steps we outlined in class to build entity relationship diagrams. Step 1: Identify the Entities
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Group_Activity_1_DataModel_Scenarios - Group Activity #1...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online