Inspiration

Since everyone on the team was an Office fan, we decided to develop an Office-themed business idea of creating a website for a company.

What it does

The website has multiple parts to it, like any great website. A customer will be able to book appointments based on a specific company's agents' availability. The customers will be able to check when their agent is free and book the appointments accordingly. On the corporate side, the employees are able to do a wide variety of things. They are able to access their individual appointment records, make new or cancel appointments, place, update, or cancel an order, and create new client accounts. They also have access to the company calendar from which they can edit appointments. All the appointments, client records, employee records, and orders are kept in a secure database. This allows a smooth client and employee interaction without needing to have unnecessary verbal interactions.

How we built it

We used HTML, CSS, and JavaScript to build the user interface of the website. For the backend programming, PHPMyAdmin was used to build dynamic databases and PHP was used to connect the backend with the frontend. To update the databases, SQL queries were utilized.

Challenges we ran into

Some challenges we ran into are connection issues that we faced while connecting the website to the databases. To overcome that, we had to try multiple SQL queries and resort to some intensive research. Another difficulty we ran into was figuring out the management of joining multiple tables using SQL Join queries.

Accomplishments that we're proud of

We are proud to have built a fully functioning website within the time limit that was provided. It had many ups and downs but we were able to work together to accomplish a common goal. Our biggest accomplishment is to have figured out how to incorporate SQL databases with scripting and programming languages. We are also proud of overcoming our challenges and having learned something along the way.

What we learned

We learned how to incorporate multiple languages to build software. It was a very unique experience from which we learned much worthwhile information. Using so many languages in one project is something we have not done before and accomplishing that is something we are very proud to have done.

What's next for OfficeVerse

OfficeVerse can be seen as not only a website for Dunder Mifflin but also for any corporate company that needs a website that connects the clients to them.

TIPS

Just a tip for the judges and other viewers: Please use headphones when listening to the video or else the volume might be too low and you will not be able to hear anything clearly. Thank you!

Share this project:

Updates