NIT5130 Database Project: IO Lounge Design and Implementation

This project details the design and implementation of a database for the Victoria University International Office (IO) Lounge, addressing the need for efficient data entry and reporting. The project includes an ER diagram illustrating the database structure, defines business rules governing data relationships, and confirms normalization to the third normal form. The implementation phase utilizes PHPMyAdmin for database development, featuring forms for student information entry, job updates, job assignments, and generating reports such as student addresses and nutrition-related data. Appendices provide the PHP code used for creating these forms and reports within a WordPress environment, demonstrating the integration of database functionalities with a user-friendly interface. This database solution aims to streamline IO operations, improve data management, and facilitate report generation for administrative tasks.

Running head: DATABASE DESIGN AND IMPLEMENTATION
IO Lounge Database Design and Implementation
Name of the Student
Name of the University

1DATABASE DESIGN AND IMPLEMENTATION
Table of Contents
1. Database Designing:....................................................................................................................2
1.1 ERD of the Database:............................................................................................................2
1.2 Business Rules:......................................................................................................................3
1.3 The Normalization:....................................................................................................................3
2. Database Implementation:...........................................................................................................4
2.1 Data Dictionary:.....................................................................................................................4
2.2 PhpMyAdmin Based Database Development:......................................................................5
Bibliography:.................................................................................................................................10
Appendices:...................................................................................................................................11
Appendix 1: Student Information Entry Form Coding..............................................................11
Appendix 2: Job Update Form Coding......................................................................................14
Appendix 3: Student Address Report Coding...........................................................................18
Appendix 4: Job Assigning Form Coding.................................................................................19
Appendix 5: Nutrition Related Data Report Coding.................................................................23

2DATABASE DESIGN AND IMPLEMENTATION
1. Database Designing:
1.1 ERD of the Database:
1.2 Business Rules:
Entity Rule Entity

3DATABASE DESIGN AND IMPLEMENTATION
Student One-to-One Volunteer
Student Many-to-One Course
Volunteer One-to-Many Volunteer_Job
Job Many-to-One Volunteer_Job
Job One-to-Many Task
Volunteer_Job One-to-Many Roster
1.3 The Normalization:
All the tables are already in third normal form.

4DATABASE DESIGN AND IMPLEMENTATION
2. Database Implementation:
2.1 Data Dictionary:
The PHPMyAdmin has been sued for installing the database.

5DATABASE DESIGN AND IMPLEMENTATION
2.2 PhpMyAdmin Based Database Development:
Student Information Entry Form:
Through this form, the students are registered into the system.
Suppose a student selects course Bachelor of Arts, her name is Lauren Wood and fills
other data then click submit.

6DATABASE DESIGN AND IMPLEMENTATION
The data is also inserted in the student entity of the database.
Student Information Entry Form:
This form is for updating the job details. The admin will enter the student ID and the job
details of the student will appear on the screen.

7DATABASE DESIGN AND IMPLEMENTATION
Suppose director inputs 3. Then the details of job of the student with id 3 will appear in
the screen. If the director changes any data then clicks submit. Then the job and roster will be
updated. Suppose the student wants to be waiter on 13th Feb.
The data is also inserted in the student entity of the database.
Student Address Report:
The address of all the students will appear at screen when the page will be opened.

8DATABASE DESIGN AND IMPLEMENTATION
See the last entered student address is also available in the page.
Fill Job:
Here a student either new of already worked as volunteer will be assigned to job for a
particular day at a particular time. The volunteer batch_number is also provided here.
After submitting all the data the job will be assigned to the volunteer.
Dietary Requirements:
The nutrition related data will be shown in this page.

9DATABASE DESIGN AND IMPLEMENTATION

10DATABASE DESIGN AND IMPLEMENTATION
Bibliography:
Islam, M., 2018. WordPress Theme Development and Customization.
Solichin, A., 2016. Pemrograman web dengan PHP dan MySQL. Penerbit Budi Luhur.

11DATABASE DESIGN AND IMPLEMENTATION
Appendices:
Appendix 1: Student Information Entry Form Coding
<?php /* Template Name: student entry form */ ?>
<?php get_header(); ?>
<?php
/*
Plugin Name: Contact Form
Plugin URI: http://wpgeeks.net/
Version: 1.0
Author: Adam
Description: A simple contact form for testing
*/
include('/../../../wp-load.php');
if(isset($_POST['submit'])){
// use global variable for database opertation
global $wpdb;
$num_rows = $wpdb->get_var( "SELECT COUNT(*) FROM student" ); //PHP count()
$num_rows=$num_rows+1;