Title: Child Cancer Disease Database

Final Project

DueDay 4 of Week 7

Any instructor feedback provided for assignments previously submittedwhen graded should be incorporated in the final submission.

See Final Project Rubric in the Syllabus area for point values.

The Final Paper will cover all the points noted below:

1. Describe your project.Create a list of questions to ask your teammates on their project - at least five. This will assist in flushing out the requirements for the next step.Full description of the project will be submitted as part of the Final Paper.

2. Project Description (Operational Narrative) definition:Explain the purpose of your system. Provide at least five business rules (constraints and requirements). These should be objective and measurable. Include at leave five deliverables from the system i.e. programs, screens, reports, queries and/or tables required.

3. Entity identification:Select at least five entities for the application.

4. ERD Creation: Create an ERD diagram using Visio with tables, keys, columns, relationships. Primary and Foreign keys need to be identified in this diagram.

5. Alternate keys:Identify at least five keys (not already listed as PK or FK) needed by end users. These indexes would be considered Alternate or Secondary keys and are mostly used for queries and quick reporting. They may contain multiple columns.

6. Data Dictionary: Take your two largest tables (in terms of columns) and create a data dictionary. Use appropriate data types and lengths for your attributes.

7. SQL Queries:Describe three SQL queries to provide information to the end users for this system. At least one must be a join. These can be real SQL statements or written in English.

8. Complex Transaction:Identify and describe one complex (more than one table) process that will need to be contained within one programming transaction. For instance, to create a new order you might need to update the customer, order, product and inventory tables. Another example would be keeping track of tutoring hours you would add hours to the table with a key of tutorid, studentid, dateTutored and potentially add the hours to the departmental expenses for accounting purposes.

9. XML Export: Create an XML export of two rows of data from one of your completed tables that has at least 4 columns.

10. Security:Demonstrate your understanding of CIA (confidentiality, data integrity and availability) by explaining how it will be applied to your application. This should one to two pages providing at least one example pertaining to each of the initials.