e t e e 25. COMPREHENSIVE CASE Classic Restorations Classic Restorations has a legacy accounting system that employs a combination of manual procedures supported by standalone PCs in various depart- ments. You have been retained by Classic Restora- tions to design a relational database system that will allow the company to automate its processes. The company's revenue cycle and expenditure cycle pro- cedures are presented in the following paragraphs. Sales Order Procedures Classic Restorations' sales department is at its head- quarters in Los Angeles. All customer orders go through sales representatives who visit current and pro- spective customers in their sales districts. The orders are