50 pts - System A&D Quiz 6
Visit this course in D2L and complete quiz SADCh06 by the due date / time for this assignment. This quiz takes its questions from Chapter 6 System Analysis & Design and will be a subset of questions in Chapter 6 Quiz Study Guide.
25 pts - Document data relationships
Ref: (Video) ERD Mechanics in Visio
Complete all three parts of SAD Ch06 Exercise 3 by creating Crow's Feet diagrams which show both minimum and maximum cardinality in a Visio document you name Ch06Ex03.vsdx. All three relationships can appear on one tab of the Visio document and use a text box inserted near each diagram to answer whether (and why) the relationship is identifying or non-identifying. Some clarifying errata for completing the diagrams:
Attach the completed Visio document to this assignment in D2L.
25 pts - Develop ERD Documentation
Complete your choice of two of Exercise 4.1 thru Exercise 4.4 from SAD Chapter 6 by completing Crow's Feet ERD's in Visio. Each ERD should be on a separate tab named for the exercise part (e.g., 4.1, 4.2, 4.3, or 4.4); name the completed Visio file ERDDoc.vsdx and attach it to this assignment in D2L.
25 pts - Data Normalization
Ref: (Video) Data Normalization Intro
Use Visio to prepare a third normal form Crow's Foot entity-relationship diagram for Your Turn: 6A-1 Normalizing a Student Activity File from SAD Ch06. You do not need to show -- as the exercise suggests -- how the logical data model would change as you move from 1NF to 2NF to 3NF, just create a 3NF relation. Note that the exercise shows exactly three activities for a student but this was a way to suggest that a student can in general be involved in zero or many activities. Name your document Ch06A-1.vsdx and attach a copy to this assignment in D2L.