Data Analytics – November 2022

DAY 1,2, 3: Click here to Download the class excel file

Click here to watch the Day 1 video

Assignment

Develop

1. Library Management System – think of different tables it can have and also add columns to those tables

2. Add constraints to columns as applicable

3. Add data types to each column

4. Add atleast 5 sample data to each table

 

SQL Server 

 

DATATYPES: