[go: up one dir, main page]
Scribd
Upload
38 views7 pages

DBMS Journal Guidelines

The document provides guidelines for students' database management system journal at a college. It outlines the requirements for submitting lab assignments, including a certificate, table of contents, and write-up for each assignment. It also describes the assessment parameters and grading weightage. An index of experiments is included, listing the topics and objectives to be covered in each lab assignment.

Uploaded by

BCA SY 63 Aaditi Ranaware
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
38 views7 pages

DBMS Journal Guidelines

The document provides guidelines for students' database management system journal at a college. It outlines the requirements for submitting lab assignments, including a certificate, table of contents, and write-up for each assignment. It also describes the assessment parameters and grading weightage. An index of experiments is included, listing the topics and objectives to be covered in each lab assignment.

Uploaded by

BCA SY 63 Aaditi Ranaware
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

GENBA SOPANRAO MOZE COLLEGE OF ENGINEERING,

Balewadi-Baner, Pune- 411 045

Department Of MCA

Guidelines for Student’s DBMS Journal


The laboratory assignments are to be submitted by student in the form of journal. Journal
consists of Certificate, table of contents, and handwritten write-up of each assignment (Title,
Objectives, Problem Statement, Outcomes, software & Hardware requirements, Date of
Completion, Assessment grade/marks and assessor's sign.

Guidelines for Assessment


Each lab assignment assessment will assign grade/marks based on parameters with appropriate
weightage. Suggested parameters for overall assessment as well as each lab assignment
assessment include- timely completion, performance, innovation, efficient codes, punctuality and
neatness.

Course Objectives:

1. Develop a broad understanding of database concepts and database management system


software, data models, schemas and instances, data constraints, relational algebra, and calculus.
2. Acquire Knowledge to model an application’s data requirements using conceptual modeling
tools like ER diagrams and design database schemas based on the conceptual model.
3. Be able to write SQL and PL/SQL commands to create and manipulate database objects.
4. Construct advanced SQL queries on data and applies Procedural abilities through PL/SQL
4. Use modern database techniques such as NOSQL.

Course Outcomes:
On completion of the course, learner will be able to–
CO1: Design E-R Model for given requirements and convert the same into database tables.
CO2: Use database techniques such as SQL & PL/SQL.
CO3: Use modern database techniques such as NOSQL.
CO4: Explain transaction Management in relational database System.
CO5: Describe different database architecture and analyses the use of appropriate architecture in
real time environment.
CO6: Students will be able to use advanced database Programming concepts Big Data –
HADOOP
.
Table 1. INDEX OF EXPERIMENTS

SR.no Date Title Page no Teachers


Sign
1 07/04/2023 Implementation of DDL commands of SQL with
suitable examples
 Create table
 Alter table
 Drop Table

2 19/04/2023 Implementation of DML commands of SQL with


suitable examples
 Insert
 Update
 Delete

3 21/04/2023 Implementation of different types of function with


suitable examples
 Number function
 Aggregate Function
 Character Function
 Conversion Function
 Date Function

4 28/04/2023 Implementation of different types of operators in


SQL
 Arithmetic Operators
 Logical Operators
 Comparison Operator
 Special Operator
 Set Operation
5 03/05/2023 Implementation of different types of Joins
 Inner Join
 Outer Join
 Natural Join etc..

6 10/05/2023 Study and Implementation of


 Group By & having clause
 Order by clause
 Indexing

7 17/05/2023 Study & Implementation of


Sub queries
Views

8 19/05/2023 Study & Implementation of PL/SQL

9 26/05/2023 Study & Implementation of SQL Cursors

10 02/06/2023 Study & Implementation of SQL function and


procedure

11 07/02/2023 Study & Implementation of SQL Triggers

12 14/02/2023 Study of Open Source NOSQL Database:


MongoDB (Installation, Basic CRUD operations,
Execution)

13 16/06/2023 Design and Develop MongoDB Queries using


CRUD operations. (Use CRUD operations, SAVE
method, logical operators)

14 23/06/2023 Design and Implement any 5 query using


MongoDB

15 04/07/2023 Create simple objects and array objects using


JSON
Write-up format for each Lab assignment

Write-up format for each assignment must include

Title
Objectives
Outcomes (Paste print out papers of output)
Software & Hardware requirements
Software & Hardware requirements,
Operating system - windows 10
Processor - 12th Gen Intel(R) Core(TM) i5-12400 2.50 GHz
RAM - 8.00 GB (7.72 GB usable)
SQl/Mysql
Date of Completion
Sample program 1 write up
Date:
Title – Implementation of DDL commands of SQL with suitable examples
 Create table
 Alter table
 Drop Table

Objectives -

Syntax for Queries (Refer Lab Assignment provided)

Actual queries performed to fulfill given objective

Outcomes (Paste print out papers of output)

Important Instructions to follow while writing DBMS journals

1. Student need to follow same format mentioned above.


2. Print Out of your output should be your output for every queries , Records should be
different for every student .
SQL> SELECT * FROM CUSTOMERS;
+ + + + + +
| ID | NAME | AGE | ADDRESS | SALARY |
+ + + + + +
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+ + + + + +
7 rows in set (0.00 sec)

3 students variables, entered values should not be copied, it should be different for every
student.

3 Assignment dates should be same as above mentioned in table 1

You might also like