Expert Answers

Consider the following three tables: PC, Laptop and Product, and the data as given.

Sample Data for PC

model speed ram hd price

1001       2.66        1024       250         2114

1002       2.10        512         250         995

1003       1.42        512         80           478

1004       2.80        1024       250         649

1005       3.20        512         250         630

1006       3.20        1024       320         1049

1007       2.20        1024       200         510

1008       2.20        2048       250         770

1009       2.00        1024       250         650

1010       2.80        2048       300         770

1011       1.86        2048       160         959

1012       2.80        1024       160         649

1013       3.06        512         80           529

Sample Data for Laptop

model speed ram        hd           screen price

2001       2.00        2048       240         20.1        3673

2002       1.73        1024       80           17.0        949

2003       1.80        512         60           15.4        549

2004       2.00        512         60           13.3        1150

2005       2.16        1024       120         17.0        2500

2006       2.00        2048       80           15.4        1700

2007       1.83        1024       120         13.3        1429

2008       1.60        1024       100         15.4        900

2009       1.60        512         80           14.1        680

2010       2.00        2048       160         15.4        2300

Sample Data for Product

maker model type
A 1001 PC
A 1002 PC
A 1003 PC
A 2004 Laptop
A 2005 Laptop
A 2006 Laptop
B 1004 PC
B 1005 PC
B 1006 PC
B 2007 Laptop
C 1007 PC
D 1008 PC
D 1009 PC
D 1010 PC
D 3004 Printer
D 3005 Printer
E 1011 PC
E 1012 PC
E 1013 PC
E 2001 Laptop
E 2002 Laptop
E 2003 Laptop
E 3001 Printer
E 3002 Printer
E 3003 Printer
F 2008 Laptop
F 2009 Laptop
G 2010 Laptop
H 3006 Printer
H 3007 Printer

Compute the results for the plans below, for each of the steps labeled with a number. When reporting the result, you must include the names of the columns of each result table, along with the data.

Write the SQL for both questions along with the computed results

A concrete beam of rectangular sections is 10 cm wide and is reinforced with steel bars whose axes are 30 cm below the top of the beam. Estimate the required total area of the

cross-section of the steel if the maximum compressive stress in the concrete is to be 7.5 MN/m2 and the tensile stress in the steel is 135 MN/m2 beam is subjected to pure

bending. What bending moment would the beam withstand when in this condition? Assume that Young's modulus for steel is 15 times that for concrete and that concrete can

sustain no tensile stresses. (Cambridge)

According to the extract, opportunities are related to favourable circumstances that the company needs to make use of in
order to improve its position on the market whilst threats are factors that cannot be controlled but need to be acknowledged.
As the General Manager of Young Talent Shoe Factory (a factory that makes shoes for young people), highlight FIVE (5)
macro environmental forces that may impact your factory and the opportunities and/or threats they will present for your
factory.