Hello fair forum members of sqlteam!
My name is Connor, and I'm a high school student. I've joined an internship with the school district and we are going 1 to 1 next year for Chrome books. Part of the internship is that we need to create a database/inventory system to store barcode values that associate with student IDs.
Everyone in the district is given a student ID with a barcode on it (unique) that I'd use for the key for the database, but then we need to store 3 bar codes after that (and possible more data thereafter).
I have done a good amount of programming in Java, and have a decent understand of different ADT's, but I have never dealt with databases and need a bit of help.
Can someone point me in the right direction?
The system would work as follows:
We populate a Microsoft SQL database with the Student ID's
Use a barcode scanner to scan the barcode from Student ID
Scan the product id barcode on the bottom of Chrome book and power brick and charger and save it to the database associated with the student ID.
I have no idea where to start, can anyone give me some places to start looking, and or what we will need to create this system?