Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: subtypes

How to handle a table schema with a new relationship subtype in an interviews scenario?

By adminPosted on February 3, 2023

Question : I have a table of “interviews” and “interview reviews” for both the interviewer and the interviewee. When the […]

How to model an entity type that can have different sets of attributes?

By adminPosted on January 23, 2023June 28, 2022

Question : I’m having some trouble in recreating a database with a one-to-many (1:M) relationship between Users and Items. This […]

Database schema for entities with two possible owner/parent types?

By adminPosted on December 3, 2022

Question : I’m using PostgreSQL with Sequelize as my ORM. I have one type, User. The second type is Group, […]

Developing a database for a funds transfers business where (a) people and organizations can (b) send and receive money

By adminPosted on December 2, 2022

Question : In the business context of relevance, both members and organizations need to have an account for funds. Funds […]

How to represent the optionality of a many-to-one mandatory relationship from the Parent to its two Child entity types in an ERD?

By adminPosted on November 3, 2022

Question : I have a Parent entity type with two Child entities, with a relationship cardinality of many-to-one (or M:1) […]

Supertype/Subtype deciding between category: complete disjoint or incomplete overlapping

By adminPosted on November 2, 2022June 29, 2022

Question : I’m building an inventory database that stores IT hardware, such as desktop computers, laptops, switches, routers, mobile phones, […]

Database design: 4 types of users but have different functionality , separate or one table?

By adminPosted on October 9, 2022

Question : I have 4 types of users: Admins , normal user , company , service provider Admins and normal […]

Database schema for entities with two possible owner/parent types?

By adminPosted on October 6, 2022

Question : I’m using PostgreSQL with Sequelize as my ORM. I have one type, User. The second type is Group, […]

Implementing subtype of a subtype in type/subtype design pattern with mutually exclusive subclasses

By adminPosted on August 21, 2022

Question : Introduction In order for this question to be useful for future readers I will use the generic data […]

Category entity relationship / subtype relationships design

By adminPosted on August 21, 2022

Question : I am looking to implement a generic comment and file attachment facility within a web application which would […]

  • 1
  • 2
  • 3
  • …
  • 7

Recent Posts

  • Bidirectional data transfer
  • Update statement errors, parenthesis, failed validation ORACLE
  • postgresql grant user privilages to dynamically created tables
  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding