Clarifications 2024/25 ---------------------- ================================================== Q. To select people born in the first half of the 1970s surely I would need a column that contains the month/full date of birth of the person in question, but the movies.sqlite table for people only gives the year in which they were born. A. The 1970's refers to the decade 1970 to 1979. The predicate required does not need to involve the month. ================================================== Q. My question is "Write a query that returns a sorted list, without repetitions, of films that featured three different actors who also appeared in "Harry Potter and the Sorcerer's Stone". But, there are four actors who appeared in the Harry Potter movie. How should I identify which three of the four actors I should answer with? A. It should be any combination of those four (4 choose 3) of which there are four combinations. ================================================== Q. It was mentioned that there is a human element to marking of the Assessed Exercises, so if our answers were almost completely correct, say 80%, would there be an opportunity to still obtain full credit or is it something like a mark out of 3? A. All Assessed Exercises (ticks) in Parts Ia and Ib are marked on a 'tick' basis. The tick is either awarded or not. [Your DoS should have explained that to you.] Fractional scores, like 80% are not possible. There are two Database ticks. The Moodle submission system for the Database Assessed Exercises records a score of 0.5 for an uploaded answer that has the correct contents. A human ticker (often me) then awards the tick in the next few days. Moodle may finally be updated to show 1.0 but the main marking feedback is through automatic edits to the starter pack worksheet. Your DoS can also see the master table of ticks. The advertised deadline for the Exercise is a submission deadline. The marking may take place after the deadline. Provided a substantially correct/complete submission was made before the deadline, final resubmissions can be made after the deadline. ================================================== Q. A question wants me to get the person_ids of all the actors who've played roles with the names of "Alice" or "Andrew". Does it want me to just get the characters with one of those names exactly or the character with those as their first or only names? A. I can see the expected answer checks for precisely those strings but the tick would likely be awarded for your alternative interpretation since the question is somewhat vague. ================================================== Q. Hello, I hope this email finds you well. I am able to access the databases tick 1 worksheet without issue but am having trouble accessing the declaration.txt that is meant to be included in the zip file. Has the permission been given out for this file yet, or is there another way we should access this file? Thank you. A. I am very sorry about that. A blank declaration is on URL below. Many thanks, DJG. https://www.cl.cam.ac.uk/teaching/2425/Databases/djg-materials/DBW.txt ================================================== Q. I am attempting to submit the required zip file for tick 1 to the moodle page, however, my submission is failing the file validation and the Moodle page is giving be a blank error so I am unsure of what I need to do to correct my submission. A. Hello. Sorry. Yes, I noticed that. You are not alone. The blank error report is my fault and the underlying error arises from an umlaut encoding. I've changed the checker to be less pedantic now. e.g. Atli Örvarsson has an umlaut. =>>Error with file "DBQ1.txt" --- the error is: Possibly a binary file has been submitted when UTF-8/ASCII was requested. =>>Submitted file validated successfully: DBQ1.sql. ================================================== END