1. Suppose we have the following relational model:

Movie(mov_id(PK), title, yr)

To get a count of the number of movies released each year, you should include the following in your query:

a) SUM(mov_id)

b) GROUP BY yr

c) WHERE yr = yr

d) COUNT(mov_id) BY yr

2. Assume that software for CV's (resume's for job applications) stores the details of the resume, including job experience, like "Python, 2 years". If the software lets you search resumes for applicants satisfying requirements for a minimum number of years of experience in various skills,

a) You should still represent experience as a multivalued attribute of a Resume entity

b) You should still represent experience as a pair of attributes of a separate entity related to the Resume entity

c) You should still represent experience as an attribute of a separate entity related to the Resume entity

d) It is appropriate to treat experience as a single attribute in a Resume entity