SQL SERVER

Aim: Overview of SQL Server 2018 Databases and Analysis Services. Create a Sample Database Schema using SQL Server Management Studio.

 

Database Engine:

The Database Engine is the core service for storing, processing and securing data. The database engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming application within your enterprise.

Use the database engine to create relational databases for online transaction processing or online analytical processing data. This includes creating table for storing data and database objects such as index, views and stored procedure for viewing, managing and securing data. You can use SQL Server Management Studio to manage the database objects, and SQL server Profiler for capturing server events.

 

Database Tables Design:

Groups Table

 

Students Table

 

 

Marks Table

 

Subject/Teacher Table

 

Subjects Table

 

 

 

 

Database Diagram:

 

Conclusion:

I have learnt about the new software that is MS SQL server management studio in which we can create database and we can handle it easily. We can also create database diagram in it.