The database does not contain redundant data. Entity integrity of the data is maintained. Referential integrity of the data is maintained. The database complies with the first three normal forms. The response time is minimized.
Users are able to produce a report on monthly invoiced sales by product.
You are responsible for planning the physical implementation of a database for your company. The database will be used for continuous online transaction processing in a fast-paced environment. Both the database and the transaction log should be allowed to grow automatically, if required, however. Because of tape backup limitations, each data file should never be allowed to exceed a 3-GB size limit. The transaction log should never be allowed to exceed a 1-GB size limit.