Linked Questions

1
vote
0answers
82 views

Best Practice - Database design for 'conditional join' [duplicate]

I need to create a database to store Jobs. Each Job can have 1-* Step Each step is classified as one of either Type A, B or C. Each Type has specific details and other tables that join on them so ...
-2
votes
0answers
33 views

Stuck on task with relational database schema about boats of two different types [duplicate]

I just started taking some online courses in both programming and database management, so I'm really a beginner to these subjects. In my study book there's an exercise that I'm stuck on that I'd ...
1
vote
0answers
28 views

How to model entity types that can contain each other? [duplicate]

I'm having a hard time figuring out how to model a database with a Many-to-Many relationship between a concept of Markets & regions of the world. The issue I'm running into is that a Market is ...
0
votes
0answers
16 views

How would I model a database that selects from a group of tables? [duplicate]

this is the first time I have ever tried to design my own database, so I'm sorry if this is a bit of a stupid question. I have been trying to figure out how to create a database to sort an inventory ...
12
votes
3answers
5k views

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

I have to design an entity-relationship diagram (ERD) for a business context that involves the delineation of music artists, as I will detail below. Scenario description An Artist has a Name, and ...
16
votes
1answer
4k views

Designing a database for a video game business domain with multiple many-to-many relationships

I am relatively new to database design, and I decided to make my own hypothetical database for practice. However, I am having trouble modeling and normalizing it, as I esteem that there are numerous ...
8
votes
2answers
4k views

Modelling a database structure for multiple user types and their contact information

I'm designing a database that will store users of varying types. Predominantly (but not exclusively) they will be Actors, Directors and Writers. Currently there are just four user types that are of ...
7
votes
2answers
1k views

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

In the business context of relevance, both members and organizations need to have an account for funds. Funds can be transferred from member to member, from member to organization, from organization ...
8
votes
1answer
1k views

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

I'm using PostgreSQL with Sequelize as my ORM. I have one type, User. The second type is Group, which can have any number of users associated with it through a GroupMemberships table. Users can also ...
7
votes
1answer
969 views

How to model a Letter Transportation business context in a database diagram?

I am trying to crate entity-relationship diagram for a transport company database. This database should store information about letters, deliveries, moving letters from one warehouse to another, and ...
5
votes
3answers
2k views

One-to-“Zero or One” Relation

I have the following requirements: Every transaction has one of the following types; debit, credit, deposit, or withdraw. Debit or credit transactions must have a linked invoice record and no bank ...
6
votes
3answers
714 views

Database Design challenge: One (Table)-to-Many (Tables) Relationship?

I am rather new to DBs, and after days of being stuck, researching and trying different solutions, I turn to this community's expertise for help. I am trying to have one Person table in my MSSQL DB, ...
1
vote
2answers
170 views

“Flexible” foreign key constraint

We have a Postgres setup with multiple tables representing different parts and stages of a project, 4 of them at the moment but potentially more in the future. We want to make a Task table with a ...
2
votes
2answers
173 views

Internationalization of a Supertype-subtype

First of all, my apologies for tieing this question with another one, but that was the best way I could think to keep it simple and focused Months ago I was introduced to the supertype-subtype as ...
1
vote
4answers
223 views

SQL Join to a Same Combination of Tables

I want to join a first table to same combination of joins: X,Y,Z. The first table can be different table types, but they all join to same set of tables. Table A may have 8 columns of different data ...

15 30 50 per page