I am writing to inquire about the format of our upcoming mid-semester exam on 30/08/2024. Will the exam consist of multiple-choice questions, short answer questions, or long answer questions? Will the exam be purely theoretical, or will it include any coding components as well?

Hi, Format: MCQs (I will guide you in the lecture how to fill an MCQs sheet). There will NOT be any short-answer/long answer questions. Content: - Theory: Everything that we will cover till the Lecture in week 6 (26 Aug 2024). Topics include: Introduction to Databases Relational Model Relational Algebra ER Modeling (Wk 4) Enhanced ER Modeling (Wk 5-6) - SQL: Everything that we will cover till week 6, including Labs 1,2 & 3. Topics include: DML: Use compound WHERE conditions. Use aggregate functions. Sort query results using ORDER BY. Group data using GROUP BY and HAVING. Use basic subqueries. DDL: CREATE TABLE UPDATE TABLE INSERT INTO DROP TABLE DELETE FROM Material for both theory and SQL is available on LMS. Cheers Mehwish