end of semester test: business information management b\nidentify the parts of the database table.\nprimary…

end of semester test: business information management b\nidentify the parts of the database table.\nprimary key field record table\nmovie_id movie_name director year budget (in million usd)\nm101 the incredibles brad bird 2004 92\nm102 peter pan p.j. hogan 2003 100\nm103 james and the giant peach henry selick 1996 38\nm104 the addams family barry sonnenfeld 1991 30

end of semester test: business information management b\nidentify the parts of the database table.\nprimary key field record table\nmovie_id movie_name director year budget (in million usd)\nm101 the incredibles brad bird 2004 92\nm102 peter pan p.j. hogan 2003 100\nm103 james and the giant peach henry selick 1996 38\nm104 the addams family barry sonnenfeld 1991 30

Answer

Brief Explanations:

A primary - key uniquely identifies each record in a table. Here, 'Movie_ID' is the primary key as it is unique for each movie. A field is a column in a table, such as 'Movie_Name', 'Director', etc. A record is a row in the table, for example, the row with 'M101', 'The Incredibles', etc. The entire collection of data is the table.

Answer:

Top box: table Left - bottom box: primary key (Movie_ID) Right - bottom box: record (e.g., row with M101) Side box: field (e.g., Budget (in million USD))