Create a data model based on the scenario and data provided. You can also use the examples
Question:
Create a data model based on the scenario and data provided. You can also use the examples from the textbook and the My Songs Now Tegrity videos in Blackboard to help you build this data model.
River Valley Tech Toys (RVTT) is an independent retailer of mobile entertainment devices that has built its business on offering the widest selection, expert advice, and outstanding customer service. RVTT has a storefront in downtown Russellville with a warehouse nearby. The company sells products at the storefront, by mail, email and telephone, or through its website. They sell products in a variety of categories, such as cell phones, tablets, gaming platforms, game interface devices, radio-guided toys (cars, boats, aircraft, drones, etc.), and so forth.
Lately, George Rogers, the owner and manager, has become concerned with the company’s inventory management methods. RVTT does not use a formal inventory tracking system. Periodically, an employee visually checks to see what items are in stock and creates a list of items to re-order. George or his employees can all make suggestions about what new items to order. Once a week, either George or his assistant Mary will compile those lists, take a look at the company’s bank balance, and order items to replenish inventory.
Although RVTT does try to keep a certain level of each "top seller" in stock, the lack of a formal inventory tracking system has led to the overstocking of some items and under-stocking of others. Overstocked items must usually be discounted to reduce inventory. On occasion, a customer will request a hot item, and only then does RVTT realizes that the item is out of stock. At that point, RVTT will offer to order the item delivered to the store at no shipping cost or delivered to the customer’s home at a modest shipping cost. However, RVTT risks losing that customer to a competitor and spends unnecessary time handling the order.
George has decided to implement a better inventory management system. He just hired you for a semester internship. He is aware that as a business student, your knowledge about Information Systems and technology is very up-to-date. He has decided to assign you the task of creating a data model for an inventory management system. Your model will include purchase transactions, vendors, and items in the inventory. His Point-of-Sales (POS) system handles data about customers and sales transactions, so you do not need to include those aspects of the business in your data model.
You interview George and his employees about how they currently handle inventory replenishment and purchasing processes. They provide you with their current records, stored in an Excel file. You can expect to find errors and incomplete data there. You discover some business rules you need to incorporate into your model.
A purchase order must have at least one product, but can contain more than one product.
Every product needs to have been acquired by means of a purchase order.
A product must belong to one and only one category, but a category may contain many different products.
A product can only be stocked by one vendor, but a vendor can provide more than one product.
A purchase order fulfillment may be shipped either to the store or to a customer’s home or office.
If George likes your work and gains confidence in your abilities, he promises to give you a significant pay raise to turn your data model into a working database.
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke