Design an ERD for the following scenario. Oaken s Trading Post provides hiking and mountain climbing supplies to local residents and tourists who wish to explore the mountain terrain near die Rocky Mountains. They provide a variety of supplies such as snow shoes, climbing shoes, helmets, ropes, carabiners, belay equipment, backpacks, and more. Some equipment comes in more than one size or has weigh restrictions. Customers can come in and purchase a single items or can purchase items as a package that includes a variety of useful items. As an IT consultant, you have been asked to suggest 3NF table designs for a database that will store the items available for sale, records customer information so that a satisfaction survey can be sent to them, and captures the details of the customer's purchase. Addresses are only stored for customers who make a purchase. Be sure the purchase can include either option of buying a single item or buying a variety of items in a package. Label all relationships. Use crow's foot notation to indicate the cardinality and optionality of your relationships and list any assumptions you are making about the business rules needed for this ERD. Use a dotted line to represent a weak relationship and a solid line to represent a strong relationship. Create a Context Diagram and Output sketch for the scenario. Only include the input and output specified in the description. Oaken's Trading Post sells hiking and mountain climbing supplies. Customers only shop in the store. Oaken wants a system that keeps track of the number of items in stock, prints a receipt for the customer's purchase, and can print a summary report of monthly sales. The system also needs to record the customer's mailing address so he can print mailing labels to send each customer a satisfaction survey about the service provided. Draw a Context Diagram for Oaken's Sales System. Draw a sketch to show a detailed layout/design for the summary report mentioned in the scenario Design an ERD for the following scenario. Oaken s Trading Post provides hiking and mountain climbing supplies to local residents and tourists who wish to explore the mountain terrain near die Rocky Mountains. They provide a variety of supplies such as snow shoes, climbing shoes, helmets, ropes, carabiners, belay equipment, backpacks, and more. Some equipment comes in more than one size or has weigh restrictions. Customers can come in and purchase a single items or can purchase items as a package that includes a variety of useful items. As an IT consultant, you have been asked to suggest 3NF table designs for a database that will store the items available for sale, records customer information so that a satisfaction survey can be sent to them, and captures the details of the customer's purchase. Addresses are only stored for customers who make a purchase. Be sure the purchase can include either option of buying a single item or buying a variety of items in a package. Label all relationships. Use crow's foot notation to indicate the cardinality and optionality of your relationships and list any assumptions you are making about the business rules needed for this ERD. Use a dotted line to represent a weak relationship and a solid line to represent a strong relationship. Create a Context Diagram and Output sketch for the scenario. Only include the input and output specified in the description. Oaken's Trading Post sells hiking and mountain climbing supplies. Customers only shop in the store. Oaken wants a system that keeps track of the number of items in stock, prints a receipt for the customer's purchase, and can print a summary report of monthly sales. The system also needs to record the customer's mailing address so he can print mailing labels to send each customer a satisfaction survey about the service provided. Draw a Context Diagram for Oaken's Sales System. Draw a sketch to show a detailed layout/design for the summary report mentioned in the scenario
