June 2005 - openSUSE Edu - openSUSE Mailing Lists

Bit chilly out?
by Paul Graydon 07 Jun '05

07 Jun '05

Wonder of wonders, Debian v 3.1 has been released: http://www.debian.org/ On the very same day, Apple has announced that it is switching to using Intel processors, though little official word that I've seen so far about whether or not it will be strictly x86 architecture: http://www.theregister.com/2005/06/06/apple_intel_migration/----- Paul Graydon Network Technician Haywards Heath College http://www.hhc.ac.uk (01444) 456281 "Joy is not in things; it is in us." Richard Wagner

1 1

Re: [suse-linux-uk-schools] Yet another school database
by Robert Jones 06 Jun '05

06 Jun '05

The standards set out for data exchanges in England should help you here - CBDS is pretty specific about things like ethnicity religion. Each student has exactly one ethnicity, from this list: http://www.teachernet.gov.uk/_doc/6845/ETHLIST.XLS so you make ethnicity a field in your student table, as you have done. As stated earlier, there are several ways you can use the list of possible values. Enumerating them in the table definition would work (you could still put something in your front end to allow editing of the list) or you could store them in your "ethnic" table if you preferred - this seems clearer to me. The whole class/classification thing is more flexible, but more complicated. You will need this level of complexity further down the line when you come to think about the connections between students, teachers, classes and courses, but at this early stage the things you are talking about are straightforward attributes of students, and so IMHO belong as fields in the student table. This may also help: http://www.teachernet.gov.uk/_doc/7995/CBDS%20Pupil%20V3.1.xls On Monday 06 June 2005 14:53, Thomas Adam wrote: > --- richard(a)tortoise.demon.co.uk wrote: > > I now want to say what ethnic group students belong to, and so on, so > > However, a student belongs falls into at most 1 ethnic group. > > Therefore I need a constraint on the table to prevent the entry of > > two records where the same student is assigned 2 classification_id's > > which actually belong to the same class (ie class_id=2 , Ethnic). > > > > A table constraint won't do, as two tables are involved. > > So you need to split it up a little. The problem you have is that each > classification category itself might have many things associated with > it. That's fine, but that calls for a re-think. > > One solution (ignoring any form of schema design) would be to make each > classification below each heading (i.e. 'ethnic group' for instance, > might have several elements attached to it) an enum of possibilities. > Whilst this is possible, there's several issues with it -- least of > which is the fact that you'd then have to use some form of trigger, > which is overkill in this case. > > So what I propose is we revist the schema overall. I don't have a lot > of time to spend on this as I'd like. However, I'll outline some of my > suggestions. As it stands, the relationship between 'class' and > 'classification' as entities is OK. What we need now is a means of > linking a student to this, in such a way as to meet the constraint [1] > that you're wanting. It seems to me that you want something like the > following (I apologise in advance for my poor ASCII diagrams): > > +--------------+ > > | Class | > > +--------------+ > > > / \ > +-------------------+ +----------------+ > > | Classification | | Student | > > +-------------------+ +----------------+ > > > / \ / \ > +----------------------------------------+ > > | Belief | > > +----------------------------------------+ > > > The nomenclature for table 'Belief' is questionable, and a more suited > name is advised. Essentially. 'Belief' is a link entity. The > assumption here is that there is a M-M (many to many) relationship now, > between Classification and Student. Due to the referential integrity > model, one cannot (directly) implement a M-M relationship between two > entities, so a third table is introduced. Essentially, 'Belief' would > hold foreign key references to both Classification and Student, so that > in this way, 'Belief' could then easily define whether a student could > be a member of a group or not, based on table constraints enforced > therein. > > Does that make sense? > > -- Thomas Adam > > [1] It's not really a constraint in the sense of a check, it's more > a design feature. > > > > ___________________________________________________________ > How much free photo storage do you get? Store your holiday > snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com -- Robert Jones ------------------------------------------------------- -- Robert Jones

1 0

Yet another school database
by richard＠tortoise.demon.co.uk 06 Jun '05

06 Jun '05

Another attempt at an open source school database. www.schoolbase.net Anyone with ideas on how such a thing should be made? regards Richard

3 4

NFS
by Miles Berry 05 Jun '05

05 Jun '05

I'm interested in setting up either a dual boot or Windows xserver suite, and want to provide access to the usual network shares which are on a Linux server running Samba. From what I've read NFS seems the way to go rather than using a Linux Samba client, but what I'm not clear about is the easy way to provide my users with access to just their shares, rather than whole sections of the directory tree. The smb.conf at present has shares set like this: [home] comment = Home Directories path = /export/user/%g/%u read only = No [hidden] comment = user's LINUX filespace path = /home/%g/%u read only = No [group] comment = Group's server file space path = /export/groups/%g read only = No [all] comment = Common files path = /export/all/ read only = No My question is really how do I get the %g and %u (groupid and userid) stuff and automounting in NFS, without having to write lots of separate scripts for each user. Any help would be much appreciated. BTW, Thank you to the many of you who got in touch about my 19 station LTSP idea, the governors have put this one on hold for at least 12 months, pending building work which will necessitate the use of the room I had in mind as a temporary music room. Ah well, maybe next year. -- Miles Berry Deputy Head St Ives School Haslemere www.stiveshaslemere.com

2 5

php gurus about?
by Paul Taylor 05 Jun '05

05 Jun '05

Hi all: This is not strictly SuSE related but..I have a number of web sites running on a managed server (FC1) using Mambo. It has been working fine for a long time but a few weeks back I suddenly got plagued with upload errors relating to pclzip. The support of the site is less than forthcoming as it is a root server and they are not experts on individual packages. Having trawled through various forums I suspect that it relates to the version of Apache and PHP that are out of synch? It is running 2.0.50 and 4.3.8 respectively. I suspect that the provider updated one or other of these for me but I'm not sure. I installed Mambo on my home machine running 2.0.53 and 4.3.10 and have none of these upload problems. In order to move forward on these packages I assume I would probably need to upgrade the OS to FC2 or 3. This would entail yum as it is a remote device and I'm not sure this would work without bringing down the whole thing. They will do this for me but from scratch so I need good backups and to get all the sites back the way they were. probably easy but.. Any thoughts? -- De omnibus dubitandum

2 1