[Informatics] northern hemisphere Informatics exam

[Laurie McDonald (Mr)]

Hi All

Not sure if it has been mentioned before, but for those interested.
There is a Northern Hemisphere 2018 exam in Informatics (and others)
https://www.vcaa.vic.edu.au/Pages/vce/nht/resources.aspx

Question 3 Part B (4 marks) Asks:

Data about movies and movie stars is to be stored in a database. The data about movies will include the movie’s title, the director’s name and the release date. The data about movie stars will include the actor’s name and the titles of the movies in which they have starred. Describe how the tables in a relational database management system would be structured to store all the data.

The answer states:
Students were asked to describe how the table in a relational database management system would be structured to store all the data. The data could be stored in two tables, one for movies and one for the stars. The movies table would have columns/fields for Movie ID, title, director, and date. The stars table would have columns/fields for actor and title. The Movie ID would provide the link/relationship between the two tables.

Do you think the Stars table (actor and title) and the link described is enough info?

cheers

Kind Regards,
Mr Laurie McDonald



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/informatics/attachments/20181111/efd14456/attachment.html>