CS 701 Programming Project
1. Design and implement a database (with more than 3 tables) for an application of
your choice.
2. Design aset of transactions which are meaningful for your database and application.
The minimum number of transactions is 3. Each transaction can be implemented in
C, C++, Visual Basic, Java,orany other high-levellanguage that can embed SQL
statements.
3. An example of embedding SQL queries in MS Access Basic is available at
http://www.cs.wright.edu/˜schung/cs701.htm
4. Run the transactions and print the results.
5. Your final report should include the followings:
•ERdiagram and Relational schema of your database.
•Printout of the content of data tables
•Description of your transactions, including the input data, output
data, functionality,etc.
•Printout of the transaction programs.
•Printout of the transaction results.
•Discussion. Discussion can include your comments on the design and
implementation, performance and functionality of the DBMS, future topics, etc.