RelationalDBDesign RelationalDBDesign

Relational Constructs   «Prev  Next»

Calculations 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.


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.


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?

OrderNo CDNo Quantity SellingPrice Discount LineCost Shipped

Submitting your exercise

Paste or type your answers to the questions above into the text box below.
Click the Submit to submit the exercise and view a results page.