Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this
I\'m attempting to create a database model for movie classifications, where each movie could have a single classification from each of one of multiple rating systems (e.g. BBFC, MPAA). This is the cur
Do you see database triggers / referential integrity rules being used in a way that changes actual data in the database (changing row w in table x causes a change in row y in table z)?
I understand the need to have referential integrity for limiting specific values on entry or possibly preventing them from removal upon a request of deletion. However, I am unclear as to a valid use c
My application involves using submitting data (the \"request\") from a form into an SQL Server 2005 database, for later review and approval开发者_如何学Python by a supervisor. Users should have permis
I have two databases in a php / mysql application.One for user data and the other for content. I have recently had to ma开发者_开发百科ke use of inno db tables in order to enforce some referential in
I am developing an archive module for an application using Dotnet and SQL Server as back end. From multiple approaches of archiving we\'ve decided to build a custom application to archive the complete
In the past, when I implemented my own authentication mechanisms I would have a user table with relationships to other tables in my application\'s MySQL database.However, now that I\'m considering usi