By Simon Navarro
There are three main parts of this RFID project: the Rfid reader and the processing, the sql server, and the web page.
The first part I would recommend doing first is the sql server since that will be the intermediary between the RFID reader and the webpage.
How to Create a SQL Database on azure
- Sign into your Azure account then go into the Azure portal.
- Under Azure Resources, create a resource or click on SQL databases.
- Create a new resource group and enter a database name. Then create a server. Please write down your credentials for later reference.
- Select compute and storage. I selected general purpose serverless since I was doing R&D and didn’t need much In/Out operations per second. You can change max storage size since the amount of data being stored is little and can be changed at any time. For this, I selected 8 GB since the RFID cards being used can hold 1kb, meaning that it can hold 8 million card scans.
Using Microsoft sql server management studio to set up your database
- First install the software at Install link or search up ssms.
- Sign into your SQL server using the credentials your wrote down while following the instructions for How to Create a SQL Database on Azure.
- Right click on Databases. Then click on New Database and name it "RFID Information," or whatever you choose — just make sure you remember it!
- To create the table, you must create a new Query near the top bar and change the Database from master to RFID Information.
- Input the query you made, then execute it.
CREATE TABLE RfidData(
FirstName varchar(48),
LastName varchar (48),