Question: please show me in plain language and coding question 4-6 Question 4 - Create two tables with the following fields and limit it to 5
Question 4 - Create two tables with the following fields and limit it to 5 rows per table. Please specify data types Table 1 Make, Model, Manufacture Date, Cost, Model_id Table 2 Manufacturer, Model_id, Parts, Warranty_Expiry_Date, City Populate the table with any dummy data but use appropriate data types for each column Question 5.1 Create a query that returns the following fields: Make, Model, Cost, Manufacture Date, Parts, Warranty_Expiry_Date; Store the output in a temp table called "temporary_table" Question 5.2 You encounter the following error: There is atready an bbject nased 'unteng' in the databiase. How do you fix this? Question 6 -Bonus Question Use OPENQUERY to see all fields in a SQL table called isers in an external database called
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
