International Office Database (IOdatabase) For Student Positions And Facilities

Benefits of IOdatabase system

The database is a set of information. And this database system provides the interface between the data storage and retrieval (SILBERSCHATZ, 2018). The followings are benefits of this system,

1. Efficient retrieval mechanisms
2. Capacity for large amount of data
3. Multi user support
4. Concurrency and transaction control
5. Security management
6. An easy to use interface languages
7. Persistence storage with backup and recovery for reliability.

The objective of the IO database will be to collect the students details , collect the positions and facilities deails and alotting the facilities and positions to the suitable students. The database that satisfies all the objectives will be created. PhpMyAdmin and WordPress will be used for database operations and input/output operations using forms/reports.

Five tables are developed

The database is IOdatabase (International Office Database). It got tblStudents table to collect all the informations about the student. The Faculty and Foodstyle details also collected. Other 4 tables are tblPositionsAllottment , tblFacilityTypeAllottment, tblFacilities and

tblPositions. tblPositionsAllottment is used for alotting the positions for the students. tblFacilityTypeAllottment are for allotting facilities to the students. tblFacilities stores the details about the Facilities and tblPositions stores the details about the Positions.

Suitable entities are made

tblStudents(StudentNo, GivenName, FamilyName, Phone No, StreetNo, City, State, PostCode, Faculty, FoodStyle)

tblPositionsAllottment(Date,PositionsID,StudentID)

tblFacilityTypeAllottment(Data,FacilityID,StudentID)

tblFacilities(FacilityID,Date,FacilityType)

tblPositions(PositionID,Date,PositionsType)

Relationships between entities

StudentNo à GivenName, FamilyName, Phone No, StreetNo, City, State, PostCode, Faculty, FoodStyle

Suitable attributes are selected.  Primary keys are underlined above. The links between tables are shown. 1:n relationships between entities are shown in the ER Diagram below (Al-Masree, 2015) (SILBERSCHATZ, 2018).

Business Rules are explained in the diagrams (A Web Based Approach towards the Automated Generation of ER-Diagram, 2015) (SILBERSCHATZ, 2018)

• Students details should be collected
• Facilities details should be collected
• Positions details should be collected
• Facilities should be assigned to the students
• Positions should be assigned to the students
• Student details can be inputed from the form
• Few queries should be run and the results should be displayed in the form of reports
• School and associated faculties should be linked.

Normalization of database done (Shsu.edu, 2018) (Ischool.utexas.edu, 2018) (Ict.griffith.edu.au, 2018)

The 3NF format is shown below

tblStudents(StudentNo,GivenName,FamilyName,Phone No,Street No,City,State,PostCode,Faculty,FoodStyle)

tblPositionsAllottment(Date,PositionsID,StudentID)

tblFacilityTypeAllottment(Data,FacilityID,StudentID)

tblFacilities(FacilityID,Date,FacilityType)

tblPositions(PositionID,Date,PositionsType)

tblStudents

tblPositionsAllottment

tblFacilityTypeAllottment

tblFacilities

tblPositions

There is no multiple values in each table.  No records are repeating and they are unique. Hence the tables are following 1NF rules.

The tables are already got primary keys in a single column. Hence they follow 2NF formats too.

There is no transitive functional references present. Hence the table got 3NF format too.

PhpMyAdmin

Phpmyadmin  (contributors, 2018) tool is a free software tool. This tool is used to written in php code. This tool is work under MySQL.  We have to done the mysql operations by using this tool . These operations are managing columns, relations, tables, index users and permissions. This operations are directly run in any type of SQL statements.  And then this tool is used to update our wiki pages and documentation. Easy to handle this tool. This tool is supports both RTL and LTR languages. This tool is one member of software freedom conservancy (WordPress.org, 2018).

The following are benefits of phpmyadmin:

1. Creating critical queries using query by example
2. Administrating multiple services
3. Search8ing globally in a database
4. Import data from CSV and SQL
5. Export data to various formats.

1. First we have to open the table page. And to type a table name in text field.
2. Next to type the number of fields for your database. After enter the number of fields to click go button. Then to save the table.
3. To type the data for the first row.

• Type student no in the field column
• Next to select the data type in type column
• Select index type for the index column.
• Next to select check box

1. Next to click the save button .The is saved.
2. Next to repeat these steps for remaining rows.
3. To give the database name in the left sidebar.
4. We want to one more tables you have to follow the above 1-6 steps.

Manually created database “movedb” using phpmyadmin tool. So create database command is commented out in the following script.

• To open your database and to select tools->relationships from your menu.
• Next to select the tables and click add button.
• After add the rows to click close button.
• Next to provide the one to many relation ship for your table. And save your table.
• Finally to close the relationship window.

Create a password:

1. First to click privileges tab. To view your list of student accounts.
2. Next to click the edit privilege icon.
3. To click change password section. Click go button.
4. To give your password.

Conclusion

The objective of the IO database is to collect the students details , collect the positions and facilities deails and alotting the facilities and positions to the suitable students. The database that satisfies all the objectives are created. PhpMyAdmin and WordPress are used for database operations and input/output operations using forms/reports. Suitable tables are selected and lined with input forms. Suitable quieries are created to get the filtered results of the tables. The results are displayed in the reports.

References

A Web Based Approach towards the Automated Generation of ER-Diagram. (2015). International Journal of Science and Research (IJSR), 4(11), pp.1964-1966.

Al-Masree, H. (2015). Extracting Entity Relationship Diagram (ERD) From Relational Database Schem. International Journal of Database Theory and Application, 8(3), pp.15-26.

contributors, p. (2018). phpMyAdmin. [online] phpMyAdmin. Available at: https://www.phpmyadmin.net/ [Accessed 10 Jun. 2018].

Ict.griffith.edu.au. (2018). Home. [online] Available at: https://www.ict.griffith.edu.au/~jw/normalization/ind.php [Accessed 10 Jun. 2018].

Ischool.utexas.edu. (2018). Overview of Normalization: Database-Management Principles and Applications, LIS 384K.11, School of Information, The University of Texas at Austin.. [online] Available at: https://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normover.html [Accessed 10 Jun. 2018].

Sauter, M. and Is, L. (2018). Exports and Reports. [online] WordPress.org. Available at: https://wordpress.org/plugins/exports-and-reports/ [Accessed 10 Jun. 2018].

Shsu.edu. (2018). Normalization of Database Tables. [online] Available at: https://www.shsu.edu/~csc_tjm/summer2000/cs334/Chapter05/Chapter5.html [Accessed 10 Jun. 2018].

SILBERSCHATZ, A. (2018). DATABASE SYSTEM CONCEPTS. [S.l.]: MCGRAW-HILL EDUCATION.

WordPress.org. (2018). Blog Tool, Publishing Platform, and CMS — WordPress. [online] Available at: https://wordpress.org/ [Accessed 10 Jun. 2018].

WordPress.org. (2018). Ninja Forms – The Easy and Powerful Forms Builder. [online] Available at: https://wordpress.org/plugins/ninja-forms/ [Accessed 10 Jun. 2018].

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order