May 25, 2011 at 5:42 am
here is what i have so far,a database for the system but i am not able to normalise tghem and make relationships in microsoft access.plis help
-- phpMyAdmin SQL Dump
-- version 2.10.1
--
-- Host: localhost
-- Generation Time: Apr 15, 2011 at 10:38 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `exam`
--
-- --------------------------------------------------------
--
-- Table structure for table `exams`
--
CREATE TABLE `exams` (
`examnumber` varchar(20) default NULL,
`subid` varchar(20) default NULL
PRIMARY KEY ('examnumber')
FOREIGN KEY ('admin id')
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `exams`
--
-- --------------------------------------------------------
--
-- Table structure for table `students`
--
CREATE TABLE `students` (
`fname` varchar(20) default NULL,
`lname` varchar(20) default NULL,
`idnumber` varchar(20) NOT NULL default '',
`postaladdress` varchar(20) default NULL,
`emailaddress` varchar(20) default NULL,
`subjects` varchar(20) default NULL,
`country` varchar(20) default NULL,
`username` varchar(20) default NULL,
`password` varchar(20) default NULL,
PRIMARY KEY (`idnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `students`
--
-- --------------------------------------------------------
--
-- Table structure for table `tutorials`
--
CREATE TABLE `tutorials` (
`subid` varchar(20) NOT NULL default '',
`tutorial_number` varchar(20) default NULL,
`topic` varchar(20) default NULL,
PRIMARY KEY (`subid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tutorials`
--
-----------------------------------------------------------
--
-- Table structure for table `administrator`
--
CREATE TABLE `administrator` (
`lname` varchar(20) default NULL,
`id` varchar(20) NOT NULL default '',
`teacher_for` varchar(20) default NULL,
`available_online` varchar(30) default NULL,
`username` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `password` (`password`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `administrator`
--
---------------------------------------------------------
-- Table structure for table `examtaken`
--
CREATE TABLE `examtaken` (
`fname` varchar(23) NOT NULL,
`lname` varchar(23) NOT NULL,
`id` varchar(23) NOT NULL,
`contact` varchar(23) NOT NULL,
`subid` varchar(24) NOT NULL,
`marks` varchar(24) NOT NULL,
PRIMARY KEY ('Examnumber')
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `examtaken`
--
----------------------------------------------------------
May 25, 2011 at 6:01 am
That's not Microsoft Access, that's MySQL.
This is a SQL Server site, you're likely to get better and faster answers on a MySQL forum. Try http://forums.mysql.com
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply