database-design tutorials

Best Solution to Create a change History for several SQL Tables

Jun 05, 2022

sql sql-server-2008 database-design

How to store DropDownList information in SQL

Nov 14, 2022

sql-server database database-design drop-down-menu

Facebook photo renaming convention

Dec 23, 2017

facebook security database-design

Should primary keys always be added to an innodb table?

May 23, 2022

mysql database database-design indexing database-optimization

Disadvantages of setting the whole DB charset to Unicode vs some NVARCHAR2 in Oracle DB?

Apr 07, 2019

database oracle database-design unicode oracle11g

Is it ok to have cyclic foreign key dependencies in a relational database?

Sep 23, 2022

database-design foreign-keys directed-acyclic-graphs

How can triggers and stored procedures be represented in an ER Diagram?

Mar 20, 2022

database database-design uml entity-relationship

Primary key composed of two foreign keys? Oracle

Aug 31, 2022

sql oracle database-design foreign-keys primary-key

Best way to model Natural and Legal Customers all together

Feb 04, 2022

database-design

How to programmatically check if row is deletable?

Nov 11, 2020

sql postgresql database-design plpgsql sql-delete

Specify foreign key on one column and the value of another column

Aug 08, 2022

sql database database-design schema polymorphic-associations

How to model messages exchanged between users? - ER Diagram

Sep 14, 2022

database-design erd entity-relationship

User-Role-Permission based database design

Mar 07, 2022

sql database oracle database-design

Database Design - Best way to show available hours?

Sep 17, 2017

mysql database database-design

a layman's term for identifying relationship

Apr 16, 2022

database database-design data-structures data-modeling entity-relationship

Private messaging system, large single table versus many small tables

Jan 15, 2019

mysql database database-design

Best way to store sales tax information

Oct 14, 2022

sql database-design

Database design: objects with different attributes

Aug 13, 2022

mysql database-design innodb

Designing a database

Jun 20, 2022

sql-server-2008 database-design

How to store "same as" data?

Sep 27, 2019

database database-design

New posts in database-design