School System registration process

Question

CIST2932 Project 4

Project Overview: Create an interactive application that will update at least a two-file database and demonstrate referential integrity. This application has to relate to a School Systems registration process.
There will be two parts to this project – the wright up and the actual application.

Part I
The Write Up
1. Create at least a 300 word problem document of a problem a school system is having. This document will also have the request presented to you as an analyst/programmer to solve the problem. EX:: School registration, Keeping track of Grades, Building Maintenance, Tracking school inventory - etc etc etc.
2. A 300 word solution document on why you came up with your tables and fields in the database, why did you pick the programming language and describe the application to be written. You will need to show the tables and fields and how the tables relate to each other.
3. Have a 5 to 10 minute presentation on the above. To be presented to class and turned in as indicated in the syllabus. Use PowerPoint to assist.

Part II
The Application
The following are Required aspects of the application. This again will be turned in as indicated in the syllabus and possibly presented to the class.

1) The application must be written in Visual Basic, C++, C#, JAVA, or PHP.
2) You will have at least a two-file database must have a one-to-many relationship (parent ? child)
3) The program must include options to add, delete, modify, and view rows for
tables. Review rubrics for exact detail.
4) Your two-file database design must be in “best normal form” and must be approved by
Mr. Lerch prior to writing your application.
5) Database integrity rules, including referential integrity, must be followed and included
at the application level (as seen by requirements in the rubric). See the document titled “Maintaining Data Integrity. When Updating a Two-File One-to-Many Database”.
6) All interfaces, screens, forms should be attractive and easy to use