Answer the following questions 1.Explain by using a practical scenario what the difference between a variable and a parameter are. 2. Using a practical scenario explain the difference between Desktop databases and Server Databases. 3. You have been hired as a Database Developer and you have been given the option to use a trigger and a procedure. When would it be best to use procedures? 4. Write a SQL statement that will create a database named Namibian_Team that will store data for all sporting events represented in the country using the Master database in MS SQL Server. 5. As a database developer, you have to explain with visual representations the difference between a logical design and a physical design
Answer the following questions
1.Explain by using a practical scenario what the difference between a variable and a parameter are.
2. Using a practical scenario explain the difference between Desktop databases and Server Databases.
3. You have been hired as a
4. Write a SQL statement that will create a database named Namibian_Team that will store data for all sporting events represented in the country using the Master database in MS SQL Server.
5. As a database developer, you have to explain with visual representations the difference between a logical design and a physical design
Step by step
Solved in 3 steps
