N/APosted on - 09/17/2012
I need to take help of database creators to help me create a programme that will track personal preferences in terms of items purchased, returned and season choices. I do have some knowledge of SQL but I am not able to figure out if I should pull data from multiple SQL databases or can I use a single program?
How to use database creators to create a personal preferences programme?
I would suggest a single program, use MYSQL which is an open source stable database server and create table for each data you want to pull (item purchased, returned and season choices) design the database as to that each table is in relationship with the other by using foreign key and by assigning primary keys to it, execute SQL JOIN and depending on the front end you are using display the resulting query nicely and organized.