Database Systems and Models: Assignment with SQL Queries – Assignment 2

Summary

Database systems and models are explored through SQL queries. Students get practice in designing and validating queries, and in creating object-oriented models of data.

Commission and compensation queries

Students design SQL queries to calculate commissions paid to sales employees. They compare this to queries that calculate total compensation for employees. The queries use data from tables such as Employee, Invoice, and InvoiceLine.

Referential integrity

Referential integrity is explained. Students determine the factors necessary to ensure it. They identify the entities and attributes in the data sets, and the relationships between them.

Big data in organizations

The role of big data in productivity and forecasting is described. Students consider how big data can assist in decision making and improving customer experiences.

Creating tables and triggers

SQL code is provided to create tables and triggers. Students use this code to generate the tables needed for their queries. They learn how to use triggers to automatically generate unique values for primary keys.

Key terms

Referential integrity

Consistency between tables related by foreign keys.

Big data

Large data sets used to drive innovation and competition.

Triggers

SQL code that automatically executes in response to certain events.

Primary key

A unique identifier for a record in a database table.

Foreign key

A field in one table that uniquely identifies a row of another table.

Object-oriented model

A way of representing data and its relationships using objects.

Questions this document helps with

• How do you calculate commissions for sales employees?
• What is referential integrity and why is it important?
• How can big data improve productivity and forecasting?

Summary written with AI from the document's text.