Tagged Questions
0
votes
0answers
14 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
21 views
Data-centric application: separate database tables for separate organizations a good idea?
I am building an application where several organizations can register
themselves and manipulate a set of enterprise tables such as list of
clients, sellers, items, sale orders etc... I was wondering ...
-1
votes
1answer
24 views
Can a relationship be defined when two tables can be parents to a child table
Based on the domain rules, a Parcel may have have 0 to many Buildings associated with it. Also a Parcel may have 0 to many Extra features. A Building may have 0 to many Extra Features.
So, in short ...
0
votes
3answers
19 views
Correct way of modeling my Database
I have trouble finding the best solution to create my database. I have 3 entities : Restaurant, Supplier And SubSupplier.
Each restaurant can order to any Supplier. If the Supplier has SubSuppliers, ...
-1
votes
2answers
23 views
What makes sense to ccreate index on tables? [closed]
What Make sense of Creating Index Why we new to Create Index Actually ?
What actually the Selectivity will do with Indexing ?
What actually if we do Indexing on Unwanted Columns ??
When to do ...
0
votes
1answer
72 views
Travel social network database design
I'm creating a database for a travel social network application that I'll build next. This is my work so far. Table names are pretty self-explanatory. My question is - is this good approach? I would ...
0
votes
1answer
56 views
Advice on database design and table structure needed
Im new to programming and databases in general. I've read PHP.MYSQL for DUmmies 4th edition thus far, and am trying to create a database of my own which stores the Menus/Inventories of shops. I am ...
0
votes
1answer
31 views
Copy Shop database design
I'm trying to design a database and am wondering if my design makes any sense at all.
I'm trying to design a database for a small internal Copy Shop to track orders and price jobs. I thought ...
0
votes
0answers
23 views
Which of these Database Designs For Role Permissions is better?
I'm new in database designing.
I'm not sure which schema is more convenient and efficient to use?
Model 1
Model 2
Admins of each group in the social network are able to define several ...
2
votes
1answer
28 views
Database Historical Data
How would I go about keeping track of a history of a database? I would use it almost completely for statistical purposes. For example it is easy enough to query the database to find out how many ...
1
vote
1answer
51 views
Pull data from multiple records into one row
I want to pull out the data from multiple records and insert them into different fields of a single record in another table. The work I am doing requires me to pull the cw_cat_total field(which is the ...
-1
votes
1answer
22 views
A lucky draw system [closed]
I am creating a lucky draw system whereby the participants' username will be stored in either a file or a database and later one of the username will be picked as the winner. Each product has many ...
0
votes
1answer
47 views
primary key to foreign key to foreign/primary
there are tables in database like
tbl_items
item_id item_batch item_name
(primay key = item_id+item_batch)
tbl_transaction(orders)_header
ordre_id employe_id date
...
1
vote
1answer
32 views
Is it well designed relational database just with one table?
I have MySQL database containing just one table, having 100 rows and 12 columns: ID (primary key), NAME, LATITUDE, LONGITUDE, TYPE, COUNTRY, CONTINENT, DESCRIPTION_PATH, STORY_PATH, PICTURE_PATH, ...
0
votes
3answers
99 views
SQL Structure for Buildings with Amenities
I have a problem that I cannot seem to find a solution for. I have browsed similar answers around here, but nothing was exactly what I was looking for. I am fairly familiar with SQL, but not an expert ...
