Schedule+-+Fall+2017

= Fall 2017 Class Schedule = ||  ||   || ||   ||   || System Documentation || Model Assignment #1 || 10/05/2017 ||
 * ~ Date ||~ Chapter ||~ Coverage ||~ Assignment ||~ Due Date ||
 * 08/24/2017 ||< Introduction & Chapters 1 & 2 ||  ||   ||   ||
 * **08/31/2017** ||< **No Class** || Football Game - Campus is closed - so stupid!!!! ||  ||   ||
 * **09/07/2017** ||< **No Class** || IRMA ||  ||   ||
 * **09/14/2017** ||< **No Class** ||<
 * **09/21/2017** ||< **No Class** ||<
 * 09/28/2017 ||< Chapter 3 ||<
 * 10/05/2017 ||< DFD || In Class DFD || Depending on the first letter of your last name complete Problem **7** (A-L), or Problem **5** (M-Z) in Chapter 3 of your textbook.

For all problems first prepare an Entities and Activities table then proceed with the problem preparing a //context-level DFD// and a //Level-0 DFD//. When finished submit your file(s) in either .pdf or .jpg format via WebCourses. || 10/12/2017 || After completing your database, please upload just the database file.. || 10/26/2017 || If you did #3 or #4 for the REA assignment prepare an integrated REA for Sue's Gallery.
 * 10/12/2017 ||< FlowCharts || In Class Flowchart || Complete the Flowchart (be sure to prepare the document flowchart asked for in the problem), from assignment #2. When finished submit your file(s) in either .pdf or .jpg format via WebCourses2 (Canvas). || 10/19/2017 ||
 * 10/19/2017 ||< Chapter 4 || Relational Databases/Queries || Complete Problem 3 in chapter 4, For requirements a-c your design should be similar to Table 5. If you don't have Access you can use it via @http://apps.ucf.eduYou are required to do A-F. You need to have at least 3 queries: 1) Simple with fields from 1 table; 2) Simple with fields from 2 or more tables; 3) a query that contains a calculation.
 * **10/24/2017** || **Exam 1** || Chapters 1 - 3, DFD's and Flowcharts ||  ||   ||
 * 10/26/2017 ||< Chapter 5 || The REA Data Model || Depending on the first letter of your last name complete Problem 3 (A-F), Problem 1 (G-L), Problem 4 (M-R), or Problem 2 (S-Z) from chapter 5. Use draw.io to create your REA diagram || 11/02/2017 ||
 * 11/02/2017 ||< Chapter 6 || Implementing an REA Data Model || If you did problem #1 or #2 for the REA assignment prepare an integrated REA for Joe's Ice Cream.

Use the solutions provided for Joe's Ice Cram Revenue & Expenditure Cycles (1 & 2) or Sue's Gallery (3 & 4) from chapter 5 if needed.

Prepare a table listing the relational database based on your integrated REA. The table should include the table names, primary keys, foreign keys and non-key attributes. For your table of primary/foreign keys use Word (or other word processing program to build a table). You do NOT need to create tables using Access for this assignment. || 11/09/2017 ||
 * 11/09/2017 ||< Tableau || Intro and Charts || Chart Assignments || 11/16/2017 ||
 * **11/14/2017** || **Exam 2** || **Chapter 4, 5 and 6** ||  ||   ||
 * 11/16/2017 ||< Tableau || Calculations and Table Calculations || Table Calculation Assignment || 11/23/2017 ||
 * **11/23/2017** ||< **No Class** || Turkey Day ||  ||   ||
 * 11/30/2017 ||< Tableau || Dirty Data and Interactive Dashboards ||  || 12/04/2017**(Note This is a Monday)** ||
 * 12/06/2017 to 12/07/2017 ||< **Tableau Exam** || Exam is available from 7:00 AM to 5:00 PM ||  ||   ||