Need assistance in creating a database...

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Need assistance in creating a database...

Post by Anakha56 »

Morning All,

So I want to setup a SQL database for our supplies. What I need it to do is when we receive our supplies we scan a barcode (different amounts barcodes) for that supply eg: A5 paper and it updates the amount on the database, it must also have a Insert date&time stamp. When we take the supplies out we scan another barcode to update that stock has left our side again with a time&date stamp. When that stock reaches a minimum level the database must also send out an email alert for us to order more.

So... How do I go about doing this? :oops: In Excel I have made a visual of how the database should look I just need help in getting it off the paper and into actual.
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

Ouch.... not ganna happen that easily. You probably won't be able to do all that in SQL itself but you have a couple of options. Either create your tables and store the data in SQL server and make like Tribble and do an Access front en to handle the input of data or make like Tribble and get yourself a developer to do it for you.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

Sorry forgot to specify a few more things. My time is getting a tad fragmented. I will be creating the HTML front end for scanner input and with that I will need a little help in getting it connected to the SQL database.

So SQL will store the data.
A HTML front end will input the data into the SQL database.

/I am also using the forum as an idea sounding board. To try get my thoughts about this project in order...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Need assistance in creating a database...

Post by Tribble »

Was going to say you needed a front end - but you beat me to it. RRF should be able to tell you how to connect the two.
Image
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

You know WonWon has a link in his signature about how to ask an question... some very good advice there.

What web server will you be using?
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

:lol: Like I said I am still trying to understand myself what I need to make this work. Sorry... :oops:

Web server will probably be something that will be setup on one of our spare machines, so WinXP/7 using XAMPP?
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

OK so XAMPP means you are running Apache and PHP.. SWEEET and EASY.

Do you know PHP? if not you might want to have a read....
http://www.php.net/
http://devzone.zend.com/article/627

The second link will cover all you need to know including how to connect to the database and run queries. For MS SQL Server I know you will need to download a driver which is easy to google for. That is unless you are using the MySQL which is already included in XAMPP for which there is also a tutorial in the second link.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

It will be MS_SQL :).

Thanks for the links, will do the required reading next week in my night shift week :).
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

Creating databases in MS SQL is considerably easier as SSMS is probably the best DBMS tool there ever was. Not even the tools you get with Oracle can compare in terms of usability.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

Okay you just went way over my head... :P

SSMS?
DBMS?

:P
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
User avatar
hamin_aus
Forum Moderator
Posts: 18363
Joined: 28 Aug 2003, 02:00
Processor: Intel i7 3770K
Motherboard: GA-Z77X-UP4 TH
Graphics card: Galax GTX1080
Memory: 32GB G.Skill Ripjaws
Location: Where beer does flow and men chunder
Contact:

Re: Need assistance in creating a database...

Post by hamin_aus »

RuadRauFlessa wrote: SSMS is probably the best DBMS tool there ever was. Not even the tools you get with Oracle can compare in terms of usability.
True.

Over the last few releases of both Oracle and MSSQL, Oracle have been refining their admin and dev tools to be more like MSSQL, while Microsoft have been tweaking their SQL engine to run more like Oracle...
Pretty soon the two offerings will be practically homogeneous!
Image
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Need assistance in creating a database...

Post by Tribble »

SQL Server Management Studio
Image
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

@ jamin_za
Which would be something to look forward to... best of both worlds.
@ Anakha56
SSMS = SQL Server Management Studio
DBMS = Database Management System

SSMS is a tool through which you manage a DBMS.
A DBMS is an engine in which you create and manage various databases.
If you talk about Oracle or MySQL or MSSQL (Microsoft SQL Server) you talk about a DBMS not an actual DB (DataBase)
MySQL is probably the best example to use as it employs various types of databases within the DBMS of which a few to mention is MyISAM and InnoDB. So the idea is simple. Yo run a DBMS with multiple instances of various DB's.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

Ah thank you :). Busy installing SQL Server 2008 r2 (full not express) now. Takes forever and a day...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Need assistance in creating a database...

Post by Tribble »

It is a long install - but it is easy. Just all the other things it needs can be a bit of a pain if the client has not done regular updates to their machine.
Image
DeathStrike
Registered User
Posts: 2663
Joined: 29 Jul 2004, 02:00
Location: hidden deep in the depths of the underworld is my home.
Contact:

Re: Need assistance in creating a database...

Post by DeathStrike »

mmm. have you tried looking forr an open source system? you get things like zen_cart for online stores surely there are systems that have this already and then you could just customise it.
Spoiler: (show)
Image
SIG by HMAN 8)
Member of The Pride Of Darkness
DeathStrike on Twitter
About me
Spoiler: (show)
Asus P5KPL-CM motherboard, 4 GIG RAM, Q6600 @ 2.88GHz (Thanks Anthro), GeForce 8600GT, Samsung 2333 23" + CRT 17" Monitors. 500GB + 1.5TB HDD, Compro TV tuner, 350 WATT PSU
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

DeathStrike... from experience I know that Open Source looks like a nice and quick solution but generally the peoples' code is so badly written that it takes longer to change what they did than to simply do your own thing.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
Forum Administrator
Posts: 22136
Joined: 14 Jun 2004, 02:00
Processor: Ryzen 1700K
Motherboard: Asus X370
Graphics card: Asus 1060 Strix
Memory: 16GB RAM
Location: Where Google says

Re: Need assistance in creating a database...

Post by Anakha56 »

Also it will be "bloated" with things I dont need. Good suggestion and I will keep it in mind however I would like to create my first database type project all by little self with help from the forums :).
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need assistance in creating a database...

Post by RuadRauFlessa »

And helpful the forums you will find :mrgreen:
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Post Reply