Relational Constructs   «Prev  Next»

# Calculations Domain Types Exercise

## Database Table and Domain Types - Exercise

### Identify the correct domain for calculations

Objective: Apply correct domain types to columns that support calculations.

### Exercise scoring

This exercise is worth a total of 20 points. You will receive up to five points for identifying the column in the table illustrated below that calculates a value, up to five points for choosing the correct domain for that column, and up to 10 points for correctly formulating the equation for the calculation the column will perform.

### Background/overview

In this exercise you will identify the column in a virtual table named Line Item that uses a calculation to derive its value and then apply the proper domain to the column.

### Instructions

Examine the columns in virtual table Line Item illustrated below and answer the following questions:
1. Which column in the table calculates a value?
2. What is the appropriate domain for the column?
3. How would you formulate the equation for the calculation the column will perform?

LINE ITEM
OrderNo CDNo Quantity SellingPrice Discount LineCost Shipped