Badge System

For this badge system you will need several electronic components.

• Raspberry Pi 3B
• Arduino Uno
• Buzzer
• Led red and led green
• PIR
• LCD Display
• RFID scanner
• Realtime clock
• 4x 7segment display
• a lot of jumper wires

This is how I connected my components to my Raspberry Pi 3B and my Arduino Uno.

For connecting the LCD screen you can use an I2C.If you have enough GPIO pins left on your raspberry, it isn't necessary to use I2C.

Here you can see the connection with and without I2C.

First I made the database on my computer with MySQL Workbench.

1. The first thing to do when putting up a database is drafting your ideas.
2. After that you make a normalized sketch
3. When you're done sketching it's time for working out the sketches in Workbench.

For this project you need 3 tables:

• One for the staff
• One where you keep the data from the RFID
• One for Zipcodes and places

Once your database is up, you can put it on your Raspberry Pi. In the video I will give a short tutorial how to put your MySQL Workbench database on your Raspberry Pi.

• What do you want your badge system to look like?
• What material would you like to use?
• Does it need to stand, hang, lay,...?

Those are all things you need to think about when you make the casing. As you can see in the pictures, I made mine out of wood. I drew everything I thought off down on a paper, went to the local DIY shop and bought some wood and glue. I made holes in the wood to insert my components.

Frontend

I made a user site where the users can put data in the database or where they can delete it if nessecary. For the site itself I used HTML and CSS and for the animations and the connection with the database, I used JavaScript.

Backend

The backend is for communication between the database and the frontend. Its code you put on your Raspberry Pi. It is made in Python. This is my Python code.

This is the end result! hope you liked it.