J&B Enterprises Create the conceptual business process model for J&B Enterprises J&B Enterprises offers each of its clients a full range of outsourcing service options which allow those companies to concentrate almost exclusively on their main value- added activities. J&B will do your bookkeeping, computer services, taxes, cleaning, advertising, legal work, etc. for you by dispatching its own well-trained employees to your place of business. Each service engagement involves exactly one type of service, and it must include at least one engagement employee. Each type of service has a standard hourly billing rate. Employees can engage in multiple service engagements, but they have just one hourly wage rate. When a service engagement is completed during a particular month, that client is required to pay in full for it by the 20th of the next month (if a client has had more than one service engagement, one payment can be submitted for all of the engagements). Clients NEVER make partial payments. Although the vast majority of cash receipts come from clients for service engagements, some cash receipts come from other sources (e.g. bank loans). Every cash receiptis processed by exactly one of J&B's several cashiers and is deposited into one of J&B's bank accounts. Information about service types, cashiers, engagement employees, and clients will often need to be entered into the database before any transactions involving them have occurred. Information about cash accounts may not be entered into J&B's system without assigning at least one cash receipt to that account. The following attributes are of interest to potential users of this data model. -name-of-service -invoice#-for-service-rendered -remittance-advice# -cash-account -client# -cashier-SSN -engagement-employee-highest-degree -total-charge-for-service-engagement -bank-account balance -client-name -cash-receipt-amount -bank-account-location -individual-accounts receivable -cashier-phone# -employee-SSN -service-billing-rate -employee-wage-rate (engagement & cashier) (SSN = social security number) PhoneSource Prepare a conceptual model (with entities, relationships, attributes, and multiplicities) for the following business process: PhoneSource is a company that sells several kinds of telephones to customers. Product offerings include traditional corded phones, cordless phones, cellular phones, etc. Each type of phone comes in various models; each model has a different stock number. Although cellular phones must be programmed with unique information for each customer, Phone Source does not offer cellular service or the corresponding programming. Therefore Phone Source does not need to keep track of each individual phone; it is sufficient to track them by model number. PhoneSource has several salespeople who are paid on commission. Although each customer is assigned to one particular salesperson, if a customer's assigned salesperson is not available when the customer comes in, another salesperson may assist that customer. The resulting commission is split between the two salespeople. A customer's assigned salesperson may be unavailable because of a sick day or vacation day or because he or she is helping another customer to whom the same salesperson is assigned. No sale is allowed without the customer paying at least 25% down at the time of the sale, the cash receipts are processed by the salesperson that is assisting the customer. Most customers pay the 25%, and then make 3 more equal monthly installments. Some customers pay in full at the time of the sale. A customer's payment may include payments for multiple sales. PhoneSource has only one cash account into which all cash receipts are deposited (including those from sources other than sales, such as bank loans). Salespeople, customers, and inventory items are often input to the system before any transactions involving them occur; however, a customer cannot be entered without assigning a salesperson to him or her. Below, PhoneSource has identified attributes that need to be included in its information system (don't add or subtract any attributes). Beside each attribute is an abbreviation (in bold), which you may use in your conceptual model and in your relational database tables: -phone-stock-number (phone#) -salesperson-name (sp-name) -salesperson-address (sp-add) -sale-date (s-date) -customer-ship-to-address (C-ship) -salesperson-telephone (sp-ph#) -phone-description (p-desc) -customer-billing-address (c-bill) -phone-item-actual-selling price (act-price) -customer-name (c-name) -salesperson-SSN (sp#) -phone-item-list-price (list-price) -customer-number (cus#) -remittance-advice-number (ra) -sale-invoice-number (sale#) -location-of-cash-account (c-loc) -total-quantity-on-hand of each phone type (qoh) -cash-receipt-date (cr-date) -phone-item-standard-cost (std-cost) -total-dollar-amount-of-sale (s-amt) -remittance-advice-total-amount (ra-amt) -cash-account number (C-acct) -cash-account balance (c-bal) -cash-receipt-amount-applied-to-a-sale (cr-app) -quantity-sold of a phone (on a particular sale) (qty-sold) J&B Enterprises Create the conceptual business process model for J&B Enterprises J&B Enterprises offers each of its clients a full range of outsourcing service options which allow those companies to concentrate almost exclusively on their main value- added activities. J&B will do your bookkeeping, computer services, taxes, cleaning, advertising, legal work, etc. for you by dispatching its own well-trained employees to your place of business. Each service engagement involves exactly one type of service, and it must include at least one engagement employee. Each type of service has a standard hourly billing rate. Employees can engage in multiple service engagements, but they have just one hourly wage rate. When a service engagement is completed during a particular month, that client is required to pay in full for it by the 20th of the next month (if a client has had more than one service engagement, one payment can be submitted for all of the engagements). Clients NEVER make partial payments. Although the vast majority of cash receipts come from clients for service engagements, some cash receipts come from other sources (e.g. bank loans). Every cash receiptis processed by exactly one of J&B's several cashiers and is deposited into one of J&B's bank accounts. Information about service types, cashiers, engagement employees, and clients will often need to be entered into the database before any transactions involving them have occurred. Information about cash accounts may not be entered into J&B's system without assigning at least one cash receipt to that account. The following attributes are of interest to potential users of this data model. -name-of-service -invoice#-for-service-rendered -remittance-advice# -cash-account -client# -cashier-SSN -engagement-employee-highest-degree -total-charge-for-service-engagement -bank-account balance -client-name -cash-receipt-amount -bank-account-location -individual-accounts receivable -cashier-phone# -employee-SSN -service-billing-rate -employee-wage-rate (engagement & cashier) (SSN = social security number) PhoneSource Prepare a conceptual model (with entities, relationships, attributes, and multiplicities) for the following business process: PhoneSource is a company that sells several kinds of telephones to customers. Product offerings include traditional corded phones, cordless phones, cellular phones, etc. Each type of phone comes in various models; each model has a different stock number. Although cellular phones must be programmed with unique information for each customer, Phone Source does not offer cellular service or the corresponding programming. Therefore Phone Source does not need to keep track of each individual phone; it is sufficient to track them by model number. PhoneSource has several salespeople who are paid on commission. Although each customer is assigned to one particular salesperson, if a customer's assigned salesperson is not available when the customer comes in, another salesperson may assist that customer. The resulting commission is split between the two salespeople. A customer's assigned salesperson may be unavailable because of a sick day or vacation day or because he or she is helping another customer to whom the same salesperson is assigned. No sale is allowed without the customer paying at least 25% down at the time of the sale, the cash receipts are processed by the salesperson that is assisting the customer. Most customers pay the 25%, and then make 3 more equal monthly installments. Some customers pay in full at the time of the sale. A customer's payment may include payments for multiple sales. PhoneSource has only one cash account into which all cash receipts are deposited (including those from sources other than sales, such as bank loans). Salespeople, customers, and inventory items are often input to the system before any transactions involving them occur; however, a customer cannot be entered without assigning a salesperson to him or her. Below, PhoneSource has identified attributes that need to be included in its information system (don't add or subtract any attributes). Beside each attribute is an abbreviation (in bold), which you may use in your conceptual model and in your relational database tables: -phone-stock-number (phone#) -salesperson-name (sp-name) -salesperson-address (sp-add) -sale-date (s-date) -customer-ship-to-address (C-ship) -salesperson-telephone (sp-ph#) -phone-description (p-desc) -customer-billing-address (c-bill) -phone-item-actual-selling price (act-price) -customer-name (c-name) -salesperson-SSN (sp#) -phone-item-list-price (list-price) -customer-number (cus#) -remittance-advice-number (ra) -sale-invoice-number (sale#) -location-of-cash-account (c-loc) -total-quantity-on-hand of each phone type (qoh) -cash-receipt-date (cr-date) -phone-item-standard-cost (std-cost) -total-dollar-amount-of-sale (s-amt) -remittance-advice-total-amount (ra-amt) -cash-account number (C-acct) -cash-account balance (c-bal) -cash-receipt-amount-applied-to-a-sale (cr-app) -quantity-sold of a phone (on a particular sale) (qty-sold)