|
|
| Line 1: |
Line 1: |
| ==CMM222 Database Organisations & Design (Minor)==
| |
| ==Database Terminologies==
| |
|
| |
|
| ==Database==
| |
| A collection of data stored in a standardized format, designed to be shared by multiple users. A collection of tables for a particular business situation.
| |
| ==Constraint==
| |
| In SQL, a constraint is a rule that is enforced on the data. For example, there can be primary-key and foreign-key constraints that limit the data that can be entered into the declared columns. Other business rules can form constraints , such as Price > 0.
| |
| ==Data warehouse==
| |
| A specialized database that is optimized for management queries. Data is extracted from online transaction processing systems, The data is cleaned and optimized for searching and analysis. Generally supported by parallel processing and RAID storage.
| |
| ==Durability==
| |
| The transaction element that specifies that when a transaction is committed, all changes are permanently saved even if there is a hardware or system failure.
| |
| ==Edit==
| |
| The Microsoft DAO command to alter data on the current row.
| |
Latest revision as of 18:52, 18 December 2007
File history
Click on a date/time to view the file as it appeared at that time.
| Date/Time | Thumbnail | Dimensions | User | Comment |
|---|
| current | 18:24, 13 August 2005 |  | 218 × 423 (27 KB) | Darren Smith (talk | contribs) | |
You cannot overwrite this file.
File usage
There are no pages that use this file.
This file contains additional information, probably added from the digital camera or scanner used to create or digitize it.
If the file has been modified from its original state, some details may not fully reflect the modified file.
