reaanb questions

reaanb answers

• How to show composite keys in Chen E-R Diagram
• Determine the closest free set of X/Y coordinates within an ever expanding 2D grid stored in MySQL
• Easiest way to compare two files with lists of song titles
• Best practices to enable/disable/delete database rows and its references?
• is optionality (mandatory, optional) and participation (total, partial) are same?
• When to use multiple databases vs multiple tables
• When to use Associative entities?
• What will be the best database for video streaming website?
• SQL Database design for statistical analysis of many-to-many relationship
• Weak entities and foreign keys