Prac

Do I have to worry about stuff like field lengths, data types, etc. for the fields in the tables, or can I use my own?

The structure for tables must be exactly as in the tut letter - don't tell me it isn't there?

Here is the structure:

CREATE TABLE `course` (
`cname` varchar(50) NOT NULL default '',
`cid` int(6) NOT NULL auto_increment,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `course_student`
--

CREATE TABLE `course_student` (
`sno` int(6) NOT NULL default '0',
`cid` int(6) NOT NULL default '0',
`year` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
`sno` int(6) NOT NULL auto_increment,
`sname` varchar(40) NOT NULL default '',
`init` varchar(5) NOT NULL default '',
`fname` varchar(40) NOT NULL default '',
`title` varchar(4) NOT NULL default '',
`msname` varchar(40) NOT NULL default '',
`dob` varchar(8) NOT NULL default '',
`sex` char(2) NOT NULL default '',
`lang` varchar(10) NOT NULL default '',
`idno` varchar(13) NOT NULL default '',
`telh` varchar(12) NOT NULL default '',
`telw` varchar(12) NOT NULL default '',
`cel` varchar(12) NOT NULL default '',
`fax` varchar(12) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`address` tinytext NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `course` ( 
   `cname` varchar(50) NOT NULL default '', 
   `cid` int(6) NOT NULL auto_increment, 
   PRIMARY KEY (`cid`) 
   ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

I cannot get the CHARSET option to work. In the end I used:

  CREATE TABLE course (
    cname varchar(50) NOT NULL default '',
    cid int(6) NOT NULL auto_increment,
    PRIMARY KEY  (cid)
  ) TYPE=MyISAM;

1. I ignored the DEFAULT CHARSET=latin1 for all tables created. Is this OK? If I have that statement in, I cannot get the CREATE TABLE to execute.
2. I changed ENGINE=MyISAM to TYPE=MyISAM. Is this OK?

Yes - those parts tends to give problems if you use phpmyadmin.

Where do we upload the practical?

- say there's a small error causing my application not to connect to your database (which i know from experience is 80% the case when running code on a new server) will I get 0?

You just email it me zipped. Db connection errors I will solve at no cost to you - as long as I only have to do it in one single file

Table: Student
--------------
`sex` char(2) NOT NULL default '',
--------------

- Is this used to store gender as Ma=Male and Fe=Female?

[edit]
Do I have to worry about Referential Integrity?

Whatever you want to use - you don't have to use 2, you can just use m and f.

Hi Mac,

Sent prac to @#$%&. How will I know if you received ?

Regards
Allen

When you get your marks

No, let's do it this way - I'll create a new topic for and post there when I receive it.

Sometimes it struggles for a day to get past the Unisa firewall, so just give it a day or two.