22319 Database Management System Micro Project Report PDF Download
Micro Project Topic:- “Execute queries using SELECT
command with WHERE and HAVING clause”
command with WHERE and HAVING clause”
Program: Diploma in Computer Engineering
Class: Third Year (Semester 3)
Course: 22319 Database Management System
(Subject Code: 22319)
Execute queries using SELECT command with WHERE and HAVING clause:-
1.0 Rationale
What's is Database Management Systems (DBMS) are vital components of modern information systems.
Database applications are pervasive and range in size from small in-memory databases to terra
bytes or even larger in various applications domains. The course focuses on the fundamentals of
knowledgebase and relational database management systems, and the current developments in
database theory and their practice.
2.0 Aim Of Micro-Project
Creating a database with two tables holding specific data in its tuples. Executing
queries with the use of SELECT command with WHERE and HAVING clause to get a
desired output through certain conditions.
Method: Using Transformations.
3.0 Course Outcomes Addressed
a) Create and Manage Database using SQL.
b) Design Normalized database on given data.
c) Create and manage Data base using SQL command.
d) Write a SQL command for given data base.
e) Apply security and confidentiality on given database.
4.0 Literature Review
To satisfy the needs of users outside of business applications, DBMSs must be expanded to
offer services in two other dimensions, namely object management and knowledge management.
Object management entails efficiently storing and manipulating non-traditional data types such as
bitmaps, icons, text, and polygons. Object management problems abound in CAD and many other
engineering applications. Knowledge management entails the ability to store and enforce a
collection of rules that are part of the semantics of an application. Such rules describe integrity
constraints about the application, as well as allowing the derivation of data that is not directly stored
in the database.
A) SELECT COMMAND -
B) WHERE CLAUSE -
C) HAVING CLAUSE –