Assess students' ability to design a normalized relational database schema (up to 3NF) for an online bookstore and to write correct, efficient SQL statements. Tasks include producing a schema/ER diagram with tables, primary/foreign keys, and constraints; showing normalization steps to 3NF for sample attributes; and writing SQL queries (joins, aggregates, subqueries, transactions) to answer business questions such as top-selling books, customer order history, inventory alerts, and inserting an order atomically.