TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
balla etoyo ignace yves
NA
26
0
SQL Management Error message
Jul 12 2014 7:04 PM
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
Reply
Answers (
1
)
Excel or DOC file into SQl database
Data matching