Database design is the process of specifying the logical and/or physical parts of a database. The goal of database design is to make a representation of some "universe of discourse" - the types of facts, business rules and other requirements that the database is intended to model.
-8
votes
0answers
35 views
database structure for dating site, need lots of column and advice [closed]
i want to create a database for dating site, i don't know how many table should be there and
i need lots of column names. i have only id, username, first name,
last name, age, sex, country, zip, ...
1
vote
1answer
26 views
How to implement referential integrity here?
I got the following structure - which I admit is not ideal, but so much is built on that, tat I want to minimize changes.
I am not sure about how to properly implement referential integrity between ...
2
votes
2answers
69 views
Stores millions of daily IP address logs
We have one click tracking system where i am tracking IP address of each request.
Each day we are getting millions of hits.
And for each request and storing IP address as 1 row in MySQL
We also ...
-1
votes
1answer
22 views
database creation using c programming [closed]
HI I want to create database using c programming.
I want to create the employee database system and want to update it dynamically.
please guide me how can I go ahead.
this I have to do it for ...
0
votes
0answers
12 views
fact table : colums with same data and different meaning
I have fact table that contain data about foreign trade(import/export of goods), and i have 2 columns, named : coutryFrom and countryTo, the coutryFrom is the country from where the goods is comming ...
0
votes
0answers
5 views
ruby datamapper breakdown of Serial vs String property for key
Should every table have a Serial id? When would you need one, when wouldnt you? (associations, performance, etc?)
YouTube identifies videos with a key like "ttpYdIodMWc". I want something similar, ...
0
votes
1answer
53 views
Adding columns to database table dynamically?
I'm using Java J2EE, oracle db and JPA:
I need to create a common table in oracle. It can be edited using an ui, for example:
id|tax1|tax2|tax3
------------------
1 | 5 | 16| 9
2 | 7 | 1 | 8
...
0
votes
1answer
21 views
Composite primary key in dimension table
I have a dimension table with composite primary key ex :
Operateur:
centre
registreDuCommerce
libelleCentre
LibelleRegistreduCommerce
The primary key is: centre, registreDuCommerce
And the fact ...
2
votes
4answers
57 views
Dynamic input to database
I'm working on an app that lets a user create projects custom to the users needs, the project is basically a form that can be submitted by another user.
I want to allow the user to dynamically create ...
0
votes
0answers
32 views
How define relational database to a specific application
Evening,
I have a little problem to create my data model.
To be simple in my web program :
There are servers, such as mumble, game server, etc.. (I suppose a table)
There are commands for a server ...
0
votes
2answers
24 views
How to get a way to distinguish the queries with union
I am creating a blog in php/mysql where the user can post text or image.
If it's a text, then it has an url like this: www.example.com/text.php?id=...
If it's a image, then it has an url like this: ...
0
votes
1answer
36 views
Optimizing National ZIP+4 database for fast address lookup
I've just obtained a large set of text files (8 GB total) containing all of the address ranges within the U.S. The set consists of:
929 ZIP+4 files, each containing postal addresses of unique
...
0
votes
2answers
29 views
MDB data type that allows decimal points in numbers?
What data types in MDB (MS Access) database format will allow decimal points in numbers?
1
vote
0answers
27 views
Testing table performance normalized vs denormalized
we are planning to adjust your DB-structure to a more flexible layout. For each person a set of values is stored, which differs from client to client (that means, the clients of our clients). We want ...
-1
votes
1answer
33 views
my sql multiple category-subcategory-subcategory
category subcategory subcategory
jewelry body nose ring,arm ring,ear ring
men ring,ear ring
I have multiple category->subcategory->subcategory so how will be the ...
