DescriptionBased on a description, create a schema and write a series of well-performing queries.
TypeHand-in assignment with oral explanation.
DurationAt most 1 working day.
Progress points1.0
Credits5
Test matrix
Learning goal
?
Know Comprehend Apply Analyze Evaluate Create Σ
Use SQL select queries to read, search, write, update and delete records.
5
21 21.1
Write SQL queries involving joins.
5
11 10.5
Describe real-world objects using Entity Relationship Diagrams.
1
21 21.1
Use GROUP BY and aggregate functions to calculate statistics.
5
11 10.5
Use subqueries.
5
11 10.5
Create normalized database tables based on an Entity Relationship Diagram.
5
11 10.5
Use foreign keys to guarantee data consistency.
5
11 10.5
Use views to simplify complicated database queries.
5
5 5.3
Status
  • You'll need to login to view this assignment. Blocking