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.
2
votes
1answer
33 views
Model with variable number of “properties” of different types.
I would like to have a table of microscope slides, where on top of the basic id, name,date_created would each slide also have a number of editable "properties".
Imagine one slide having
...
2
votes
1answer
48 views
Database design for Magazine website
I need to design a CMS based website using asp.net web form (c#) and MS SQL Server as backend database for a magazine website which will have monthly issue.
I am finding it hard to design a database ...
1
vote
1answer
55 views
What is the best database design for multi-language data?
I am designing a multi-language database for a piece of software with the following features:
data used in every country differs from other countries
data used in every country will be in 2 ...
3
votes
2answers
93 views
Database design: where do I put this data?
EventCategory
=============
EventCategoryId PK,
Name
Event
=====
EventId PK,
EventCategoryId FK,
Name
This is what I've got now. However, events of some event category type need extra data fields. ...
0
votes
0answers
49 views
What is the concept of a “master table”? [closed]
I have heard the term "master table" thrown around by our data services department and I'm wondering where that term was coined from or if it is something they made up. From what I gather their ...
-1
votes
0answers
56 views
Problem with relationships between tables in database design [closed]
I have a problem with my tables. I'm not understanding the relationships between my tables.
A business customer has a membership. Memberships can be of categories such as Bronze, Silver and Gold. A ...
1
vote
0answers
31 views
Regularly import tab-seperated log file to MySQL
I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
2
votes
4answers
98 views
Does my table violate normalization rules?
I am developing an emulator for a game. My item table looks like this:
-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
...
1
vote
2answers
61 views
Synchronising SQL tables in two locations
have a bit of conundrum a the minute.
ANSI sql solutions please.
We have two databases located at two different geographic locations and will be using the web for all traffic between the two ...
-2
votes
1answer
104 views
Need help in DB design?
software will used in many countries ..each country products differ from others and these products will be available in 2 languages: english, the native language
.
i start designing a DB for each ...
6
votes
2answers
138 views
Should a log table get an id field or primary key?
I have a log table that captures the datetime stamp of when certain files were exported to another system.
The exportedLog table currently has three fields:
id (primary key)
messageId ...
1
vote
1answer
40 views
Does this design satisfy 3NF, and can any improvements be made?
Does this design satisfy 3NF, and can any improvements be made?
If it does not satisfy 3NF - why?
By improvements, I only care if it will seriously affect scalability, efficiency, etc - I'm not ...
1
vote
1answer
31 views
Null Values and Performance
I always try to build the database avoiding any NULL values in my tables, and I have successfully had done this so far. (Hey, I am very new to database design.)
But still there are times when saving ...
0
votes
1answer
61 views
Trouble in Multi-Language DB
I'm working on a DB design for medicines in many countries with different languages. I created a table for the different languages I want and link it to another table of chemicals. But I find that ...
2
votes
3answers
65 views
Merging tables with a 1 to 1 relationship in a database
Is it a good idea to merge two tables that have a 1..1 relationship together?
I have inherited a database with too many tables linked together in a 1..1 relationship. I'd like to evaluate the ...
