Seminole Sports is a company that sells many different kinds of sporting goods to customers. It is a great store to visit if you are a Seminole fan who needs equipment for any sport, including baseball, basketball, football, golf, gymnastics, lacrosse, swimming/diving, tennis, volleyball, and many others. Of course whatever equipment you purchase will have garnet and gold colors on it somewhere, and will have an insignia of some "famous" Seminole symbol such as the flaming spear, the three torches or a male or female Indian warrior silhouette.
Each type of product sold by Seminole Sports is mass-produced, and therefore each instance of a product type is not specifically identified (e.g. with a unique serial number) but instead is tracked with a product stock number that is the same for all instances of that product type. Sales to some customers (especially current residents of Tallahassee) are often made in person, at the store's location. For those sales, Seminole Sports has a policy of accepting cash only. Its "on-location" customers tend to be fairly homogeneous in their tastes and the marketing department has decided it has no need to track which specific on-location customers are purchasing which types of products. Thus no information is tracked for customers for on-site sales. However, Seminole fans nationwide (especially FSU alumni who have moved to other states) want to buy products from Seminole Sports. To meet this demand, Seminole Sports has established a website and a mail order catalog. Seminole fans may order products from either the mail order catalog or from the website by sending an order form (paper or electronic) or by calling a toll-free number. Customer information for all sale orders and sales to off-site customers must be tracked, especially the customer's shipping address. Seminole Sports accepts approximately 95% of customer orders (the remaining 5% are rejected because customers requested discontinued items). Customers have the option of having Seminole Sports ship the products as they become available or waiting until the order is complete (the former requires them to pay extra shipping costs). Multiple customer orders are never combined into the same shipment. Payment terms offered by Seminole Sports are n/15 and the only form of payment it accepts is cashier's checks (to guarantee no NSF checks). Sometimes customers will pay for multiple sales with a single check, and needs the information system to be able to accept partial payments even though those are rare.
On-site sales and cash receipts are processed by store clerks, who enter product information into an electronic cash register, put the merchandise into bags, and accept the customer's payment (providing change to the customer if necessary). Orders from off-site customers are entered and approved by order entry clerks, who verify that the requested products are (or will soon be) available. They forward the order information to the sales clerks, who fill the orders in-between helping on-location customers, by packing the merchandise into boxes, labeling the boxes with the customer shipping address, mailing the boxes, and entering the shipment into the information system.
When cashiers checks are received from customers, sales clerks process them. They put the cashier's checks into the cash register drawer, which serves as an "on-hand cash account". Seminole also has cash accounts at a local bank, to which it periodically deposits the cash register drawer contents as well as checks received from non-sale sources (such as loans). At the end of each day, Seminole determines which cash account has the lowest balance and make's that day's deposit into that account.
Seminole Sports has a group of purchasing agents who order products from various suppliers. All purchases must be preceded by an order; purchase agents are never allowed to just go out and buy something without going through the formal ordering process. Because the manager approves ALL purchase orders, her participation is not tracked in the database. Only one purchase agent is responsible for any one order. Its suppliers accept nearly all of Seminole Sports' orders. Multiple orders accepted by the same supplier are sometimes combined into a single shipment to Seminole Sports. One of Seminole Sports' inventory clerks receives the products, unpacks and counts them, enters the appropriate information into the information system, and places them on the store display shelves. Seminole Sports pays for all purchases made from a supplier during a given month on the last day of that month with one check, and intends never to make partial payments for purchases of inventory. Each and every check (including checks written for other things such as loan payments, wages, etc.) is written by one of Seminole Sports' accounts payable clerks and is drawn on one of its cash accounts.
Seminole Sports enters information about its employees, cash accounts, products, customers, and suppliers before entering information about any events for which those things need to be tracked. Purchases and purchase orders of different types of things (for example, fixed assets or services) will NOT be included in the same entities with purchases and purchase orders of product inventory; rather they would be considered as separate entities (and you are not modeling those). Seminole Sports does not sell anything other than product inventory.
Below, Seminole Sports has identified attributes that need to be included in its information system (don't add or subtract any attributes). You may create abbreviations for the attributes; be sure that your abbreviations are descriptive enough that someone reading your model will know what you mean.
Required: Create a REA business process level model in either ER diagram or ER grammar format. Be sure to include entities, relationships, cardinalities, and attributes! Write any perceived ambiguities (if any) and assumptions you made to resolve those ambiguities for the Seminole Sports problem.

Question

Seminole Sports is a company that sells many different kinds of sporting goods to customers. It is a great store to visit if you are a Seminole fan who needs equipment for any sport, including baseball, basketball, football, golf, gymnastics, lacrosse, swimming/diving, tennis, volleyball, and many others. Of course whatever equipment you purchase will have garnet and gold colors on it somewhere, and will have an insignia of some "famous" Seminole symbol such as the flaming spear, the three torches or a male or female Indian warrior silhouette. 
Each type of product sold by Seminole Sports is mass-produced, and therefore each instance of a product type is not specifically identified (e.g. with a unique serial number) but instead is tracked with a product stock number that is the same for all instances of that product type. Sales to some customers (especially current residents of Tallahassee) are often made in person, at the store's location. For those sales, Seminole Sports has a policy of accepting cash only. Its "on-location" customers tend to be fairly homogeneous in their tastes and the marketing department has decided it has no need to track which specific on-location customers are purchasing which types of products. Thus no information is tracked for customers for on-site sales. However, Seminole fans nationwide (especially FSU alumni who have moved to other states) want to buy products from Seminole Sports. To meet this demand, Seminole Sports has established a website and a mail order catalog. Seminole fans may order products from either the mail order catalog or from the website by sending an order form (paper or electronic) or by calling a toll-free number. Customer information for all sale orders and sales to off-site customers must be tracked, especially the customer's shipping address. Seminole Sports accepts approximately 95% of customer orders (the remaining 5% are rejected because customers requested discontinued items). Customers have the option of having Seminole Sports ship the products as they become available or waiting until the order is complete (the former requires them to pay extra shipping costs). Multiple customer orders are never combined into the same shipment. Payment terms offered by Seminole Sports are n/15 and the only form of payment it accepts is cashier's checks (to guarantee no NSF checks). Sometimes customers will pay for multiple sales with a single check, and needs the information system to be able to accept partial payments even though those are rare.
On-site sales and cash receipts are processed by store clerks, who enter product information into an electronic cash register, put the merchandise into bags, and accept the customer's payment (providing change to the customer if necessary). Orders from off-site customers are entered and approved by order entry clerks, who verify that the requested products are (or will soon be) available. They forward the order information to the sales clerks, who fill the orders in-between helping on-location customers, by packing the merchandise into boxes, labeling the boxes with the customer shipping address, mailing the boxes, and entering the shipment into the information system.
When cashiers checks are received from customers, sales clerks process them. They put the cashier's checks into the cash register drawer, which serves as an "on-hand cash account". Seminole also has cash accounts at a local bank, to which it periodically deposits the cash register drawer contents as well as checks received from non-sale sources (such as loans). At the end of each day, Seminole determines which cash account has the lowest balance and make's that day's deposit into that account.
Seminole Sports has a group of purchasing agents who order products from various suppliers. All purchases must be preceded by an order; purchase agents are never allowed to just go out and buy something without going through the formal ordering process. Because the manager approves ALL purchase orders, her participation is not tracked in the database. Only one purchase agent is responsible for any one order. Its suppliers accept nearly all of Seminole Sports' orders. Multiple orders accepted by the same supplier are sometimes combined into a single shipment to Seminole Sports. One of Seminole Sports' inventory clerks receives the products, unpacks and counts them, enters the appropriate information into the information system, and places them on the store display shelves. Seminole Sports pays for all purchases made from a supplier during a given month on the last day of that month with one check, and intends never to make partial payments for purchases of inventory. Each and every check (including checks written for other things such as loan payments, wages, etc.) is written by one of Seminole Sports' accounts payable clerks and is drawn on one of its cash accounts.
Seminole Sports enters information about its employees, cash accounts, products, customers, and suppliers before entering information about any events for which those things need to be tracked. Purchases and purchase orders of different types of things (for example, fixed assets or services) will NOT be included in the same entities with purchases and purchase orders of product inventory; rather they would be considered as separate entities (and you are not modeling those). Seminole Sports does not sell anything other than product inventory.
Below, Seminole Sports has identified attributes that need to be included in its information system (don't add or subtract any attributes). You may create abbreviations for the attributes; be sure that your abbreviations are descriptive enough that someone reading your model will know what you mean.
  Required: Create a REA business process level model in either ER diagram or ER grammar format. Be sure to include entities, relationships, cardinalities, and attributes! Write any perceived ambiguities (if any) and assumptions you made to resolve those ambiguities for the Seminole Sports problem.

Quizplus · Accepted Answer

The Answer of Seminole Sports is a company that sells many different kinds of sporting goods to customers. It is a great store to visit if you are a Seminole fan who needs equipment for any sport, including baseball, basketball, football, golf, gymnastics, lacrosse, swimming/diving, tennis, volleyball, and many others. Of course whatever equipment you purchase will have garnet and gold colors on it somewhere, and will have an insignia of some "famous" Seminole symbol such as the flaming spear, the three torches or a male or female Indian warrior silhouette. 
Each type of product sold by Seminole Sports is mass-produced, and therefore each instance of a product type is not specifically identified (e.g. with a unique serial number) but instead is tracked with a product stock number that is the same for all instances of that product type. Sales to some customers (especially current residents of Tallahassee) are often made in person, at the store's location. For those sales, Seminole Sports has a policy of accepting cash only. Its "on-location" customers tend to be fairly homogeneous in their tastes and the marketing department has decided it has no need to track which specific on-location customers are purchasing which types of products. Thus no information is tracked for customers for on-site sales. However, Seminole fans nationwide (especially FSU alumni who have moved to other states) want to buy products from Seminole Sports. To meet this demand, Seminole Sports has established a website and a mail order catalog. Seminole fans may order products from either the mail order catalog or from the website by sending an order form (paper or electronic) or by calling a toll-free number. Customer information for all sale orders and sales to off-site customers must be tracked, especially the customer's shipping address. Seminole Sports accepts approximately 95% of customer orders (the remaining 5% are rejected because customers requested discontinued items). Customers have the option of having Seminole Sports ship the products as they become available or waiting until the order is complete (the former requires them to pay extra shipping costs). Multiple customer orders are never combined into the same shipment. Payment terms offered by Seminole Sports are n/15 and the only form of payment it accepts is cashier's checks (to guarantee no NSF checks). Sometimes customers will pay for multiple sales with a single check, and needs the information system to be able to accept partial payments even though those are rare.
On-site sales and cash receipts are processed by store clerks, who enter product information into an electronic cash register, put the merchandise into bags, and accept the customer's payment (providing change to the customer if necessary). Orders from off-site customers are entered and approved by order entry clerks, who verify that the requested products are (or will soon be) available. They forward the order information to the sales clerks, who fill the orders in-between helping on-location customers, by packing the merchandise into boxes, labeling the boxes with the customer shipping address, mailing the boxes, and entering the shipment into the information system.
When cashiers checks are received from customers, sales clerks process them. They put the cashier's checks into the cash register drawer, which serves as an "on-hand cash account". Seminole also has cash accounts at a local bank, to which it periodically deposits the cash register drawer contents as well as checks received from non-sale sources (such as loans). At the end of each day, Seminole determines which cash account has the lowest balance and make's that day's deposit into that account.
Seminole Sports has a group of purchasing agents who order products from various suppliers. All purchases must be preceded by an order; purchase agents are never allowed to just go out and buy something without going through the formal ordering process. Because the manager approves ALL purchase orders, her participation is not tracked in the database. Only one purchase agent is responsible for any one order. Its suppliers accept nearly all of Seminole Sports' orders. Multiple orders accepted by the same supplier are sometimes combined into a single shipment to Seminole Sports. One of Seminole Sports' inventory clerks receives the products, unpacks and counts them, enters the appropriate information into the information system, and places them on the store display shelves. Seminole Sports pays for all purchases made from a supplier during a given month on the last day of that month with one check, and intends never to make partial payments for purchases of inventory. Each and every check (including checks written for other things such as loan payments, wages, etc.) is written by one of Seminole Sports' accounts payable clerks and is drawn on one of its cash accounts.
Seminole Sports enters information about its employees, cash accounts, products, customers, and suppliers before entering information about any events for which those things need to be tracked. Purchases and purchase orders of different types of things (for example, fixed assets or services) will NOT be included in the same entities with purchases and purchase orders of product inventory; rather they would be considered as separate entities (and you are not modeling those). Seminole Sports does not sell anything other than product inventory.
Below, Seminole Sports has identified attributes that need to be included in its information system (don't add or subtract any attributes). You may create abbreviations for the attributes; be sure that your abbreviations are descriptive enough that someone reading your model will know what you mean.
  Required: Create a REA business process level model in either ER diagram or ER grammar format. Be sure to include entities, relationships, cardinalities, and attributes! Write any perceived ambiguities (if any) and assumptions you made to resolve those ambiguities for the Seminole Sports problem.

Seminole Sports Is a Company That Sells Many Different Kinds