COSC 578 Database Management I
Instructor: Dr. Sung Hong
Project team members:
Francois Cressin
Akwasi Owusu
Andrew Chrismer
Chi Toung (CT) Yeung
For diagrams like Visio, try Best4C
September 29, 2007
ER Diagram
IDE: NetBeans 6.0 Beta 2
App: Java desktop with dialog GUI
DB: Oracle 9i
Date: 23Sept07
Note: First GUI implementation, Connection works and that's it.
Date: 12Nov07
Note: Update, Next, Previous and Create works for Employee, Administrator and
Customer
Need to work on Movie, Search Delete button, password control and debug
overall.
Date: 25Nov07
Note: Tables changed for Employee, Customer and related.
Update and streamline code overall.
Bug out on "Previous" and "Next".
Bug out on drop list box
Movie now loads upon connect, "Search", "clear", "new", "update", "next",
"previous" buttons works for all tabs
buttons in Admin work.
Password dialog box working
Need work on Customer register
Need work on Date fields
Date: 28Nov07
Note: See some problems with rental tables.
Mostly completed register portion for rental
However, need to verify copyid issue and time table issue
Working on an automatic load of rental record at LoadCustomerUI()
Date: 01Dec07
1st completion... need more thorough testing
Date: 01Dec07
Date: 01Dec07
Date: 02Dec07
Date: 02Dec07
Date: 02Dec07
Date: 02Dec07
Date: 02Dec07
1st: 27Aug07
mod: 01Dec07