--- brodders@cwcom.net wrote:
HALLO THE GROUP
Ahem. Hi all..
After discovering the ALUG at the UEA last Sunday - I've been volunteered into getting something going for the O'Reilly books ALUG (via David) now hold. I wanted to borrow the book on MySQL and mSQL - so :) I have been asked to write a system.
Oh No!
Who me? Me Steve. Me much too much to do (tax, company returns, commuting, 2 houses to buy, holiday someday) but then I want to explore MySQL.
Yes you, and no we don't want any excuses or I will start moning about 2 college assignmenst and exam revision :o) but tonights module at college has been on Data Analysis and Database Design, something I seam to have a nack for, so here goes.
Two aspects -
- The System We Want
We've some books (6) a) do we want more? How will be get them? b) do we want to loan other resources (CD's, hardware etc)? c) do we want to loan private as well as ALUG stuff? (perhaps an option) d) do we want a central repository or do things wander around? e) Factor X - the unspoken expectation coming to haunt me later.
All the above shape how the database will be designed, data lifecycles & that sort of stuff. Ideas Appreciated, especially if they reduce work. [Only? :) ]
Systems analysis, good fun. the data base could do with the following tables.
user(member no., name, address, phone, email, homepage) resource(resource number, resource type, author, publish date, details, home location) loan(member no., resource number, start date, returned) -no primary key, member no. and resource number = composite ke
the first column is the primary key unless other wise mentioned. This isn't the greatest design nor is it the worst, but I'm doing it in my head and trying to normalise at the same time, which is difficult at this time of night, any query's drop me a line.
and as I feel in the mode the data types for the above are
user( member no. = integer, all other fields = text char(sensible number depending on field)) resource( resource number = integer, resource type = string, author = string, publish date = date, details = string, location = string) loan(member no. and resource number = foriegn keys - see relevent tables for type, start date = date, returned = boolean)
- Practicalities
a) Don't want to put effort into something not used... so start small.
Exactly. It will be used
b) IF it's to be web based, we'll need a host service supporting MySQL
- do we have this??
I believe the isp uklinux.net provides home areas with perl and mysql accounts, see there web page for details.
c) Me No Web Wizard !
Me not wizard, but got the basic idea, give me a shout if you need a hand, although a perl wizard would be useful at this point.
d) IF not web based - um, how's it going to work??
Badly? We want solutions not problems, ne ideas?
e) it's getting late & I've not had my UT fix yet.
Me to.
Anyone want to give a hand / interested in getting something going?
NE questions drop me a line.
We also need to consider who has access to change/add things?
Thanks
D
Bye!
Steve
PS will post some more thoughts re design & features a bit later.
__________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/