Question : I have a table of “interviews” and “interview reviews” for both the interviewer and the interviewee. When the […]
Tag: subtypes
How to model an entity type that can have different sets of attributes?
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?
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
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?
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
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?
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?
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
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
Question : I am looking to implement a generic comment and file attachment facility within a web application which would […]