| 1/18/99 |
Set Up Web Site and published Personal and
Computer experience. |
| 1/25/99 |
Defined the Purpose of the Cinclant Fleet JTF 105
Navy Reserve Unit database requirements |
| 2/2/99 |
Finished Database requirement Document, Data
Dictionary and ER Diagram |
| 2/9/99 |
Reworked and fleshed out the text of the Design
of the Database. NOT COMPLETE . ER Diagram must be combined with the table from the
previous section to provide a graphical representation of the tables attributes and the
relations. |
| 2/17/99 |
Finally able to create and post graphics.
First is the bubble chart for the design. Working on the SQL implimentation
for unit department and member tables. |
| 2/23/99 |
Worked on revising SQL code. Just trying
adding one table at a time then adding data to the table, and using Describe to view the
results. Found many typos with the Help of Dr. Levin and Pat Wilson. |
| 3/2/99 |
Revised the SQL code on Oracle. Got Tables to
load and data to populate. Did not complete the OO ER diagram but skipped to the PC
implimentation using MS ACCESS ( Wow! what a difference) |
| 3/9/99 |
Gave up on all past attempts with Graphics for
Design charts (other than ERWin which works well). Installed Visio Enterprise and am
very happy with the results. A lot of time has to be spent to redraw and convert the
files, but they Save Directly as .gifs Did more research on OO design and philosphy.
Still somewhat foggy on the details but understand the "Big Picture".
Had major user account hassle trying to get extra web space. Only recieved
extra one meg today! Will have to be very careful on the ammount of
screenshots and charts I post. The Bubble Chart itself is 98k in order to read the
Text.
Must Execute new SQL code in small sections create single tables and populate one at a
time. Then will capture a few query results to repost.
Not much progress on the Special Project - Web based Access for Relational
Databases. Must try to finish this weekend. |
| 3/11/99 |
Uploaded the new Visio Graphics. MUST
REVISE the ERWin CASE model and data dictionary to reflect the changes in the Database
Design. |
| 3/15/99 |
Updated the ER Design. Added a new Table
(ITPLINEITEMS) after redoing the Design Diagrams and posting them. The new ER
diagram also indicates the relationships between the Entities. Made first
Successful Queries off of the Oracle DBMS Today! Only able to get two complete
tables populated, UNIT and DEPARTMENT. The queries cant get much more complicated until I
can get the MEMBER and DRILLS tables to load and populate.
Uploaded the Object Oriented Class Diagram today. |
|
|
|
|
