DescriptionBased on a description, create a schema and write a series of queries.
TypeHand-in assignment with oral explanation.
DurationAbout 1 working day.
Progress points1.5
Learning goals
  • Use SQL select queries to read, search, write, update and delete records. 21%
  • Write SQL queries involving joins. 11%
  • Describe real-world objects using Entity Relationship Diagrams. 21%
  • Use GROUP BY and aggregate functions to calculate statistics. 11%
  • Use subqueries. 11%
  • Create normalized database tables based on an Entity Relationship Diagram. 11%
  • Use foreign keys to guarantee data consistency. 11%
  • Use views to simplify complicated database queries. 5%
Status
  • You'll need to login to view this assignment. Blocking