(Solved) : Given Er Diagram Relation Model Create Four Rows Sample Data Relations Identified Relatio Q27985707 . . . .

Given the ER diagram and Relation Model below. Createfour rows of sample data for each of the relationsidentified in the Relational Model. Based on oneof the relations of your relational model and its sample data,specify an example of each of the following, andexplain why you selected it:

? A delete operation that would run successfully

? An update operation that would run successfully

? An update operation that would not run successfully

? An insert operation that would not run successfully

Deriving Entitytypes

Attribute: Primary Key

(fk) : Foreign Key

STUDENT (studentID, firstName, lastName, PhoneNumber, streetNo,streetName, suburb, city, postcode)

STAFF (staffID, firstName, lastName, emailaddress, unitID(fk))

UNIT (staffID,