Relational Database Case Study
a) Describe the user needs of the database and identify the functionality that they are expecting from a Relational Database Management System (RDMS).
Due to Katrina and her two staff members now using databases to support their company which is the Mail Order Company, the database must be able to add new orders to the system with the correct information about the customer, the product and calculation of total order. The database will also need to be able to automatically calculate the total order for each customer which the correct information is been put in by Katrina and her two staff members. This will ensure that the amount of paperwork and administrative tasks for both Katrina and her two staff members are greatly reduced due to the …show more content…
The data will be consistent when they have been ordered because they will know how many products they have. This would consist of the data which would then be placed and know exactly when and how much of the product you have in store. This would help number of products that are available, then keep a track of costs for the product and also the time/date when they bought the item, by this it would keep an accurate record until they need to buy more of the products they supply. Once they have then they will need to update it again so that they are on track.
Allow order to be placed – When you have ordered an item this would initially allow the order to be save as record for the company to then be able to distribute the product. They would know if the order has been placed due to a conformation email being the customer saying thanks for making the purchase.
Order restricted to no more than 5 per item – For this bit this would usually mean the complete order of products that consumer can buy. This lets them purchase atleast five items before it is capped off the complete
Due to Katrina and her two staff members now using databases to support their company which is the Mail Order Company, the database must be able to add new orders to the system with the correct information about the customer, the product and calculation of total order. The database will also need to be able to automatically calculate the total order for each customer which the correct information is been put in by Katrina and her two staff members. This will ensure that the amount of paperwork and administrative tasks for both Katrina and her two staff members are greatly reduced due to the …show more content…
The data will be consistent when they have been ordered because they will know how many products they have. This would consist of the data which would then be placed and know exactly when and how much of the product you have in store. This would help number of products that are available, then keep a track of costs for the product and also the time/date when they bought the item, by this it would keep an accurate record until they need to buy more of the products they supply. Once they have then they will need to update it again so that they are on track.
Allow order to be placed – When you have ordered an item this would initially allow the order to be save as record for the company to then be able to distribute the product. They would know if the order has been placed due to a conformation email being the customer saying thanks for making the purchase.
Order restricted to no more than 5 per item – For this bit this would usually mean the complete order of products that consumer can buy. This lets them purchase atleast five items before it is capped off the complete