Question
1. Explain what might cause problems when importing into MS Access the following .csv file How could you fix this problem? 2. Assume you have
1. Explain what might cause problems when importing into MS Access the following .csv file
How could you fix this problem?
2. Assume you have tables Inventory and Providers as follows:
3. What is the output, in table format of the following SQL statement:
4. Based on the tables above, provide an SQL statement to display the total value of the stock for each provider as below:
5. Identify the errors in the following statement and fix them
6. You work in a business and receive the following .csv file from your offices in Frankfurt:
Explain what might cause problems when importing it into MS Access. How could you fix this problem?
7. Assume you have a table named EmployeeTable containing information about employees in a company, which contains the following columns:
The column Education measures the educational level of each employee from 1 encoding primary education, to 5 encoding doctoral studies. We are interested in understanding the average educational level for each educational field. Write a SQL instruction that will provide this summary information
8. Following on the sample table above, we would like to know the number of employees in each educational level. To avoid using the encoding 1,. . . , 5 we use the table named Education with more user friendly descriptors.
Provide a SQL instruction that will result in the output below
10. Give an example of the use of the SQL keyword PARAMETERS applied to the tables in the previous two questions to produce output as follows:
TradeID, CounterpartyID, SalespersonID, TradeDate, SettelementDate, Notional 123112,27362,24724,12/03/20,03/03/20,100000 252355,35266,36464,05/01/20,05/15/20,250000 235536,64363,46536,01/23/20,02/01/20,145000000 SELECT Description, ProviderName, Telephone FROM Providers INNER JOIN Inventory ON Providers. ProvideriD = Inventory. Provider ID WHERE UnitsInStock =0; \begin{tabular}{|l|r|} \hline ProviderName & Value of Stock \\ \hline BM Garden Machines & 325,040.00 \\ \hline King Seeds & 10.00 \\ \hline \end{tabular} SELECT Description, (Price-CostPrice) AS Margin, (Price-CostPrice)*UnitsInStock AS SalesValue AVG(Price) FROM Inventory GROUP BY UnitsinStock>0; 123ProviderID;Name;OutstandingBalance2381092;FredsFlowers;23,2892368032;CrazyTulips;104,322 \begin{tabular}{rl|l|} \hline Education & EducationFie \\ 1 & 1 Life Sciences \\ 2 & Other \\ 1 & Medical \\ 2 & Life Sciences \\ 2 mandiral \end{tabular} \begin{tabular}{|rr|r|} \hline Education & \\ \hline ID & & EducationLevel \\ \hline & 1 GCSE \\ \hline & 2 A level \\ & 3 Undergraduate \\ & 4 Masters \\ \hline 5 & PhD \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \multicolumn{1}{|l|}{ Educationlevel } & Number of Employees \\ \hline A level & 132 \\ \hline GCSE & 91 \\ \hline Masters & 225 \\ \hline PhD & 28 \\ \hline Undergraduate & 324 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \hline EducationLevel & Number of \\ \hline GCSE & 91 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started