ADBMS Assignment - Term 1 ( Data Science), Papers of Database Management Systems (DBMS)

Download ADBMS Assignment - Term 1 ( Data Science) and more Papers Database Management Systems (DBMS) in PDF only on Docsity!

Student Name: Anagha M

Reg No: 9122146001

Course Course: MSc Data Science

Teacher:

ADVANCED DATABASE

MANAGEMENT SYSTEM

LAB

PROJECT 1

16 June 2022

PROGRAM FOR STUDENT RESULT CALCULATION

AIM

To write a program for student’s result calculation: Getting marks from then find out the grade of the given marks. SYNTAX  Create table Create table

(column1 datatype, column2 datatype);  Insert the records Insert intovalues(set of values);  Alter table Alter tableadd(column data type);  Update table Updateset=, =, … =);  Select statement Select * from ; PROCEDURE

1. Create a table to Stud_det Table created.

The table created. From the given details mark total, average, percentage and grade of each students found.