All Questions

Tagged with
Filter by
Sorted by
Tagged with
-1
votes
1answer
33 views

Database design for 'pay at table' product (integrating with restaurant APIs)

I am doing a database project for Uni and am trying to figure out how a 'Pay at Table' app would work for restaurants. I Have found this example company that does this https://readytopay.com/ but i ...
1
vote
1answer
181 views

Hotel Booking Database design problem

I am currently designing (as an assignment for the course at the university) a database for online booking of hotels worldwide and I have stumbled into a problem. Here's is the conceptual design: ...
0
votes
0answers
145 views

Building an Entity-Relationship Diagram for a Language Dictionary

I need advice on how to build entity-relationship diagram (ERD) for Language Dictionary. Since I did not build ERD before, I will try to explain and show the ultimate goal of this project below. ...
-1
votes
1answer
195 views

ER diagram to Relational Schema (Many to Many relationship)

In this ER diagram, can anyone explain how we should convert the many to many relationships ('view', 'update' and 'diagnose') to Relational Schema and then SQL? What I think is that there shouldn't be ...
-1
votes
1answer
804 views

Is there an open source PostgreSQL IDE that allows for model generation? [closed]

I have done quite a lot of SQL Server work where I could use SSMS. Now I'm working with Postgres and I miss the ability to generate models (diagrams) from existing relations (taking into account ...
6
votes
3answers
798 views

How to model Parent -> Child -> Grandchild if the Child can be removed

I'm dealing with a set of relationships where the child can be removed, but I obviously don't want to lose the connection between the grandchild and the parent. I did think about marking the child as "...
6
votes
1answer
1k views

Postgres 9.6 export the database structure as pdf [closed]

Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
3
votes
3answers
1k views

Storing historical records and extracting data from a given period

This a question about database modeling and PostgreSQL. This post partially answers the question but I need advice on more technical stuff: columns and query to extract the data. I need to store ...
2
votes
2answers
526 views

How to review Database schema?

I am green been software engineer, my team lead give me a task in PostgreSQL database, I need to determine the relationship of the all 405 tables, but the problem is the database doesn't have any ...
5
votes
2answers
11k views

Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu) [closed]

Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ?? Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...