Database design is the process of specifying the structure and thus the logical aspects of a database.
I'm using a decimal column to store money values on a database, and today I was wondering what precision and …
sql database database-design currencyI'm thinking about how to represent a complex structure in a SQL Server database. Consider an application that needs to …
sql-server inheritance database-design class-table-inheritancePossible Duplicate: mysql datatype for telephne number and address Any suggestions on best practice to store telephone numbers in a …
mysql string database-design formatting intI have been searching all over the internet but I couldn't seem to find an answer that I can understand. …
database oracle database-design cardinalityI need to create a database table to store different changelog/auditing (when something was added, deleted, modified, etc). I …
database database-design auditWhen should a View actually be used over an actual Table? What gains should I expect this to produce? Overall, …
sql database-design viewI'm putting together a simple test database to learn MVC with. I want to add a DateTime field to show …
database database-design datetime sql-server-express fieldI have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL PRIMARY KEY, UserId uuid NOT NULL, …
sql postgresql database-design null referential-integrityI've heard of a few ways to implement tagging; using a mapping table between TagID and ItemID (makes sense to …
sql database-design tags data-modeling taggingI'm trying to learn about OLAP and data warehousing, and I'm confused about the difference between relational and dimensional modeling. …
database-design database relational-database non-relational-database