Download Dbms practical file aktu and more Papers Database Management Systems (DBMS) in PDF only on Docsity!
LABORATORY MANUAL
Database Management Systems Lab
(KCS- 551 )
B.TECH
(III YEAR – ODD SEM)
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
IMS ENGINEERING COLLEGE
(Affiliated to Dr A P J Abdul Kalam Technical University, Lucknow) Approved by AICTE - Accredited by NAAC – ‘A’ Grade NH#24, Adhyatmik Nagar, Ghaziabad, UP, India www.imsec.ac.in
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
Vision
To provide globally competent professionals in the field of Computer Science & Engineering
embedded with sound technical knowledge, aptitude for research and innovation with ethical
values to cater to the industrial & societal needs.
Mission
M1: To provide quality undergraduate education in both the theoretical & applied
foundations of Computer Science Engineering.
M2: Conduct research to advance the state of the art in Computer Science & Engineering
and integrate the research results as innovations.
M3: To inculcate team building skills and promote life-long learning with a high societal
and ethical values.
Program Outcomes Engineering Graduates will be able to:
1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals, and an engineering specialization to the solution of complex engineering **problems.
- Problem analysis: Identify, formulate, review research literature, and analyze complex** engineering problems reaching substantiated conclusions using first principles of **mathematics, natural sciences, and engineering sciences.
- Design/development of solutions: Design solutions for complex engineering problems and** design system components or processes that meet the specified needs with appropriate consideration for the public health and safety, and the cultural, societal, and environmental **considerations.
- Conduct investigations of complex problems: Use research-based knowledge and research** methods including design of experiments, analysis and interpretation of data, and synthesis of **the information to provide valid conclusions.
- Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern** engineering and IT tools including prediction and modelling to complex engineering activities **with an understanding of the limitations.
- The engineer and society: Apply reasoning informed by the contextual knowledge to assess** societal, health, safety, legal and cultural issues and the consequent responsibilities relevant **to the professional engineering practice.
- Environment and sustainability: Understand the impact of the professional engineering** solutions in societal and environmental contexts, and demonstrate the knowledge of, and need **for sustainable development.
- Ethics: Apply ethical principles and commit to professional ethics and responsibilities and** **norms of the engineering practice.
- Individual and team work: Function effectively as an individual, and as a member or leader in** **diverse teams, and in multidisciplinary settings.
- Communication: Communicate effectively on complex engineering activities with the** engineering community and with society at large, such as, being able to comprehend and write effective reports and design documentation, make effective presentations, and give and **receive clear instructions.
- Project management and finance: Demonstrate knowledge and understanding of the** engineering and management principles and apply these to one’s own work, as a member and **leader in a team, to manage projects and in multidisciplinary environments.
- Life-long learning: Recognize the need for, and have the preparation and ability to engage in** independent and life-long learning in the broadest context of technological change.
GENERAL LABORATORY INSTRUCTIONS
- Students are advised to come to the laboratory at least 5 minutes before (to the starting time), those who come after 5 minutes will not be allowed into the lab.
- Plan your task properly much before to the commencement, come prepared to the lab with the synopsis / program / experiment details.
- Student should enter into the laboratory with:
- Laboratory observation notes with all the details (Problem statement, Aim, Algorithm, Procedure, Program, Expected Output, etc.,) filled in for the lab session.
- Laboratory Record updated up to the last session experiments and other utensils (if any) needed in the lab.
- Proper Dress code and Identity card.
- Sign in the laboratory login register, write the TIME-IN, and occupy the computer system allotted to you by the faculty.
- Execute your task in the laboratory, and record the results / output in the lab observation note book, and get certified by the concerned faculty.
- All the students should be polite and cooperative with the laboratory staff, must maintain the discipline and decency in the laboratory.
- Computer labs are established with sophisticated and high end branded systems, which should be utilized properly.
- Students / Faculty must keep their mobile phones in SWITCHED OFF mode during the lab sessions.Misuse of the equipment, misbehaviors with the staff and systems etc., will attract severe punishment.
- Students must take the permission of the faculty in case of any urgency to go out; if anybody found loitering outside the lab / class without permission during working hours will be treated seriously and punished appropriately.
- Students should LOG OFF/ SHUT DOWN the computer system before he/she leaves the lab after completing the task (experiment) in all aspects. He/she must ensure the system / seat is kept properly.
Study and Evaluation Scheme
Course
Code
Course
Name
Teaching Scheme Credits Assigned
KCS- 551 (P) Database Management systems Lab
Theory Practical Tutorial Theory Practical Tutorial Total
Marks)
LIST OF PROGRAMS Subject: Database Management System Lab Code: KCS- 551
S.NO. NAME OF EXPERIMENT MAPPING
WITH CO
1 Installing oracle/ MYSQL CO 1
2 Creating Entity-Relationship Diagram using case tools. CO 1
3 Writing SQL statements Using ORACLE /MYSQL: a) Writing basic SQL
SELECT statements. b) Restricting and sorting data. c) Displaying data
from multiple tables. d) Aggregating data using group function.
e)Manipulating data. f) Creating and managing tables.
CO
4 Normalization CO 4
5 Creating cursor CO 1
6 Creating procedure and functions CO 2
7 Creating packages and triggers CO 1
8 Design and implementation of payroll processing system CO 3
9 Design and implementation of Library Information System CO 3
10 Design and implementation of Student Information System CO 3
11 Automatic Backup of Files and Recovery of Files CO 3
12 Mini project (Design & Development of Data and Application ) for
following :
a) Inventory Control System. b) Material Requirement Processing. c)
Hospital Management System. d) Railway Reservation System. e) Personal
Information System. f) Web Based User Identification System. g) Timetable
Management System. h) Hotel Management System
CO 3
5. Review the Summary window to verify what is to be installed. Then, click Install.
6. The progress window appears.
7. The Configuration Assistants window appears.
8. Your database is now being created.
9. When the database has been created, you can unlock the users you want to use. Click OK.
10. Click Exit. Click Yes to confirm exit.
Testing Your Installation
To test that your installation completed successfully, perform the following steps:
1. Open a browser and enter the following URL:
https://:1158/em
5. Login again and then create a new database user by filling the below entries and click on creating
workspace
6. Login by using your created username and password and start using ORACLE
PRACTICAL - 2
TITLE: ER Diagram using Dia Tool
2 .1 Objective 2 .2 Theory (Installation & Dia Guide) 2 .3 Assignment 2 .4 Solution to Assignment
2 .1 OBJECTIVE: applying tool to create ER model
2 .2 THEORY AND CONCEPTS:
Introduction to Dia Diagram Editor:
a. Installation Guide
1. Download the installation file for your platform from http://dia-installer.de/.
2. Open the downloaded file, select preferred installation language, and press “OK”.
3. The Dia “Setup Wizard” window will appear. Click “Next”.
6. Choose the installation location on your computer and click “Install”.
7. After the installation process is completed, click “Finish”.
b. Dia User Guide
Create an ER Diagram
In this section, basic guidelines are given on how to create ER database diagrams. An ER diagram consists of
entity sets, attributes, and the relationship sets between entity sets. Let us create an ER diagram for a
database called “Courses and Students”. The database will have two main entity sets, i.e., “Course” and
“Student”. The relation between them defines which students belong to which course.
1. Start Dia Diagram Editor.
2. On the left side of the menu click on the dropdown menu, select “Other sheets” and click on “ER”.
5. Double-click on the new entity set and the properties window will show up (or right-click and choose
“Properties”). Change the name of the entity set to “Course” and click “OK”. The entity sets name will be
changed.
6. The “Course” entity set has several attributes: “courseId” (primary key), “title”, “ECTS”, “level”,
“language”. In the shape menu select the “A” icon with an oval around it and click near the created
“Course” entity set. An oval with the name “Attribute” will appear.
7. Double-click on the attribute and in the properties window change the name to “courseId”. Since this
attribute is also a primary key, select “Key” value “Yes”. Click “OK”.
8. In the shape menu click on the “Participation” icon and connect the entity set with the attribute.
