-3

I created a ERD (dont know if correct) but the real problem is all about CSV file as you can see guys I have three tables, Student(top left corner), teacher(3rd from top left) and course table(2nd from top) now our system can upload a CSV file for proff and student the problem is I dont know how to upload a file for course that has a relation for tables(proff and stud).

unreadable hand-drawn ERD :(

Matt Ball
  • 354,903
  • 100
  • 647
  • 710
superdb
  • 55
  • 1
  • 1
  • 14

1 Answers1

0

If i understand correctly you want to Bulk-Load CSV files to tables with foreign key constraints.

See this question and accepted Answer

How to use BULK INSERT when rows depend on foreign keys values?

Community
  • 1
  • 1
ClearLogic
  • 3,616
  • 1
  • 23
  • 31
  • I just cant imagine how I will store data for course table without using csv?, I will only rely data on two tables(stud,prof) do you recommend to recreate the erd. all I wanted is to have a simple student - teacher with course table relationship. Please I do really need an answer :/ – superdb Aug 22 '12 at 17:12