Suppose you have a lookup table that has a couple default options that your Business Logic layer depends on, but you want to allow the users to add/update/delete records in that table.For example, a C
I am building an EC website for a customer and the project manager came with some strange ideas and I am struggling to actually implement what he sold to the client.
We are launching a website (paid subscription) and the sign up process includes entering an activation code. Activation codes are printed on scratch cards and sold via offline channels. Some of these
I\'m implementing the first option discussed in \"Marking for deletion in Django\", that is, when an object is no longer active, I set a boolean to mark it as inactive.
How can websites as big as Wikipedia sort duplicated entries out? I need to know the exact procedure from the moment that user creates the duplicate entry and so on. If you don\'t know it but you kno
How are开发者_JAVA技巧 others using relational modeling tools to map a logical model or one in third normal form to a database that uses EAV?EAV is a non-relational design.You can\'t achieve any norma
I have a database with the following table: PATIENT (PATIENT_ID*, MEDICAL_EXAMINATIONS) where the field MEDICAL_EXAMINATIONS contains a free-text description of the exams undertaken by the patient.
I wrote a simple CMS for one of my clients which does specifically what he needs (without the bloat of mainstream content management systems he would never use).
I am working on an application where users \'fight\' to own larger parts of the map. Each map is made of a 1000 reg开发者_开发问答ions. Now my initial plan was to store the areas a user owns as a comm
The database I\'m designing has 3 major tables: BOOKS, ARTICLES, NOTES. Each book or article can have multiple notes, my original design was just like that, which means both notes on books and notes o