Polymer composite materials in automotive industry Coursework

Polymer composite materials in automotive industry - Coursework Example One of the advantages of carbon fibre composite materials that makes them dominant for use in the automotive industry is because they are light weight. The carbon fibre composite materials have an unsurpassed strength-to-weight ratio and low weight that is essential for the automotive industry. For instance, the manufactures of race cars use carbon fibre composite materials hence they have developed ways of giving this carbon fibre pieces strength in a particular direction i.e. ensuring it is strong in direction bearing the load while weak in directions where little or no load is concentrated in the car. The current trend of materials in car industry of replacing metal parts more and more by polymer composites is aimed at improving the fuel economy the weight of the vehicles. (David, 2007) There has been increased use of carbon fibre composite materials in the automotive industry because of their cost. The cost of a new material is always compared to that presently employed in a prod uct, hence making it one of the most important variables that determines whether any new material has an opportunity to be selected for a vehicle component. When we talk of the cost of composite materials, it refers to actual cost of raw materials, manufacturing value added, and the cost to design and test the product. In terms of cost, the carbon fibre composite materials are relatively cheaper as compared to other materials such as cast irons, steel, cast aluminum and magnesium hence their continued use in the automotive industry.

Advanced SQL Queries for the Pine Valley Furniture Company Database Term Paper

Advanced SQL Queries for the Pine Valley Furniture Company Database - Term Paper Example To get the result, we need to sort the prices of the products and choose the one that is the least among them all. In the parameters for the queries, we indicate that we would like to pick the top item from the field whose values have been sorted in ascending order. From then on, we display the top 1 item to show us the least item in terms of the price. This query is obtained from the employee table and the work center table. From the employee table, we get the employee identifications and the names of the employees. The work center table is only meant to give us the work center identifications for the employees. Once we get the values from both of the tables, we make the query. The above query is made on the order line table of the database. This table contains both the order ids as well as the product identification numbers. In order to know which different products are contained in the order number 1006, we design the query in such a way that we display the order ids for all the product lines while indicating the product line number 1006 as the only restriction on the query. In order to know the discounted product prices for the products manufactured by the product line 3, we need to calculate the discounted prices and display them on a different column. The operands for the calculation are the Standard_Price for all the products, and 0.9.