Referential integrity in a database where tuples are not physically deleted
Many modern Relational Database Management Systems automatically support referential integrity, i.e. when you try to delete a tuple which has a reference (in the form of foreign key, for example), the DBMS doesn’t complete the operation and brings an error.
Retrieving hierarchy of tree-nodes stored in relational database
I have a hierarchical ADT that I want to store in a database.
What is the common approach to component template databases?
My Project:
Should lookup tables enumerating strings have an integer primary key?
When I learned relational databases, the prof said that one would “almost always” want an artificial int as the primary key in a table, but did not specify what the exceptions are. At some time I stopped using them for junction tables, and never had a problem.
In plain English, what is a database index most similar to? [duplicate]
This question already has answers here: Indexing a database (6 answers) Closed 9 years ago. Setup: Suppose you are teaching an introduction to Databases class, the students are CS students that have a working knowledge of tree structures, how they can speed up searches, and have probably implemented a few in their lifetime. Question: How […]
Create a database for database tables
I’m working on a project where I have to give users the ability to build their own tables,
each user can create more than one table.
Handling subscriptions, balances and pricing plan changes [closed]
Closed 9 years ago.
Suitable algorithm for joining records from multiple databases
I am in the process of writing a library that is used to be able to access data from a database. The library requires the initial definition of all the tables that the application will be using in the form of classes that extend an abstract class within the library.
External id for every relational table
Should I add an external id for every table?
External id for every relational table
Should I add an external id for every table?