Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
.NET
.NET Assemblies
.NET Core
.NET Standard
Active Directory
ADO.NET
Agile Development
AJAX
Alexa Skills
Algorithms in C#
Android
Angular
Architecture
ArcObject
Artificial Intelligence
ASP.NET
ASP.NET Core
Augmented Reality
Aurelia
AWS
Azure
Backbonejs
Big Data
BizTalk Server
Blockchain
Bootstrap
Bot Framework
Business
C#
C# Corner
C, C++, MFC
Career Advice
Chapters
CIO
Cloud
COBOL.NET
Coding Best Practices
Cognitive Services
COM Interop
Compact Framework
Cortana Development
Cryptocurrency
Cryptography
Crystal Reports
Current Affairs
Custom Controls
Cyber Security
Data Mining
Databases & DBA
Design Patterns & Practices
DevOps
DirectX
Dynamics CRM
Enterprise Development
Entity Framework
Error Zone
Exception Handling
Expression Studio
F#
Files, Directory, IO
Games Programming
GDI+
Google Cloud
Google Development
Graphics Design
Hardware
Hiring and Recruitment
HoloLens
How do I
HTML 5
Internet & Web
Internet of Things
Ionic
iOS
Java
Java and .NET
JavaScript
JQuery
JSON
JSP
Knockout
kotlin
Leadership
Learn .NET
LightSwitch
LINQ
Machine Learning
Microsoft 365
Microsoft Office
Microsoft Phone
Mobile Development
Multithreading
NetBeans
Networking
Node.js
Office Development
OOP/OOD
Open Source
Operating Systems
Oracle
Others
Outsourcing
Philosophy
PHP
Power BI
Printing in C#
Products
Progressive Web Apps
Project Management
Python
Q#
QlikView
R
React
Reports using C#
Robotics & Hardware
Ruby on Rails
Salesforce
Security
Servers
SharePoint
SignalR
Silverlight
Smart Devices
Software Testing
SQL Language
SQL Server
Startups
String in C#
Swift
TypeScript
Unity
UWP
Visual Basic .NET
Visual Studio
WCF
Wearables
Web Development
Web Services
Windows 10
Windows Controls
Windows Forms
Windows PowerShell
Windows Services
Workflow Foundation
WPF
Xamarin
XAML Standard
XML
XNA
XSharp
Register
Login
1
Answer
SQL Management Error message
balla etoyo ignace yves
10y
722
1
Reply
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
Rich Text Editor, TextBoxComment
Editor toolbars
Clipboard/Undo
Cut
Keyboard shortcut Ctrl+X
Copy
Keyboard shortcut Ctrl+C
Undo
Keyboard shortcut Ctrl+Z
Redo
Keyboard shortcut Ctrl+Y
Links
Link
Keyboard shortcut Ctrl+K
Unlink
Insert
Image
Insert Code Snippet
Table
Tools
Maximize
Document
Source
Basic Styles
Bold
Keyboard shortcut Ctrl+B
Italic
Keyboard shortcut Ctrl+I
Remove Format
Paragraph
Insert/Remove Numbered List
Insert/Remove Bulleted List
Decrease Indent
Increase Indent
Styles
Format
Format
Font
Font
Size
Size
Press ALT 0 for help
◢
Elements path
Post
Reset
Cancel
Answers (
1
)
0
Sumit Jolly
NA
19k
557.2k
10y
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/
Next Recommended Forum
Excel or DOC file into SQl database
Data matching