Postgres Pro
Downloads
Home   >   mailing lists

Re: Relational loops in a DB - Mailing list pgsql-novice

From Gavin Flower
Subject Re: Relational loops in a DB
Date
Msg-id 5322505D.4050004@archidevsys.co.nz
Whole thread Raw
In response to Relational loops in a DB  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view
On 14/03/14 13:18, JORGE MALDONADO wrote:
I am designing a DB and some of the tables have a loop in their relationships. I am attaching an image of such tables.

One "course" can be offered at several dates (course offerings) and also one "course" can be thought by several "qualified trainers". A "course offering" is taught by one "qualified trainer".

I will very much appreciate your feedback. I hope my explanation is clear enough.

Respectfully,
Jorge Maldonado





 I've attached my suggestion, change details to suite - if you find it useful.

 Cheers,
 Gavin

		
	


	
	
Attachment

	
	

					

					





	

	pgsql-novice by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	David Johnston

	Date:
	



	Subject:
	Re: Relational loops in a DB
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Adam Mackler

	Date:
	



	Subject:
	Re: Relational loops in a DB