What is the difference between public, private, and protected inheritance in C++?
class A { public: int x; protected: int y; private: int z; }; class B : public A { // x is public … Read more
inheritance
How to enforce data consistency across one-to-one relationship in an inheritance hierarchy
Consider this design for a typical school database: Person: —————– FirstName LastName SocialSecurityNumber Phone Email Student: —————– Grade Teacher: —————– Specialty As you … Read more
Polymorphic Association – is it bad? [duplicate]
This question already has answers here: Modeling Upvotes / Likes – one table per type, or one big table? [migrated] (2 answers) Closed … Read more
Abstract classes in SQL Server. Are they even possible?
I have a very specific question that I am surprised no one has yet asked. It involves a concrete class model and SQL … Read more
Transfer row from ‘parent’ to ‘child’ without creating duplicate and without knowing all ‘parent’ columns
I want to set up a database with different schemas that correspond to different data-entry systems. There needs to be a “master” (administration) … Read more
Postgresql inheritance based database design
I’m developing a simple babysitter application that has 2 types of users: a ‘Parent’ and the ‘Babysitter’. I’m using postgresql as my database … Read more
Best practise for polymorphic associations in MySQL
I have a MySQL database with 3 tables holding the main classes of data: companies (company_id) persons (person_id, company_id) loans (loan_id, company_id) Both … Read more
Using table inheritance instead of mapping tables
This seems like a pretty common scenario: several types that all compose the same child type. This could typically look like so: — … Read more
How to drop inheritance?
I am new to PostgreSQL. The situation I have is someone created a child table inherits from the parent table. And dropped the … Read more
Partial unique constraint spanning multiple tables in postgres
To enforce partial uniqueness in postgres, it is a well known workaround to create a partial unique index instead of an explicit constraint, … Read more
