Phase+4

>> Primary Key (player_id) >> no attributes should be NULL >> Primary Key (G_ID) >> Foreign Key (PlayedBy) References Player (player_id) >> no attributes should be NULL >> Primary Key (GP_ID) >> Foreign Key (UsedIn) References Game (GP_ID) >> no attributes should be NULL >> Primary Key (GP_ID) >> no attributes should be NULL >> Primary Key (GP_ID) >> no attributes should be NULL >> Primary Key (GP_ID) >> no attributes should be NULL >> Primary Key (GP_ID) >> Target can be NULL >> Primary Key (Missile) References Game (GP_ID) >> Foreign Key (Target) References Game (GP_ID) >> no attributes should be NULL
 * relational schema (Bill)
 * Player (player_name, player_id)
 * Game(__G_ID__,final score, runtime,version,PlayedBy)
 * GamePeace(__GP_ID__,Name,build time, death time,UsedIn)
 * Ship(GP_ID,kills)
 * Enemy(GP_ID,level)
 * Weapon(GP_ID,level)
 * Missile(GP_ID,damage,Target)
 * Hits(Missile,Target)
 * defined interfaces (Chris)
 * We will interface with the database through a webpage. A very simple example would be []
 * This webpage sends the query string to a CGI script (written in perl) that makes a connection with my oracle database and sends it the inputted query string.
 * Use the query string "SELECT COUNT(*) FROM AAPL" to see it return something.
 * This test page will be enhanced to include a variety of pre-made sql queries, that we developers, can use to extract meaningful sets of data.
 * The pre-made queries would pertain to game balance (e.g. compare the scores of players between different versions of the game or show the progression of players over time (do they get better the more they play)).
 * The output from the queries will also be represented graphically.
 * I'm looking into free web graphing tools. This [|http://www.fusioncharts.com] looks promising.
 *  assignment to individual team members (Bill)
 * Bill
 * flash game
 * Chris
 * data base interface
 * Xinyi
 * data base skeleton
 * testing structure
 * testing plan (Xinyi)
 * create database DataCraft

>> Player_name Char(20) not null, >> Player_ID int (5) not null, >> Primary Key (player_id)); >> G_ID int(5) not null, >> Final_score int(6) not null, >> Runtime Datetime not null, >> Version Char (10) not null, >> Played_By in(5) not null, >> Primary Key (G_ID), >> Foreign Key (Played_By) References Player (player_id)); >> >> GP_ID int(5) not null, >> GP_name Char(10) not null, >> Build_time Datetime not null, >> Dead_time Datetime not null, >> Used_in int(5) not null, >> Primary Key (GP_ID), >> Foreign Key (UsedIn) References Game (GP_ID));
 * create table Player(
 * Create table Game(
 * Create table GamePiece(

>> GP_ID int(5) not null, >> Kills int(5) not null, >> Primary Key (GP_ID), >> Foreign Key (GP_ID) references Gamepiece(GP_ID)); >> >> GP_ID int (5) not null, >> E_Level int(2) not null, >> Primary Key (GP_ID), >> Foreign Key (GP_ID) references Gamepiece(GP_ID)); >> >> GP_ID int (5) not null, >> W_Level int(2) not null, >> Primary Key (GP_ID), >> Foreign Key (GP_ID) references Gamepiece(GP_ID));
 * Create table Ship(
 * Create table Enemy(
 * Create table Weapon(

>> GP_ID int (5) not null, >> Damage int(3) not null, >> Primary Key (GP_ID), >> Foreign Key (GP_ID) references Gamepiece(GP_ID)); >> >> Missle in(5) not null, >> Taget in(5) not null, >> Primary Key (Missile) References Game (GP_ID), >> Foreign Key (Target) References Game (GP_ID) <span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">);
 * <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 14pt; line-height: normal; margin: 0cm 0cm 0pt; vertical-align: baseline;">Create table Missle(
 * <span style="color: black; font-family: Calibri; font-size: 14pt; line-height: normal; vertical-align: baseline;"><span style="font-family: 'Arial','sans-serif'; margin: 0cm 0cm 0pt;">Create table Hits(

create table owning( 2 missile int not null, 3 owner int not null, 4 primary key (missile), 5 foreign key (missile) references Gamepiece(gp_id), 6 foreign key (owner) references gamepiece(gp_id));

<span style="color: black; font-family: Calibri; font-size: 14pt; line-height: normal; vertical-align: baseline;">project plan indicating task status (all)
 * <span style="color: black; font-family: Calibri; font-size: 14pt; line-height: normal; vertical-align: baseline;">Chris
 * Piping queries from a webpage to my oracle database (100%)
 * Parsing an XML query from the flash game and storing the data into the database (0%)
 * Pre-made queries (0%)
 * Graphical presentation (2%)
 * In the process of investigating fusioncharts. Will try to make a simple graph asap to see if it is reasonable.
 * Bill
 * Working on flash game of the project (20%)
 * sending data into an XML format for database use (0%)
 * general wiki management (ongoing)
 * <span style="color: black; font-family: Calibri; font-size: 14pt; line-height: normal; vertical-align: baseline;">Xinyi
 * <span style="color: black; font-family: Calibri; font-size: 14pt; line-height: normal; vertical-align: baseline;">database creating (100%)