Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [relational-modelling]

The tag has no usage guidance.

0
votes
0answers
109 views

Ontology optimization

I have a pretty complex ontology of an application which is used for decision making. By ontology here, I mean basically how entities are related and how they are composed and structured (the context ...
1
vote
1answer
74 views

What are good ways to encode order between records of a relational table

For example, when an issue tracker offers the functionality to users to keep a prioritized backlog of tasks and used a relational database for persisting this information, what are effective ways to ...
0
votes
4answers
258 views

The Open/Closed Principle, how does it work for adding entities?

I'm not even sure how to ask this, but here goes: Let's say I have a Web application that incorporates Teachers, Courses and Students in such a way that I can do things like this (pseudocode): ...
0
votes
0answers
225 views

Is implementing anytime it makes sense aggregation and composition necessary good?

As I'm drawing my project's classes diagram, I'm wondering... Let's take Customer's relationship with Order for example. It seems pretty natural and logic to aggregate Orders to the User... So ...
3
votes
1answer
145 views

What is the canonical pattern for database design with MongoDB?

When it comes to laying out tables in transact SQL databases, like SQL-Server and Sybase, the classic approach to relational modelling is well established. (The authority being Halpin's book) ...