Access Database Skills and Word Document Assignment

Access Database Skills and Word Document - Assignment mannequinThe database institution and the respective relationships are 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 one many type.In the second normal form the tables are decomposed to curb redundancy. Like the table cropTypes was extracted out from the table Products to adduce the storage space and avoid redundancy in data.This interrogative sentence uses 4 tables to intend data and to find results. It returns the sale details 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 bulk details with Product Names, respective Price, Sum of quantity of all(prenominal) product sold and Sum of sales amount for each 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 downstairs 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 can 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