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
19 19.0
Write SQL queries involving joins.
5
10 9.5
Describe real-world objects using Entity Relationship Diagrams.
1
19 19.0
Use GROUP BY and aggregate functions to calculate statistics.
5
10 9.5
Use subqueries.
5
10 9.5
Create normalized database tables based on an Entity Relationship Diagram.
5
10 9.5
Use indexes to enhance query performance.
5
10 9.5
Use foreign keys to guarantee data consistency.
5
10 9.5
Use views to simplify complicated database queries.
5
5 4.8
Status
  • You'll need to login to view this assignment. Blocking