Relationships between Master and Transaction tables?

In my database design, I've defined Master tables (data definition tables, static in nature) which will be used to g...

Abstract Class from UML to ER diagram. Possible ? How??

I have the below UML class diagram with Abstract Class, and sub-Classes that extends from it. and i want to make an ...

Onetomany with parent database design?

Below is a database design which represents my problem(it is not my actual database design). For each city I need to...

How are these tables related??

Say I run an online business where you can order products from my website, and I have a database with two tables: T...

Convert from ER to Relational Database - Mapping Weak entity types?

I am trying to map the weak entity CatalogueEntry into a relational schema, and I am unsure which of the entities ar...

ER-Diagram: Ternary Relationship - How to read properly??

Im not quite sure how to read ternary relationships within a ER-Diagram. Lets say this is the ternary relationship t...

relationships between 3 entities in ER diagram--is a ternary enough or are 2 binaries also needed??

I'm trying to draw an ER diagram for my project management software describing the following. It contains these enti...

Convert ternary relationship to binary in E/R model?

When I am studying the database lecture on E/R model, it illustrates how to convert ternary relationship to binary. ...

Is a unary/recursive relationship strong/identifying or weak/non-identifying??

First, some definitions to make sure that the terminology I'm using is clear: Strong and weak entities and strong/i...

Entity Relationship Diagram for Hotel?

I need to create an ERD for a hotel, the question reads as follows: "The owner of a set of hotels would like to hav...

How to generate an entity-relationship (ER) diagram using Oracle SQL Developer?

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. ...

Difference between associative entity and associative relationship attribute??

What is the difference between an associative entity and an associative relationship attribute? In my book titled, M...