MIS 560 Database Management System- DQ

3.1. What is time-variant data, and how would you deal with such data from a database design point of view?

3.2. Explain why it would be preferable to use a DATE data type to store date data instead of a character data type. Explain the difference between an ORDER BY clause and a GROUP BY clause.

4.1. What is the difference between a column constraint and a table constraint? What is the purpose of a CHECK constraint?

4.2. What is a trigger, and what is its purpose? Give an example. What is a stored procedure, and why is it particularly useful? Give an example.