How to use database creators to create a personal preferences programme?

Asked By Jai Zadok 60 points N/A Posted 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?

• Status: Open
• Question Views: 620
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Gazelle Eliza 0 points N/A #156732

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. 

About Gazelle Eliza

Questions
3

Answers
30

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/21/2012
• Question Category: Misc Databases