Question: Write a single SQL statement to insert a new row of data to the Director table for a female director named Amanda McBlyth. The director

Write a single SQL statement to insert a new row of data to the Director table for a female director named Amanda McBlyth. The director ID to be entered in the table for Amanda McBlyth is 14000. Assume that the gender column stores the gender as a single character: 'M' for Male or 'F' for female

Write a single SQL statement to insert a new row

Actor Cast PK,FK1 actorld: int PK actorld: int Movie PK movielD : int title : nvarchar(30) year: datetime *PK,FK2 movieID : int firstName: nvarchar(50) lastName: nvarchar(50) gender:nchar (1) role:: nvarchar(20) rank: int Director Movie Director PK,FK1 directorld: int PK directorID: int firstName: nvarchar(50) lastName: nvarchar(50) gender:nchar (1) 11 PK,FK2 movieID: int specialistRole: nvarchar(50)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!