I am working on a project involving cards from the Magic: The Gathering game. To be of any use, I must load the basic information about each card into my database, but some of the fields may contain ...

What is the best way to get database unique surrogate keys in Microsoft SQL Server when using something like “auto increment” as opposed to GUID's. The purpose is to increase performance over using ...

I have the following table. The PK is model_ID.
Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName ...

I have the following table. The PK is model_ID.
Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName ...

I am taking college classes in relational databases for half a year now. As an assignment get to normalize data with 1NF, 2NF and 3NF.
I do not find any difficulties making my schema compatible with ...

I'm looking for a specific "best practice" or "pattern" concerning entities that are shared between different entities, having a relation to one of many.
For example, one may have the generic entity ...

I'm creating a normalized table for a questionnaire that the customers fill in and in one of the columns is a field called "extra comments". I realize that with the "extra comments" field, the data ...

I have some data that I am having a hard time modeling. Particularly, I am unsure of how I can ensure that I have unique data. This is for a schedule where I am assigning teams to stores. A team will ...

I would like some advice on how to design the database for financial statement data which objectively addresses the tradeoffs between usability, performance, maintenance and adherence to normal form. ...

Hey guys I am trying to study for an exam and I cant seem to get my head around normal forms.
here is one question:
R1 [a b c]
fd1: {a,b} -> {c}
fd2: c -> b
I know the candidate keys are
{a,b}
{a,c}
...

Say I have a table entities (subclassed by people and organizations tables), where each entry requires a primary_email_id. The entities table looks like this:
entities
========
id INT AUTO_INCREMENT
...

Alright, so basically I feel that I tend to over-normalize things, and maybe I am doing it at the cost of performance. So, to illuminate on the problem, I have created the following schema to use as ...

I've been working with SQL databases all my life and I am now trying to get into the NoSQL world. I am a looking for a piece of advice on whats the best practice in order to achieve this.
Suppose I ...

This question is pretty specific but I hope it can get answered on here. There is a wide range of information about normalization but I feel what I have read so far isn't as effective as just stating ...

It's been about ten years since I paid real attention to fourth normal form, and my understanding of multi-value dependencies has seriously waned. How far is this table from 4NF and why?
CREATE TABLE ...

I recently got added to a new ASP .NET Project(A web application) .There were recent performance issues with the application, and I am in a team with their current task to Optimize some slow running ...

I have a question about how to best handle a table that would be shared among multiple relationships, but shouldn't really be joined with all these tables. For example, suppose I have a table that has ...

I am a developer (student) looking for some advice on what best approach should I follow while creating a table to model an entity that has a number of optional fields.
There exists a need to model ...