Tagged Questions
0
votes
0answers
9 views
Model a binary decision tree database in mySQL
How would i model a binary tree help desk solution in a mySQL database?
Problem ---> Questions -----> Solution
RootNode---> Decision Nodes ----> Leaf Node
thanx
2
votes
2answers
41 views
MySql retrieve products and prices
I would like to retrieve a list of all the products, with their associated prices for a given period.
The Product table:
Id
Name
Description
The Price table:
Id
Product_id
Name
Amount
Start
End
...
0
votes
2answers
19 views
localizing existing database
We have a small mySQL database with about 20 tables (All in english).
Would it be possible to localize this database now that it has already been designed and has multiple thousands of records?
What ...
1
vote
1answer
38 views
Customers, Suppliers and their Employees
I'm designing a marketplace where customer can order products from suppliers. I need help in defining the database scheme.
I have two types of companies: Customers and Suppliers. Suppliers can have ...
0
votes
0answers
17 views
Shard tags table strategy
I have a simple table in mysql called "tag" which has the columns: tag_id (PK), tag_name (unique), creation_time, I also have another table called tag_article which has article_id and tag_id.
the ...
1
vote
2answers
29 views
SQL structure to count size of a queue through changes over time
How can I design an SQL data structure that will let me query how large a queue was (how many records) over time (so I can graph it), when the items constantly move from queue to queue.
Tables:
...
-2
votes
0answers
20 views
Creating tables for staff members [closed]
http://www.imagesocket.com/photos/guest/2618563
I have the following table in word which I want to Create into MYSQL Database.
I want to ask how many tables should I make and how many columns in each ...
1
vote
2answers
35 views
User owns/manages other users
I have table Users with ID, username, password & type columns. I'd like to add hierarchy by making a regular user, a superuser who can manage a few regular users. It's only 2 level.
Should I add a ...
0
votes
4answers
28 views
What database structure should be used to include table rows in multiple categories?
I have a table within a MySQL database with various data in it (for the sake of example, let's give it the following:
ID | Place | Phone | Email | Category
Now, I want to redesign ...
0
votes
0answers
20 views
Database design advice for mobile phones with variations
I am building a mini site that will allow people to search for gadgets (phones, tablets etc..) by name and model number, the issue I have is how best to setup the database when you take into account ...
0
votes
2answers
17 views
2 unique field combination vice versa
Hello is it possible to have a combination of 2 fields vice versa ?
Example:
ID catID
1 58
So that we couldnt store another row as 58-1. Currently I have primary key on both fields, but it ...
0
votes
0answers
28 views
Table aready exists when creating MySQL trigger
I get a Table 'fundingsource' already exists when attempting to create MySQL trigger:
-- Trigger DDL Statements
DELIMITER $$
USE `remis_sandbox`$$
DROP TRIGGER IF EXISTS tr_archive_fundingsource$$
...
1
vote
2answers
60 views
Storing dynamic data in NoSQL
I have scenario where I need to store unstructured data but the rest of my data is structured and relational. An example of the type of unstructured data is as explained below:
User Type 1:
How do ...
0
votes
1answer
29 views
Am I wrong in table design or wrong in selected index when made the table?
I've build web application as a tool to eliminate unnecessary data in peoples table, this application mainly to filter all data of peoples who valid to get an election rights. At first, it wasn't a ...
0
votes
1answer
28 views
Optimize multiple self-JOINs or redesign DB?
I'm looking for advice on either optimizing multiple self-joins, or a better table/DB design.
One of the tables looks as follows (relevant cols only):
CREATE TABLE IF NOT EXISTS CountryData (
...
