Learn ASP.NET MVC and Entity Framework (Database First) - Setting up a Database

This video tutorial guides viewers through setting up a database for a school management project using SQL Server Object Explorer in Visual Studio. It covers creating a new database, adding tables using both scripts and the designer view, and establishing relationships between tables. The tutorial includes creating a student table, a course table, and an enrollment table to track student-course associations and grades.

What data types are used for the title and credits in the course table?

What is the significance of the primary key in the tables created?

What should you do if you want to view the data in a specific table?