I have 5 tables that have ended up with a cyclical relationship and I don't think that is ok.

I School is in one County. A Distict has many Counties. A Teacher can teach in many Districts.

> 
> STUDENTRECORD - RecordId, TeacherId, CountyCode
> 
> 
> COUNTY - CountyCode, CountyName, DistrictId
> 
> 
> DISTRICT - DistrictId, DistrictName
> 
> 
> TEACHER - TeacherId
> 
> 
> TEACHERDISTRICT - DistrictId, TeacherId
> 
> 
> 

So the relationship goes from the StudentRecord, teacherid, to the district, to the county and back to the studentrecord.

I have built the database, populated the teacher, district and county tables, but I have not tried to insert a StudentRecord yet. I just know I have not seen a db design with a circle relationship before and I think there is a reason for that. I assume I have created a bad design.

Is a cyclical relationship a bad thing in database design? If so, why?Thoughts on fixing?

EDIT: I forgot the DistrictId in the COUNTY table, which completes the circle. Sorry for the incomplete question. Here is a picture:

[![enter image description here](https://i.stack.imgur.com/UMARj.png)](https://i.stack.imgur.com/UMARj.png)