SQL Management Error message

hello everyone

I m designing a database before using it with VB.

I m at stage of building relationships

I m trying to build a relationship between table Faculty and table Course.

Following is the error message SQL Management is displaying to me

'faculty' table saved successfully

'Course' table

- Unable to create relationship 'FK_Course_faculty'.

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Course_faculty". The conflict occurred in database "CSE_DEPT", table "dbo.faculty", column 'faculty_id'.

I tried to read it carefully i m unable to understand what is wrong in the faculty table. Please help

my database has 5 tables ( Course,Faculty,Login, Student,StudentCourse)

i have already build the following relationship between tables Login/ Faculty and between Login/Student tables

please help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Guest User12y ago
To help us understand your db tables better and solve it, can you please generate diagram and upload?

Steps to generate diagram:
http://www.mssqltips.com/sqlservertip/1816/getting-started-with-sql-server-database-diagrams/