IFS 320 - DATABASE MANAGEMENT SYSTEMS

POWERBUILDER PROJECT

• Verify that your tables have all FK constraints clearly defined, before you proceed with the project. If not, you can use PB datadministration painter to issue the necessary ALTER TABLE statements.
• Be able to add, delete, modify Patient,
• Be able to add, delete, modify Item,
• Prevent the table from containing any items that has a cost greater than $500,
• Be able to post charges to a patient.
• Prevent users from posting any charge greater than $1000 (total).
• Be able to delete or modify a charge only on the date charged but not on other dates.
• Provide a master detail window for Patient.
• Provide a window that will display all the charges for a given patient.
• Be able to generate a bill for a patient that will show all the items charged ordered by date and within each date ordered by item. The system should allow the users to view and print the bill simply by choosing a patient.
• Provide a window that will display all the charges and the patients who charged them for a given item.
• Make the application an MDI application.
• Include a Menu (of course, it is a must for an MDI application).
• Include proper error checking for all your codes.
• Follow guidelines for GUI design and naming conventions.
• Use many PB techniques (such as DDDW, one to Many window, and validation) to develop a production quality, user-friendly system.
• Facilitate users to view displays based on sorted order of critical fields or any field.

Be Ready to demonstrate the Project to me on or before April 29, 1997.

Please send your comments to: Raghavan