ABC Ltd plans to computerise its sales ordering and stock control system. A feasibility study hasstrongly suggested that a relational database system be installed. The details of ABC's sales and stock control are as follows:

Customers send in orders for goods. Each order may contain requests for variable quantities of one or more products from ABC's range. ABC keeps a stock file showing for each product the product details and the preferred supplier, the quantity in stock, the reorder level and other details.

ABC delivers those goods that it has in stock in response to the customer order and an invoice is produced for the despatched items. Any items that were not in stock are placed on a back order list and these items are usually re-ordered from the preferred supplier. Occasionally items are ordered from alternative sources.

In response to the invoices that are sent out to ABC's customers, the customers send in payments. Sometimes a payment will be for one invoice, sometimes for part of an invoice and sometimes for several invoices and part-invoices.

Draw an entity-relationship model, stating any assumptions made. Make sure you remove all many-many relationships and replace them with new entity types and relationship types.

Read the following scenario and answer the question in 5-10 sentences. you are the owner of a small business that is a defendant in a lawsuit in federal court. you received bad news from your lawyer that the judge did not allow certain documents to be admitted as evidence in court and that the jury reached a $50,000 verdict in favor of the plaintiff. your lawyer tells you that it is within your legal right to hire him to file an appeal with the united states court of appeals. if the appellate court rules in your favor, you may be able to avoid paying part or all of the $50,000. evaluate your lawyer’s suggestion about appealing the decision.

In december of 2004, the company you own entered into a 20-year contract with a grain supplier for daily deliveries of grain to its hot dog bun manufacturing facility. the contract called for "10,000 pounds of grain" to be delivered to the facility at the price of $100,000 per day. until february 2017, the supplier provided processed grain which could easily be used in your manufacturing process. however, no longer wanting to absorb the cost of having the grain processed, the supplier began delivering whole grain. the supplier is arguing that the contract does not specify the type of grain that would be supplied and that it has not breached the contract. your company is arguing that the supplier has an onsite processing plant and processed grain was implicit to the terms of the contract. over the remaining term of the contract, reshipping and having the grain processed would cost your company approximately $10,000,000, opposed to a cost of around $1,000,000 to the supplier. after speaking with in-house counsel, it was estimated that litigation would cost the company several million dollars and last for years. weighing the costs of litigation, along with possible ambiguity in the contract, what are three options you could take to resolve the dispute? which would be the best option for your business and why?

During the holiday season, maria's department store works with a contracted employment agency to bring extra workers on board to handle overflow business, and extra duties such as wrapping presents. maria's is using during these rush times.