Assignment:
Term Project
In project, you are asked to choose a business domain with moderate complexity (i.e. at least 20 tables and at least 5 forms) and develop a database system for the chosen domain. You are encouraged to talk with people in the industry about their business problems related to database, and to come up with solutions to their problems. Some sample options are:
• Medical record-keeping for an outpatient clinic
• Video-store member and inventory database
• Department store employee and inventory database
• Real estate management
• Or any your own ideas
The term project is the "cap-stone" for the course. The database you will design should be viewed as a prototype database application. As such you are not expected to develop a fully functional system that can be installed 'as is' at some business, company or organization.
However, it is intended to provide you with valuable hands on experience in designing and implementing a real world DBMS application, and as such, your project should apply most of the issues and concepts covered during the quarter. The projects can be done in groups of 5 students. Your database must have at least 20 tables, and at least 5 forms. Perhaps the most important thing to remember is that this is a unique opportunity for you to demonstrate and explain concepts