IO Lounge Database Design and Implementation Project Solution

This project outlines the design and implementation of a database for the IO Lounge, utilizing phpMyAdmin. The report begins with the database design phase, which includes an Entity-Relationship Diagram (ERD) illustrating the relationships between entities such as students, volunteers, courses, jobs, and rosters. Business rules are defined to ensure data integrity and consistency. The database tables are normalized to the third normal form (3NF) to minimize redundancy and improve data management. The implementation phase details the setup of the database in phpMyAdmin, including the creation of tables and relationships. Several forms are created using PHP to facilitate data entry and updates, including student information entry, job update, job assigning and nutrition related data report. Code snippets for these forms are provided in the appendices, showcasing the integration of PHP with the database. The report concludes with a bibliography of relevant sources used for database design and implementation.

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:...................................................................................................................................12
Appendix 1: Student Information Entry Form Coding..............................................................12
Appendix 2: Job Update Form Coding......................................................................................15
Appendix 3: Student Address Report Coding...........................................................................19
Appendix 4: Job Assigning Form Coding.................................................................................20
Appendix 5: Nutrition Related Data Report Coding.................................................................24

2DATABASE DESIGN AND IMPLEMENTATION
1. Database Designing:
1.1 ERD of the Database:

3DATABASE DESIGN AND IMPLEMENTATION
1.2 Business Rules:
Entity Rule Entity
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:
The tables are already in the third normal form as all the attributes are atomic, there is no
partial dependency and no transitive dependency.

4DATABASE DESIGN AND IMPLEMENTATION
2. Database Implementation:
2.1 Data Dictionary:
The whole database is being installed in the phpMyAdmin. The wordpress site has been
also installed in the localhost of phpMyAdmin.

5DATABASE DESIGN AND IMPLEMENTATION
2.2 PhpMyAdmin Based Database Development:
Student Information Entry Form:
The first form is student information entry form. In this form the data will be provide by
the student.

6DATABASE DESIGN AND IMPLEMENTATION
Suppose a student selects course Bachelor of Arts, her name is Lauren Wood and fills
other data then click submit.
The data is also inserted in the student entity of the database.
Student Information Entry Form:
The second form is job update form. In this form the job, roster and batch_number of the
volunteer can be changed. The director will first enter the id of the student whose job needs to be
updated.

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.

8DATABASE DESIGN AND IMPLEMENTATION
Student Address Report:
The address of all the students will appear at screen when the page will be opened.
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.

9DATABASE DESIGN AND IMPLEMENTATION
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.

10DATABASE DESIGN AND IMPLEMENTATION
Bibliography:
Albuquerque, L.C., 2017. 2D Vector Map and Database design for Indoor Assisted Navigation.
Bennett, R.J., Smith, H.J., van Lieshout, C. and Newton, G.H., 2017. Drivers of
Entrepreneurship and Small Businesses: Project overview and database design.
Echeverria, V., Martinez-Maldonado, R., Chiluiza, K. and Shum, S.B., 2017. Dbcollab:
Automated Feedback for Face-to-Face Group Database Design. In Proceedings of 25th
International Conference on Computers in Education (ICCE 2017).
Groom, C.R., Bruno, I.J., Lightfoot, M.P. and Ward, S.C., 2016. The Cambridge structural
database. Acta Crystallographica Section B: Structural Science, Crystal Engineering and
Materials, 72(2), pp.171-179.
Letkowski, J., 2015. Doing database design with MySQL. Journal of Technology Research, 6,
p.1.
Richter, K.S., Mottla, G.L., Kaplan, B., Hayward, B. and Mahony, M.C., 2016. Evaluating
pregnancy and live birth outcomes in a real-world analysis of a US database of 66,051 transfers
over 6.5 years. Fertility and Sterility, 106(3), pp.e53-e54.
Stonebraker, M., Deng, D. and Brodie, M.L., 2017. Application-Database Co-Evolution: A New
Design and Development Paradigm. New England Database Day, pp.1-3.
Youssef, M.W. and Asfour, A., 2015. A Proposed Design of Logistics Information Systems
Database to Enhance the Effectiveness of Supply Chain Manager Decisions. International
Journal of Advance Research in Education, Technology & Management.

11DATABASE DESIGN AND IMPLEMENTATION
Zhou, B., Lapedriza, A., Xiao, J., Torralba, A. and Oliva, A., 2014. Learning deep features for
scene recognition using places database. In Advances in neural information processing
systems (pp. 487-495).