Tagged Questions
-5
votes
2answers
121 views
Challenge: Build MySQL table that's not in first normal form [closed]
I have read numerous books and articles about database design and SQL in which it is said that a database should be in first normal form (1NF). (Some then go on to describe situations in which it may ...
2
votes
1answer
177 views
Splitting a column to normalized table
I have a de-normalized table as
Original De-Normalized Table
id text
23 first,second|third,fourth,fifth|sixth
I want to normalize the database to create the following tables
Table 1: (Split by ...
2
votes
4answers
216 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
3answers
165 views
is id and phone number enough to uniquely identify a row in phone numbers
Was designing a table a customer_phone_numbers table a while back, which only purpose was to allow us to store as many phone numbers as a user wanted to have on file. I originally came to the ...
4
votes
3answers
321 views
Database Design Issues
My question consists of three parts:
When can I be sure that my database design is perfect?
Is returning to the database design to change some issues (i.e, adding new column, deleting a column, ...
4
votes
4answers
1k views
Storing arrays of integers in database (for efficient select)
I am creating a database that will store 100.000 (and probably more in the future) users. While this obviously happens in a table with 1 row per user, every user can (and will) store hundreds of ...
4
votes
3answers
1k views
Query to normalize table/combine row text
I have a table (call it oldTable) with columns like so:
ID (int),Rank (int),TextLineNumber (int),SomeText (varchar)
The primarykey is multi-part: ID+Rank+TextLineNumber.
I'm trying to ...
