RelationalDBDesign
RelationalDBDesign
SiteMap
Database Analysis
Database Design
Relational Constructs
«Prev
Next»
Data Analysis
Relational Constraints
DB Life Cycle
Table Characteristics
Database Null Values
Primary Key
Concatenated Keys
Defining Foreign Keys
Referential Integrity
Normal Forms
1st NF Limitations
Reduce Data Redundancy
Normalization - Quiz
Third Normal Form
1st, 2nd, 3rd NF
Joins, User Views
Permissions Design Role
SQL Joining Tables
Permissions Requirements Analysis
SQL Inner Join
Physical Design
Disadvantages Horizontal Partitioning
Disadvantages Vertical Partitioning
Horizontal Partition
Database Vertical Partitioning
DB Design Mistakes
Business Objects Rules
Common Mistakes
Primary Foreign Key Mistakes
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.
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:
Which column in the table calculates a value?
What is the appropriate domain for the column?
How would you formulate the equation for the calculation the column will perform?
LINE ITEM
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.
Submit