Question: Using SQL Server Management Studio, create all four tables of the sample database with all their columns. dept_no emp_Iname Smith location dept_no di dept_name Research


Using SQL Server Management Studio, create all four tables of the sample database with all their columns. dept_no emp_Iname Smith location dept_no di dept_name Research emp_no 25348 10102 18316 29346 emp_fname Matthew Ann Jones d3 d3 di Dallas John d2 Barrimore James Seattle James d2 Accounting Marketing d3 Dallas 2581 9031 28559 Elke Elsa Sybill Hansel Bertoni Moser d2 d2 di Table 1-1 The department Table Table 1-2 The employee Table emp_no job enter_date project_no pl budget 120000 project_no PI 10102 2016.10.1 project_name Apollo Gemini Mercury 10102 P3 p2 95000 P2 25348 18316 p3 186500 P2 P2 29346 2581 Table 1-3 The project Table P3 Analyst Manager Clerk NULL NULL Analyst Manager NULL Clerk Clerk Clerk 2018.1.1 2017.2.15 2017.6.1 2016.12.15 2017.10.15 2017.4.15 2017.8.1 2018.2.1 2016.11.15 2017.1.4 P1 9031 28559 28559 P1 P2 9031 P3 P1 29346 Table 1-4 The works_on Table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
