You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing company that specializes in wines imported from Australia, Chile, United States and United Kingdom. The owner, Tim Tipple, has been considering expanding his inventory to include beer, liquor and liqueurs. Due to the increased complexity in record keeping, Tim wants to improve the Shipping/Receiving and Sales management system. Currently, each department completes its own paperwork and maintains its own records with its own software application. Departments communicate details by telephone or paper. Several costly mistakes have resulted in the loss of too many good customers. To improve customer service and avoid communication errors, High Spirits' owner wants one system that provides employees with access to all administrative functions. The new application will provide an integrated interface, so Shipping/Receiving can manage inventory levels, and Sales Managers can easily invoice customers and obtain customer account information. Mr. Tipple wants access to all features of the new application. Naturally, built-in security features prevent unauthorized individuals from obtaining sensitive information. Mr. Tipple's long term plans include company expansion into new markets. He would like to open new branches in the future. You are part of a team of IT professionals hired to implement a business solution for High Spirits' administrative problem. Your team understands the importance of integrating current business practices, rules and documentation into any new system. General Requirements The High Spirits Imports Management System enables Shipping/Receiving and Sales Managers to effectively manage inventory and sales. The systems analyst on your team has produced a system chart that describes the proposed application based on interviews to discover Mr. Tipple's requirements, company documents, and employee work habits and requirements. Figure 1: System flowchart for the High Spirits Imports Management System Sales Managers complete the initial paper-based sales contract, recording product particulars between the customer and High Spirits. They are responsible for inputting new customers and new sales into the system, and generating invoices. They maintain customer relationships, and deal with customer concerns or complaints. Shipper and receivers adjust inventory information, recording inventory particulars and quantities based on purchases and sales (transactions) of product. They are responsible for inputting new inventory into the system. Tim Tipple, the owner, can perform all functions including purchase new inventory. Database Usage The systems analyst has discovered the following facts about how the database will be used: ? Since the way the database is described is fairly normalized, joins will be frequently used in the HighSpirits application. ? Typically, a sales manager will search for a customer by phone number. They will want to know the customer's first and last name initially, and may opt to do a search for other information later on. ? Searches in the Products table typically involve a Product number, and any or all of name, country, quantity, price and type. Most often the search involves Product number, quantity and price. ? Searches in the Transaction table typically involve a Transaction number, type, and date. ? Searches in the TransactionDetails table typically involve the Product or Transaction ID, price and quantity. ? The Country, Size, Product Types and Transaction Type tables are searched for each new transaction. ? Product stock information tends to change often. New customers and transactions are added continuously throughout the year. ? Retail prices are at least 110% of cost. Discounts or higher retail prices apply at Mr. Tipple's discretion. ? Unit cost price includes any duties or taxes. Cost is 91% or less of retail price. Payment Procedures Payments entered into the database incorrectly cannot be deleted. Instead, they are voided. A voided payment has a payment value of $0.00. A reason should always be given for a voided payment. By voiding a payment instead of deleting it, HighSpirits ensures that it has an accurate record of all payments made, even if some of the entries were originally incorrect. Also, voiding payments prevents employee theft. Auditing System In order to keep track of amendments to transactions, Mr. Tipple would like an auditing system implemented. The auditing system should record whenever changes have been made to the Transactions table. Specifically, you should record when the changes were made, what fields were affected, and what their old and new values were. Based on the preliminary findings of the systems analyst, you will need to formalize the database design and use a DBMS (SQL Server, MySQL, etc) to build the database. You will NOT be required to build all the functionality as described above as part of this initial project. You will be responsible only for specific parts of the system and implementing specific features as described below. You should complete the following steps: 1. Analyze the data requirements described in the previous section. Decide which tables are required and which fields should go in which table. Normalize your design. If you wish, you may use an entity-relationship diagram. Create your table design showing the relationships between each table. It is now time for your instructor to check your progress. After you have finished the preliminary design for the High Spirits Imports Management System, contact your instructor for a brief review. 2. Using your DBMS, create an SQL script to create the High Spirits database. Name the database HSxxxxx, where xxxxx is your student number. Save your script as

. Create a script that will show a list of products (product name, type, size) that have been purchased. Note: You must use an outer join for this query; a subquery is not acceptable. Save your script as step8.sql. After running the script, save a screen capture of the output and save it as step8-output.jpg 9. Create a script that will show a list of products (product name, type, size, supplier) that are from Australia. Save your script as step9.sql. After running the script, save a screen capture of the output and save it as step9-output.jpg 10. Create a script that will show a list of products (product name, type, size, customer, retail price, quantity sold). The script should also calculate the sum of the price field and the sum of the quantity sold from all times the products were sold and display it as a calculated field. Do not include purchases (Remember the status field is set to 0 for sales and 1 for purchases). Save your script as step10.sql. After running the script, save a screen capture of the output and save it as step10-output.jpg 11. Using your DBMS Help feature, explore the use of the SHOW command to display the contents of your database. Create a script that will display a list of tables in the database. Save this script as step11a.sql. Then create a script for each of the four main tables (Customers, Transactions, Products, Transaction details that will display all of the columns in the table. Save your scripts as step11b.sql to step11e.sql. 12. Finally, you will need to create the HS_Employees database. Using the data in the HS-Employees.xls spreadsheet, create a script to populate the Employees database with the data found there. Employee ID's should be unique and start with the two employee initials and then increment by a value of 1. It should be the primary key. Social Insurance numbers are unique for each individual. However, this does not make for a good Primary Key. You must ensure that there is not the ability to incorrectly enter someone else's SI number by mistake by making this field unique. Create the employee database and populate the employees table with the data as indicated above. Save your scripts as step12.sql and step12a.

4.111e main pinpoint difference between tort law and contract law is the basis ofthe formation of the contract or the consent involved In a contract lawthe consent must be clean and shall not be coerced, where as in tort law it is an intrusion by one party into the safety, health, prot, or privacy of the victim 5 External environment refers to Macro environment, and the manager should talre care ofthe political changes like, change in the govemment, influences of the political parties and also the technological changes like updated versions of the business sofbvare, or any new technological trends etc can also be considered as ted'inological trends and a manager must take of the the above things to successfully guide the organization towards success Apart from potical and technological aspects. we also have Legal, Economical, Social. {FEE-TL} 6. It depends on one's own perspective, CSR can be a marketing gimmidcto business people where as to consumer {at least for some] it may not. Drganizations that perform well with. regard to CSR can build their reputation, while those that perform poorly can damage brand and company value when exposed. Reputation, or brand equity, is founded on values such as bust, credibility, reliability,gua|ity and consistency. Corporate social responsibility is nothing but a marketing gimmickto a greater extent because according to the Liberian international ship and corporate registry the results of corporate social responsibility include recmitment, mtivation, retention and cost savings in the long term 18. A researcher want to examine the impact of multiple risk factors (e.g. gender, race, age, blood pressure and etc.) on the development of CVD and to assess potential confounding and/or effect modification, which of the following would be the most appropriate method? [HINT: the outcome variable is CVD diagnosis (measured as CVDo CVD)] A) Simple linear regression analysis B) Simple logistic regression analysis C) Multiple linear regression analysis D) Multiple logistic regression analysis rue/False lationPart 3 Arab United Company expects sales during 2013 to rise from the 2012 level of $3.5 million to $3.9 million. Because of a scheduled large loan payment, the interest expense in 2013 is expected to drop to $325,000. The firm plans to increase its cash dividend payments during 2013 to $320,000. The company's year-end 2012 income statement follows. Euro Designs, Inc. Income Statement for the Year Ended December 31, 2012 Sales revenue $3,500,000 Less: Cost of goods sold 1,925,000 Gross profits $1,575,000 Less: Operating expenses 420,000 Operating profits $1,155,000 Less: Interest expense 400,000 Net profits before taxes $ 755,000 Less: Taxes (rate = 40%) 302,000 Net profits after taxes $ 453,000 Less: Cash dividends 250,000 To retained earnings $ 203,000 a. prepare a 2013 pro forma income statement using the percent-of-sales method to b. Analyze the financial plan and explain why the statement may underestimate the company's actual 2013 pro forma income.7. Supplies on hand at December 31, 2015 had a cost of $600. 6. The correct adjusting entry for number "1" above includes a A. Debit to Insurance Expense for $900 O B. Debit to Prepaid Insurance for $450 O C. Debit to Insurance Expense for $450 D. Credit to Prepaid Insurance for $900 QUESTION 6 Using the information from above... The correct adjusting entry for number "4" above includes a A. Credit to Interest Expense for $110 B. Debit to Interest Expense for $110 O C. Debit to Interest Payable for $110 D. Credit to Interest Payable for $290 QUESTION 7 Using the information from above... The correct adjusting entry for number 5" would be A- Debit to Prepaid Rent for $500 B. Debit to Rent Expense for $500 C. Credit to Rent Expense for $100 OD. Debit to Prepaid Rent for $100