Installing Ruby on Rails

Just downloaded Ruby 1.8.5-24 and RubyGems 0.9.4 (Ruby package manager). Installation was pretty easy as I followed the instructions found here. I also installed the recommended editor Aptana RadRails.

Now just gotta figure out how it all works together...

Preliminary Database Design

Just spent a couple of hours with Marko doing a preliminary design of our database. Will look further into it and try to normalise it later on. Marko is meeting up with Rodica tomorrow to discuss about our computer/server arrangements. Most likely we'll be meeting up on Thursday to begin installation and configurations.

Database Design

User

Column Name	Data Type	Constraints
handle	varchar(10)	Primary Key
fname	varchar(15)	NOT NULL
lname	varchar(15)	NOT NULL
password	varchar(x)	NOT NULL
dob	date	NOT NULL

Transaction

Column Name	Data Type	Constraints
recipient	varchar(10)	Foreign Key
amount	money	NOT NULL, >= 0
receivedate	date	NOT NULL
source	varchar(20)	NOT NULL
revenuetype	varchar(30)	NOT NULL
paymenttype	varchar(10)	NOT NULL
transacttype	varchar(10)	NOT NULL

Loan

Column Name	Data Type	Constraints
debtor	varchar(10)	Foreign Key
principal	money	NOT NULL, > 0
interest	real	NOT NULL, > 0
lender	varchar(30)	NOT NULL
payfrequency	integer	NOT NULL, > 0

Tax

Column Name	Data Type	Constraints
recipient	varchar(10)	Foreign Key
income	money	NOT NULL
taxwitheld	money	NOT NULL
deductions	money	NOT NULL
carryforwardlosses	money	NOT NULL
taxableincome	money	NOT NULL
capitalgains	money	NOT NULL

Portfolio

Column Name	Data Type	Constraints
owner	varchar(10)	Foreign Key
tickersymbol	varchar(5)	NOT NULL
quantity	integer	NOT NULL
totalvalue	money	NOT NULL
company	varchar(30)	NOT NULL
securitytype	varchar(20)	NOT NULL

Thesis Planning

Marko and I have spent the last 4 hours this Sunday planning out our time schedule, project overview and work break down. Tomorrow we will be meeting Rodica to discuss computer/server arrangements so that we can start cracking.