FINAL PROJECT FOR DATABASE COURSE

Use Visual C++ to create a screen that looks like the following:

Connect to a Lytec Database (or a medical database we create) and use this screen to extract data into a comma separated file with column headings for use in an Excel Spreadsheet.

Tasks to accomplish:

Project Plan (my job)

Complete written project specification

· User Manual (might skip)

· High Level Specification (for mythical client - including exactly which fields will be chosen for the output)

· Technical Coding Specification (for yourself or team member)

· UML documentation (need to determine which are most pertinent)

· Entity relationship diagram

Knowledge to acquire:

· What a database is

o How to use SQL commands to query data

o How to use MS SQL 2005 Express to run SQL commands

o Simple queries on other data

o Simple queries on Lytec data

o Queries using some of the fields on the final project

o The queries you will use to access the data for the final project

· How to connect the MS SQL manager to a Lytec database

· How to use Visual C++ 2008 Express to create a one screen application

· How to connect Visual C++ to the Lytec database

· How to embed the MS SQL commands into the Visual C++

· How to write an Entity Relationship Diagram

· How to write UML documentation

Additional knowledge needed:

Database creation

· Database normalization

· How to define tables and change their definition