CustomerRate (customerID, movieID, rate);
The customer (customerID, customerName, date);
Make (movieID, directorID);
Direcotr (directorID directorName);

The known conditions customerName and directorName and rate;
The customer, make director has data
I now want to customerRate insert data


CustomerID will obtain from the customer (via the customerName)
MovieID from you to make the inside access (through directorID)
Then use the directorID to make corresponding movieID access inside see (there are two possible)



how to write?

CodePudding user response:

Should say this:

Know directorName, so from the director was taking out the corresponding directorID inside, and then to make corresponding directorID inside look at what movie, remove movieID, as the second value of customerRate insert
How should achieve?

CodePudding user response:

Have to solve...