Final Comprehensive SQL Assignment

For this assignment, use the "Fabric" database.

Consult the Fabric database primary key to foreign key mappings to study the relationships among the tables in the Fabric database. (https://drive.google.com/file/d/0B7Y7z0UrG0Tbb1M1NWpDTW0wc1E/view)

Consult the Fabric Data Dictionary for detail on the definitions of each table's attributes.

(https://docs.google.com/spreadsheets/d/19Ofe2aBsqSof1tLaAL2nNxMRcNAzMwH1Osm3kveny0E/edit#gid=803935257)

1.Return the first and last names of all of the clients in the Clients table who have a credit rating less than or equal to 795 who live in the following states: 'NY','IL','TN','PA','WI','VA'. Order your output alphabetically by last name and then by first name.

2.How many Clients are currently over 70 years of age?

3.How many orders have been placed by customers in Ohio?

4.What was the total cost of line number 2 of order ID 1587? Round to 2 decimal places.

5.If prices on all products were reduced by 20%, how many products would still cost more than $9.00?

6.Return a list of the states and the average client credit rating per state for all states with an average credit rating greater than 675. Order your output from highest to lowest average rating. Round your credit ratings to the whole number.

7.Make list of all of the Occupations Names and their corresponding average credit rating for only those occupations that have more than 6 Clients working in them. Order your output from the highest average credit rating to the lowest. Round your average rating output to the whole number.

8.Increase the cost of all velvet fabrics by 25%.

9.Delete all the OrderLines from Orders that have an order status of canceled.

10.Cancel any orders from Edwin Ortiz that are currently Order Status "P". (Hint - be sure to consult the data dictionary to understand how to make this.)

11.Bonus: Cancel the latest order from the client 868..

HP'WPWI'J!' List the reasons for good em ployerf'employee relations Discuss upward and downward communication Discuss job security and downsizing Discuss the Human Resource Department's role in communication, motivation and discipline Apply the appropriate progressive discipline response to various situations Describe with examples what employee engagement is. Explain advantages and disadvantages of different types of communication used in employee communication and its effect on employee engagement. (upward, downward, horizontal, verbal, nonverbal, etc} Learning Communications and operations Security Outcome(s): Q3) Email is the most preferred way of communication in many sectors currently. LO 5: Use Apart from its advantages in communication, emails are also prone to cause effective, proper various threats to the information technology framework. Explain in the various and state of the threats (minimum 2) of emails being sent over the internet or a network, and the art security tools techniques (minimum 2) to protect the messages sent over emails. and technologiesDefine the four following key legal terms in the context of computer security. (14 Points) Each definition must be at least 100 words long or it will receive no credit. 1) Information and Communication Technology Supply Chain Risk Management. 2) Social Engineering 3) Information and Communication Technology Supply Chain Risk 4) Information and Communication Technology Supply Chain Risk building blocksDiacrawlw Math / Mathematical foundationa for computer asianem :.] Which multiply quent fed atelement is equivalent Is the following ? (Assume that the domain of beth variable x and variable y seraiata of all real mumbers) The sum of two positive rual numbera is always a mugutive ruel number. Ex Vy ((x 0)) ((0 > 6+ 2) + (0 fVO > >)) REZA 3x 3y ((x 0)) Suppose that one is performing the bitwise AND of the two 8-bit strings shown below What 8-bit string should fill in the blank? 1110 1001 A 1010 0011 Suppose that .. . p represents the proposition You have a life jacket. . q represents the proposition You can swim. Translate the statement given below into propositional logic