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 is the first step in setting up the database for the school management project?

• Install SQL Express

• Enter data into the database

• Open SQL Server Object Explorer

• Create a new table

What is the recommended name for the new database in the tutorial?

• studentDB

• managementDB

• schoolDB

• school.Management.Db_db

What is the purpose of using script files in the database setup process?

• To install SQL Server

• To backup the database

• To automate the creation of tables

• To update Visual Studio

Which data type is used for the 'title' column in the course table?

• int

• varchar

• nvarchar

• text

What is the primary key in the course table?

• Credits

• Title

• Course ID

• Course Name

What is the role of the enrollment table in the database?

• To manage course schedules

• To track faculty assignments

• To link courses and students

• To store student grades

What type of relationship does the enrollment table facilitate?

• One-to-One

• Many-to-Many

• Many-to-One

• One-to-Many