ERD, Business Rules, 3NF Relations and Data Dictionary | Desklib

This article discusses the Entity Relationship Diagram, Business Rules, 3NF Relations and Data Dictionary for IO Background. It covers the 3NF relations for various tables such as Students, Roster, Volunteership, Tasks, Special_diet, Jobs, Course, Unit, Enrollment, Facilities_and_services, Faculty, and School. The article also includes the SQL queries used to create the database.

COVER PAGE

Contents
1 Task 1........................................................................................................................................................3
1.1 ERD..............................................................................................................................................3
1.2 Business rules..............................................................................................................................3
1.3 3NF relations................................................................................................................................3
1.4 Data Dictionary............................................................................................................................6
Task 2..........................................................................................................................................................9
PhPMyAdmin implementation....................................................................................................................9
Populating the tables with data.............................................................................................................20
Wordpress forms and report implementation......................................................................................27

1 Task 1
1.1 ERD
Figure 1: Entity relationship diagram
1.2 Business rules
Business rule derived from IO background.
 IO is made of many faculties and each faculty consists of one or more schools.
 Every school in Io offers one or more courses.
 Every student enrolls for one and only one course and a student can either be a full-time
student or part-time student.
 IO has a lodge where students can meet for socializing. The lodge offers different facilities and
services to the students.
 The facilities and services offered at the lodge may result into one or more jobs.
 During enrollment a student can choose to volunteer for the jobs at the lodge or not.
Volunteering is optional for all students. Only interested students volunteer for the jobs at the
lodge.
 Some students require a special diet at the lodge. It’s not a must for a student to have a special
diet.
1.3 3NF relations
 Students (studentNO, firstName, familyName, phoneNO, streetNO, city, state, postcode, type)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. StudentNO is the only candidate key and no
other combination of attributes can form a candidate key.

3NF- All transitive dependencies have been eliminated. StudentNO is the only key attribute
which determines all the other attributes.
 Roster ( rsID, taskID, studentNO, startDate, endDate, status)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. rsID is the only candidate key and no other
combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. rsID is the only key attribute which
determines all the other attributes.
 Volunteership (volunteershipID,rosterID,studentNO)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. volunteershipID is the only candidate key
and no other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. volunteershipID is the only key attribute
which determines all the other attributes.
 Tasks (taskID, taskName, details, time, jobID)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. taskID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. taskID is the only key attribute which
determines all the other attributes.
 Special_diet (dietID, studentNO, details)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. dietID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. dietID is the only key attribute which
determines all the other attributes.
 Jobs (jobID, jobNname, details, fsID)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. jobID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. jobID is the only key attribute which
determines all the other attributes.

 Course (courseID, courseName, duration, schoolID)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. courseID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. courseID is the only key attribute which
determines all the other attributes.
 Unit (unitID,unitName,courseID)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. unitID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. unitID is the only key attribute which
determines all the other attributes.
 Enrollment (enrollmentID, courseID, studentNO, date)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. enrollmentID is the only candidate key and
no other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. enrollmentID is the only key attribute
which determines all the other attributes.
 Facilities_and_services (fsID, name, type, description)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. fsID is the only candidate key and no other
combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. fsID is the only key attribute which
determines all the other attributes.
 Faculty (facultyID, facultyName, dean)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. facultyID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. facultyID is the only key attribute which
determines all the other attributes.

 School (schoolID, schoolName, facultyID)
The relation is in 3NF because;
1NF- All repeating groups have been eliminated.
2NF- All partial dependencies have been eliminated. schoolID is the only candidate key and no
other combination of attributes can form a candidate key.
3NF- All transitive dependencies have been eliminated. schoolID is the only key attribute which
determines all the other attributes.
1.4 Data Dictionary
Relation Attributes Meaning Data type Other
faculty facultyID facultyID is unique for every
faculty and is used to identify
a faculty
INT Primary key
Auto-Increment
facultyName Name of the faculty e.g.
faculty of computing
VARCHAR(50) NOT NULL
eg “faculty of science”
dean Dean of the faculty VARCHAR(50) NOT NULL
units unitID The unique identifier of the
unit
INT Primary key
unitName The name of the unit VARCHAR(50) MANDATORY
courseID Identifier of the course the
unit belongs to
INT Foreign key references
course.courseID
course courseID CourseID is unique for evey
course and identifies a course
INT Primary key
Auto-Increment
courseName Name of the course VARCHAR(50) Not Null
duration Years the course will take INT NOT NULL
For example “4”
schoolID Identifier of the school the
course belongs to
INT Foreign key references
school .schoolID
School schoolID schoolID is unique for every
course and is used to identify
a school
INT primary key
Auto-Increment
schoolName Name of the school VARCHAR(50) Not Null
For example “School
of engineering”
facultyID Identifier of the faculty the
school belongs to
INT NOT NULL
foreign key
References
faculty.facultyID
task taskID The unique identifier of the
task
INT primary key
taskName The name of the task VARCHAR(50) NOT NULL
description The description of the task in
details
TEXT NULL
Time_interval The interval between two VARCHAR(25) NOT NULL

subsequent tasks eg “daily”
Students studentNO studentNO is the unique
identifier of the student
INT(8) Primary Key
firstName First name of the student VARCHAR(50) Not Null
familyName Family name given to the
student
VARCHAR(50) Not Null
phoneNO The personal phone number
of the student
VARCHAR(25) NOT NULL
streetNO The street that the student
stays
VARCHAR(50) NOT NULL
City The city the student comes
from
VARCHAR(50) NOT NULL
eg “Melbourne”
State The state the student comes
from
VARCHAR(50) NOT NULL
postcode The postcode of the student INT(8) Not Null
type The type of the student i.e.
part-time enrollment student
or full-time enrollment
student
VARCHAR(25) NOT NULL eg “full-
time”
Special_diet dietID The unique identifier of the
special diet
INT primary key
studnetNO Identifier of the student
taking the special diet
INT foreign key references
students.studentID
description The description of the special
diet in details
TEXT NOT NULL
Jobs JobID The unique identifier of a job INT Primary key
Auto-Increment
name The name of a job VARCHAR(50) NOT NULL
description The description in details of a
job
TEXT NULL
facOrSerID Identifier of the facility or
service
INT NOT NULL
foreign key references
facility_and_services.
facOrSerID
roster rID The unique identifier of the
roster
INT primary key
Auto-increment
taskID Identifier of the task INT Foreign key references
task.taskID
studentNO Identifier of the student INT(8) foreign key references
students.studentID
startDate The starting date of the task VARCHAR(25) NOT NULL
endDate The ending date of the task VARCHAR(25) NOT NULL
status The status of the task whether
complete or not
VARCHAR(10) NOT NULL
Eg “complete”
Enrollment enrollmentID The unique identifier of the
enrollment
INT Primary key
Auto-Increment

courseID Identifier of the course being
enrolled for
INT Foreign key references
course.courseID
StudentNO Identifier of the student
enrolling for the course
INT Foreign key references
students.studentNO
date The date the enrollment was
done.
Timestamp NOT NULL
Current_timestamp
Facility_and_services facOrSerID The unique identifier of the
facility or service
INT primary key
name The name of the facility or
service
VARCHAR(50) NOT NULL
type The type; either facility or
servce
VARCHAR(25) NOT NULL
Eg “service”
description The description in details of
the facility or service
TEXT NULL
volunteership volunteershipID The unique identifier of the
volunteership
INT Primary key
rosterID Identifier of the roster for
which the volunteership is
taking place
INT foreign key references
roster.rosterID
studentNO Identifier of the student
volunteering
INT foreign key references
roster.rosterID
Task 2
PhPMyAdmin implementation
The SQL queries used to create the database;

-- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 09, 2018 at 07:28 AM
-- Server version: 5.6.21
-- PHP Version: 5.6.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `iodb`
--
CREATE DATABASE IF NOT EXISTS `iodb` DEFAULT CHARACTER SET latin1
COLLATE latin1_swedish_ci;
USE `iodb`;
-- --------------------------------------------------------
--
-- Table structure for table `course`
--

CREATE TABLE IF NOT EXISTS `course` (
`coureID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`duration` int(11) NOT NULL,
`schoolID` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `enrollment`
--
CREATE TABLE IF NOT EXISTS `enrollment` (
`enrollmentID` int(11) NOT NULL,
`courseID` int(11) NOT NULL,
`studentNO` int(8) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `facilities_services`
--
CREATE TABLE IF NOT EXISTS `facilities_services` (
`fsID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`type` varchar(25) NOT NULL,

`descrption` text
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `faculty`
--
CREATE TABLE IF NOT EXISTS `faculty` (
`facultyID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`dean` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`jobID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`description` text NOT NULL,
`fsID` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------

--
-- Table structure for table `roster`
--
CREATE TABLE IF NOT EXISTS `roster` (
`rsID` int(11) NOT NULL,
`taskID` int(11) NOT NULL,
`studentNO` int(8) NOT NULL,
`date_time_from` varchar(50) NOT NULL,
`date_time_to` varchar(50) NOT NULL,
`status` varchar(25) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `school`
--
CREATE TABLE IF NOT EXISTS `school` (
`schoolID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`facultyID` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `special_diet`
--

CREATE TABLE IF NOT EXISTS `special_diet` (
`dietID` int(11) NOT NULL,
`studentNO` int(11) NOT NULL,
`description` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `students`
--
CREATE TABLE IF NOT EXISTS `students` (
`studentID` int(8) NOT NULL,
`firstName` varchar(50) NOT NULL,
`familyName` varchar(50) NOT NULL,
`phoneNO` varchar(25) NOT NULL,
`streetNO` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`postCode` int(8) NOT NULL,
`type` varchar(25) NOT NULL,
`volunteer` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `tasks`

--
CREATE TABLE IF NOT EXISTS `tasks` (
`taskID` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`description` text,
`jobID` int(11) NOT NULL,
`time_interval` varchar(25) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `course`
--
ALTER TABLE `course`
ADD PRIMARY KEY (`coureID`), ADD KEY `schoolID` (`schoolID`);
--
-- Indexes for table `enrollment`
--
ALTER TABLE `enrollment`
ADD PRIMARY KEY (`enrollmentID`), ADD KEY `courseID`
(`courseID`,`studentNO`), ADD KEY `studentNO` (`studentNO`);
--
-- Indexes for table `facilities_services`
--
ALTER TABLE `facilities_services`

ADD PRIMARY KEY (`fsID`);
--
-- Indexes for table `faculty`
--
ALTER TABLE `faculty`
ADD PRIMARY KEY (`facultyID`);
--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`jobID`), ADD KEY `fsID` (`fsID`);
--
-- Indexes for table `roster`
--
ALTER TABLE `roster`
ADD PRIMARY KEY (`rsID`), ADD KEY `taskID` (`taskID`,`studentNO`),
ADD KEY `studentNO` (`studentNO`);
--
-- Indexes for table `school`
--
ALTER TABLE `school`
ADD PRIMARY KEY (`schoolID`), ADD KEY `facultyID` (`facultyID`);
--
-- Indexes for table `special_diet`
--
ALTER TABLE `special_diet`

ADD PRIMARY KEY (`dietID`), ADD KEY `studentNO` (`studentNO`);
--
-- Indexes for table `students`
--
ALTER TABLE `students`
ADD PRIMARY KEY (`studentID`);
--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
ADD PRIMARY KEY (`taskID`), ADD KEY `jobID` (`jobID`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `course`
--
ALTER TABLE `course`
MODIFY `coureID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `enrollment`
--
ALTER TABLE `enrollment`
MODIFY `enrollmentID` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `facilities_services`

--
ALTER TABLE `facilities_services`
MODIFY `fsID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `faculty`
--
ALTER TABLE `faculty`
MODIFY `facultyID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `jobID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `roster`
--
ALTER TABLE `roster`
MODIFY `rsID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `school`
--
ALTER TABLE `school`
MODIFY `schoolID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `special_diet`
--
ALTER TABLE `special_diet`
MODIFY `dietID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tasks`

--
ALTER TABLE `tasks`
MODIFY `taskID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `course`
--
ALTER TABLE `course`
ADD CONSTRAINT `course_ibfk_1` FOREIGN KEY (`schoolID`) REFERENCES
`school` (`schoolID`) ON UPDATE CASCADE;
--
-- Constraints for table `enrollment`
--
ALTER TABLE `enrollment`
ADD CONSTRAINT `enrollment_ibfk_1` FOREIGN KEY (`studentNO`)
REFERENCES `students` (`studentID`) ON UPDATE CASCADE,
ADD CONSTRAINT `enrollment_ibfk_2` FOREIGN KEY (`courseID`) REFERENCES
`course` (`coureID`) ON UPDATE CASCADE;
--
-- Constraints for table `jobs`
--
ALTER TABLE `jobs`
ADD CONSTRAINT `jobs_ibfk_1` FOREIGN KEY (`fsID`) REFERENCES
`facilities_services` (`fsID`) ON UPDATE CASCADE;
--
-- Constraints for table `roster`

--
ALTER TABLE `roster`
ADD CONSTRAINT `roster_ibfk_1` FOREIGN KEY (`taskID`) REFERENCES
`tasks` (`taskID`) ON UPDATE CASCADE,
ADD CONSTRAINT `roster_ibfk_2` FOREIGN KEY (`studentNO`) REFERENCES
`students` (`studentID`) ON UPDATE CASCADE;
--
-- Constraints for table `school`
--
ALTER TABLE `school`
ADD CONSTRAINT `school_ibfk_1` FOREIGN KEY (`facultyID`) REFERENCES
`faculty` (`facultyID`) ON UPDATE CASCADE;
--
-- Constraints for table `special_diet`
--
ALTER TABLE `special_diet`
ADD CONSTRAINT `special_diet_ibfk_1` FOREIGN KEY (`studentNO`)
REFERENCES `students` (`studentID`) ON UPDATE CASCADE;
--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
ADD CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`jobID`) REFERENCES `jobs`
(`jobID`) ON UPDATE CASCADE;
Populating the tables with data
To populate the tables with data the following sql queries were ran.
-- phpMyAdmin SQL Dump
-- version 4.2.11

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 09, 2018 at 07:31 AM
-- Server version: 5.6.21
-- PHP Version: 5.6.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `iodb`
--
CREATE DATABASE IF NOT EXISTS `iodb` DEFAULT CHARACTER SET latin1
COLLATE latin1_swedish_ci;
USE `iodb`;
--
-- Dumping data for table `course`
--
INSERT INTO `course` (`coureID`, `name`, `duration`, `schoolID`)
VALUES
(1, 'bachelors of science business adminstration', 4, 1),
(2, 'bachelors of science data science', 4, 2);

--
-- Dumping data for table `enrollment`
--
INSERT INTO `enrollment` (`enrollmentID`, `courseID`, `studentNO`,
`date`) VALUES
(1, 1, 12345678, '2017-09-28 12:01:22'),
(2, 2, 87654321, '2017-09-28 12:01:22'),
(3, 1, 123487654, '2017-09-28 12:01:22'),
(4, 2, 876541234, '2017-09-28 12:01:22');
--
-- Dumping data for table `facilities_services`
--
INSERT INTO `facilities_services` (`fsID`, `name`, `type`,
`descrption`) VALUES
(1, 'pool table', 'facility', 'playing poker'),
(2, 'tea', 'service', 'tea services'),
(3, 'poker', 'facility', 'poker');
--
-- Dumping data for table `faculty`
--
INSERT INTO `faculty` (`facultyID`, `name`, `dean`) VALUES
(1, 'faculty of business studies', 'meg griffin'),
(2, 'faculty of science and technology', 'Peter griggin');
--

-- Dumping data for table `jobs`
--
INSERT INTO `jobs` (`jobID`, `name`, `description`, `fsID`) VALUES
(1, 'cleaning', 'cleaning the kitchen', 1),
(2, 'serving tea', 'serving tea to the other students in the longe',
2),
(3, 'counter', 'coordinating the counter', 3);
--
-- Dumping data for table `roster`
--
INSERT INTO `roster` (`rsID`, `taskID`, `studentNO`, `date_time_from`,
`date_time_to`, `status`) VALUES
(1, 1, 12345678, '2017-09-28 05:14:15', '2017-09-28 12:32:33',
'complete'),
(2, 2, 87654321, '2017-09-28 09:23:25', '2017-09-28 15:40:41',
'incomplete'),
(3, 3, 123487654, '2017-09-28 09:23:25', '2017-09-28 15:40:41',
'incomplete'),
(4, 4, 876541234, '2017-09-28 09:23:25', '2017-09-28 15:40:41',
'incomplete');
--
-- Dumping data for table `school`
--
INSERT INTO `school` (`schoolID`, `name`, `facultyID`) VALUES
(1, 'school of computer scuence', 2),
(2, 'school of business', 1);

--
-- Dumping data for table `special_diet`
--
INSERT INTO `special_diet` (`dietID`, `studentNO`, `description`)
VALUES
(1, 12345678, 'lactose intolerant'),
(2, 87654321, 'Cabohydrate intolerant'),
(3, 123487654, 'diabetic');
--
-- Dumping data for table `students`
--
INSERT INTO `students` (`studentID`, `firstName`, `familyName`,
`phoneNO`, `streetNO`, `city`, `state`, `postCode`, `type`,
`volunteer`) VALUES
(21, 'Lebron', 'James', '[phone]', '1st street', 'Cleveland',
'adsad', 3223, 'part-time', 'YES'),
(5432345, 'Wesley', 'Johnson', '[phone]', '2nd street', 'Miami',
'the north', 5434, 'full-time', 'YES'),
(12345678, 'Kyrie', 'Irving', '[phone]', '3rd street', 'Boston',
'providence', 4312, 'full-time', 'YES'),
(87654321, 'Marcus', 'Smart', '[phone]', '4th street', 'Boston',
'cleveland', 4321, 'part-time', 'YES'),
(123487654, 'Lionel', 'Messi', '[phone]', '3rd street ',
'Barcelona', 'North', 7890, 'full-time', 'YES'),
(876541234, 'Christiano', 'Ronaldo', '[phone]', '2nd street',
'Madrid', 'South', 5432, 'part-time', 'YES');
--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`taskID`, `name`, `description`, `jobID`,
`time_interval`) VALUES
(1, 'cleaning', 'moppng the kitchen', 1, 'daily'),
(2, 'serving tea', 'daily', 2, 'everyday except weekends'),
(3, 'cooking coffee', 'cooking coffee', 2, 'everyday except
weekends'),
(4, 'tiding up the lodge', 'shuffling', 3, 'once a wek');
The screenshots below show data in every table;
 Course
 Enrollment
 Facilities_services
 Faculty

 Jobs
 Roster
 School
 Special diet

 Students
 Tasks
Wordpress forms and report implementation
 Special diets
 Student address details

 Add student form
 Fill job form

 Update roaster form