database-normalization

相关标签：javascript jquery android 多少钱 iPhone

1 to 0..1 relationship - which way should FK point?

Say I have a customer table with 1:0..1 relationship with another table, I would normally have a Nullable FK in the customer table pointing to the other table.[详细]

2023-04-12 08:19 分类：问答
Which normal form does this table violate?

Consider this table: +-------+-------+-------+-------+ name|hobby1 |hobby2 |hobby3 | +-------+-------+-------+-------+[详细]

2023-04-10 20:18 分类：问答
Compacting tables after normalisation

I recently increased the level of normalisation in my database, going from something like this: +--------------------------------------+[详细]

2023-04-06 10:52 分类：问答
Normalization: Is it considered Normal Form compliant to split static, numeric values like a year into their own table?

I am having an interesting discussion with another database designer about normalization. In this example, we have a GameTitles table and each record mu开发者_如何学Gost contain the year in which the[详细]

2023-03-29 11:08 分类：问答
What is the best way to implement Polymorphic Association in SQL Server?

I have tons of instances where I need to implement some sort of Polymorphic Associa开发者_JAVA百科tion in my database. I always waste tons of time thinking through all the options all over again. Here[详细]

2023-03-27 09:35 分类：问答
Using IDs from multiple tables in a single column

The system rules: Departments can have 0 to many divisions. A division must belong to only one department.[详细]

2023-03-26 03:29 分类：问答
Can a relation in Boyce-Codd Normal Form have functional dependencies between prime attributes?

My question is pre开发者_JS百科tty simple. From what I\'ve seen, it seems normalization from 1NF, 2NF, 3NF up to Boyce-Codd form seem to deal mostly the matter of non-prime attributes. If I am not mis[详细]

2023-03-21 12:51 分类：问答
Couple of normalization questions

My questions are: 1) If I have the relation R(A,B,C), being AB the primary key, and F = {}, may I assume C depends on AB? I\'d say no, but I\'m asking just to make sure.[详细]

2023-03-21 10:26 分类：问答
Designing without duplicate foreignkey references in Django

I want to create an expense tracking application, where each user can enter expenses and classify them into his own categories. Here is the model definition that I use:[详细]

2023-03-14 19:40 分类：问答
Data normalization and writing queries

I\'m a jr. developer (5 months on the job), and I have a question about data normalization. Now, as I understand it, the general principle behind data normalization is to create a RDBMS where data red[详细]

2023-03-14 18:13 分类：问答