Database design is the process of specifying the structure and thus the logical aspects of a database.
Can someone please explain the difference between 3NF and BCNF to me? It would be great if you could also …
database-design relational-database database-normalization 3nf bcnfI'm a software developer. I love to code, but I hate databases... Currently, I'm creating a website on which a …
mysql database design-patterns database-designHow would you design a database to support the following tagging features: items can have a large number of tags …
sql database-design tags taggingAs a follow up to "What are indexes and how can I use them to optimise queries in my database?" …
sql-server database optimization database-design indexingIs there a reason why Oracle is case sensitive and others like SQL Server, and MySQL are not by default? …
oracle database-design case-sensitiveLet's say that I have a record in the database and that both admin and normal users can do updates. …
database-design architecture versioning auditingSo, I've been reading up on identifying vs. non-identifying relationships in my database design, and a number of the answers …
database database-design relational-database identifying-relationshipImagine a web form with a set of check boxes (any or all of them can be selected). I chose …
database database-design database-normalizationLet's say you have a table Orders with a foreign key to a Customer Id. Now, suppose you want to …
database-designLet's say I have two tables: Table: Color Columns: Id, ColorName, ColorCode Table: Shape Columns: Id, ShapeName, VertexList What should …
sql database database-design naming-conventions data-modeling