IST 302 Database Project
Database Project – Instructions
This semester’s project involves the design of a database system for a Sales Transaction application. In these instructions we refer to the data that would result from execution of a business query (BQ) as a Business View (BV). Note that a BV could be a virtual view or a materialized view.
Each Project Team will be required to do the following:
A sale is an exchange of a product (or service) between two or more parties in exchange of money or some other compensation. It takes place almost every day in human-life. Whenever there is a sale, there are at least two parties involved; a seller who is typically an owner of the product or who has legal possession and a buyer who is seeking the product.
Transaction Detail—this table typically contains one row per item in a transaction basket. The transaction detail table is often very wide, containing dozens of attributes about each item in a transaction. Captured fields typically include the following:
You will need to specify & test integrity constraints of your relational database system
For each table of your relational database system: