A micro project report on
DESIGN AND IMPLEMENT UNIVERSITY DATABASE FOR
EXTERNAL EXAMINATION SCHEDULE
Submitted to CMR Institute of Technology in partial fulfillment of the requirement for the
award of laboratory Database Management System of II B. Tech II semester.
DEPARTMENT OF ELECTRONICS AND
COMMUNICATION ENGINEERING
Submitted by
N. HYMA REDDY 22R01A0443
N. REVATHI CHOWDARY 22R01A0444
N. HIMA VENKAT SAI 22R01A0445
N. JAHNAVI 22R01A0446
Under the Guidance of
Mrs. B. Annapoorna
CMR INSTITUTE OF TECHNOLOGY
(UGC AUTONOMOUS)
(Approved by AICTE, Affiliated to JNTUH, Kukatpally, Hyderabad)
Kandlakoya, Medchal Road, Hyderabad (2022-2023)
2023-2024
DEPARTMENT OF ELECTRONICS AND
COMMUNICATION ENGINEERING
CERTIFICATE
This to certify that a Micro Project entitled with “DESIGN AND IMPLEMENT
UNIVERSITY DATABASE FOR EXTERNAL EXAMINATION SCHEDULE”is being
Submitted By
N. HYMA REDDY 22R01A0443
N. REVATHI CHOWDARY 22R01A0444
N. HIMA VENKAT SAI 22R01A0445
N. JAHNAVI 22R01A0446
In partial fulfilment of the requirement for award of the “DATABASE MANAGEMENT
SYSTEM” of II B.Tech II- Semester in ECE to the CMRIT, Hyderabad is a record of a bonafide
work carried out under our guidance and supervision.
Signature of Faculty Signature of HOD
Mrs.B.Annapoorna Dr.K.Niranjan Reddy
(Assistant professor) (Head of the Department)
ACKNOWLEDGEMENT
We are extremely grateful to Dr. M. Janga Reddy, Director, Dr. G. Madhusudhana Rao, principal
and Dr. K. Niranjan Reddy, Head of Department, Dept of electronics and communication
Engineering, CMR Institute of their inspiration and valuable guidance during entire duration.
We are extremely thankful to our DBMS Lab faculty in-charge Mrs. B. Annapoorna, Dept of
Electronics and Communication Engineering, CMR Institute of Technology for her constant
guidance, encouragement and moral support throughout the project.
We express our thanks to all staff members and friends for all the help and coordination extended
in bringing out this project successfully in time.
Finally, we are very much thankful to our parents and relatives who guided directly or
indirectly for successful completion of the project.
N. HYMA REDDY 22R01A0443
N. REVATHI CHOWDARY 22R01A0444
N. HIMA VENKAT SAI 22R01A0445
N. JAHNAVI 22R01A0446
CONTENTS:
S.no Particulars Page No
1 Introduction 1-3
2 Requirements 4
3 Implementation 4-8
4 Conclusion 8
5 References 8
INTRODUCTION
Database Management Systems:
A database management system (or DBMS) is essentially nothing more than a computerized
data-keeping system.
Users of the system are given facilities to perform several kinds of operations on such a
system for either manipulation of the data in the database or the management of the database
structure itself.
There are several types of databases that can be used on a mainframe to exploit z/OS®:
inverted list, hierarchic, network, or relational
SQL:
SQL stands for Structured Query Language. It is used for storing and managing data in
relational database management system (RDMS).
It is a standard language for Relational Database System. It enables a user to create, read,
update and delete relational databases and tables.
All the RDBMS like MySQL, Informix, Oracle, MS Access and SQL Server use SQL as
their standard database language.
SQL allows users to query the database in a number of ways, using English-like
statements.
Rules:
SQL follows the following rules:
Structure query language is not case sensitive. Generally, keywords of SQL are written in
uppercase.
Statements of SQL are dependent on text lines. We can use a single SQL statement on one
or multiple text line.
Using the SQL statements, you can perform most of the actions in a database. SQL
depends on tuple relational calculus and relational algebra
SQL Commands:
SQL commands are instructions. It is used to communicate with the database. It is also used
to perform specific tasks, functions, and queries of data.
SQL can perform various tasks like create a table, add data to tables, drop the table, modify
the table, set permission for users.
1
Types of SQL Commands:
There are five types of SQL commands: DDL, DML, DCL, TCL, and DQL.
Data Definition Language (DDL):
DDL changes the structure of the table like creating a table, deleting a table, altering a
table, etc.
All the command of DDL is auto-committed that means it permanently saves all the
changes in the database.
Here are some commands that come under DDL:
CREATE
ALTER
DROP
TRUNCATE
a. CREATE It is used to create a new table in the database. Syntax: CREATE TABLE
TABLE_NAME (COLUMN_NAME DATATYPES [... ]);
b. DROP: It is used to delete both the structure and record stored in the table. Syntax:
DROP TABLE table_name;
2
c. ALTER: It is used to alter the structure of the database. This change could be either to
modify the characteristics of an existing attribute or probably to add a newattribute.
Syntax: ALTER TABLE table_name ADD column_name COLUMN-definition;
d. TRUNCATE: It is used to delete all the rows from the table and free the space containing
the table. Syntax: TRUNCATE TABLE table_name;
Data Manipulation Language:
DML commands are used to modify the database. It is responsible for all form of changes
in the database.
The command of DML is not auto-committed that means it can't permanently save all the
changes in the database. They can be rollback.
INSERT
UPDATE
DELETE
a. INSERT: The INSERT statement is a SQL query. It is used to insert data into the row of a
table. Syntax: INSERT INTO TABLE_NAME (col1, col2, col3. ............. col N) VALUES (value1,
value2, value3, ..... valueN);
b. UPDATE: This command is used to update or modify the value of a column in the table.
Syntax: UPDATE table_name SET [column_name1= value1,. column_nameN = valueN]
[WHERE CONDITION]
c. DELETE: It is used to remove one or more row from a table. Syntax: DELETE FROM
table_name [WHERE condition];
REQUIREMENTS:
Hardware Requirements: Intel(R) Core (TM) i7-1005G1 CPU @ 1.20GHz 1.19 GHz 4 GB
OF RAM
Software Requirements: Windows 11 Home Single Language Oracle Database 11g
ExpressEdition
IMPLEMENTATION:
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
FirstName VARCHAR(50),0
3
LastName VARCHAR(50),
Email VARCHAR(100)
);
CREATE TABLE Subjects (
SubjectID INT PRIMARY KEY,
SubjectName VARCHAR(50)
4
);
CREATE TABLE Exams (
ExamID INT PRIMARY KEY,
SubjectID INT,
ExamDate DATE,
StartTime TIME,
EndTime TIME,
Location VARCHAR(100),
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);
5
CREATE TABLE Exams ( ExamID
INT PRIMARY KEY,
SubjectID INT,
ExamDate DATE,
StartTime TIME,
EndTime TIME,
Location VARCHAR(100),
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);
6
7
CREATE TABLE Enrollments (
EnrollmentID INT PRIMARY KEY,
StudentID INT,
SubjectID INT,
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);
8
CONCLUSION:
In conclusion, the implementation of a university database for external examination
schedules is a pivotal step towards enhancing efficiency, transparency, and overall
effectiveness in managing academic assessments. This database not only streamlines the
scheduling process but also offers a centralized platform for storing, accessing, and updating
critical information related to external examinations. By adopting such a system, universities
can ensure seamless coordination between various departments, faculty members, and
external examination bodies.
REFERENCE:
ChatGPT (openai.com)
DBMS Tutorial - Database Management System - GeeksforGeeks
Database Management Systems and SQL – Tutorial for Beginners
(freecodecamp.org)
BMS SQL Table - javatpo
9
10 | P a g e
