Access Database Skills and Word Document Assignment

Access Database Skills and Word Document - Assignment ExampleThe infobase design and the respective relationships atomic number 18 depicted through Figure 1.1. This image shows the implemented entity relationship diagram. The referential integrity is enforced with cascade update and cascade delete. All the relationships are of matchless many type.In the second normal form the tables are decomposed to curb redundancy. Like the table ProductTypes was extracted out from the table Products to maintain the storage space and avoid redundancy in data.This wonder uses 4 tables to retrieve data and to produce results. It returns the sale dilate with Customer names, Product Names, Product Type and Date of Sale. Figure 1.2 highlights the design of this query.This query works similar to the earlier one with the exception that it particularly focuses individual customer. Figure 1.3 highlights the design of this query. At execution the query would require the customer ID as input (example C- 101) and would display its respective details as a result.This query uses 3 tables to retrieve data and produce results. It returns the sales volume details with Product Names, respective Price, Sum of quantity of apiece product sold and Sum of sales amount for for each one product (calculated by retrieving values from two different tables). Figure 1.4 highlights the design of this query.This query uses 2 tables to retrieve data and produce results. It is designed to produce product records for which the stock quantity values are below certain threshold. Like in this query the threshold value is taken as 15. Figure 1.5 highlights the design of this query.The queries are really helpful in assessing the sale volume and the records of purchases done by the customers. This database shag be useful for futuristic evaluation of business and for launching promotions by figuring out the sales volume and regular customers.The respective forms are created for each table to facilitate the da ta entry. Rest of the forms highlights the results of 4