lOMoARcPSD|47939224

Database microproject

Database Management System (Dr. Babasaheb Ambedkar Marathwada University)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university

Downloaded by Parth Attarde ([email protected])
 lOMoARcPSD|47939224

GOVERNMENT POLYTECHNIC AMBAD

DEPARTMENT OF INFORMATION TECHNOLOGY
( DATABASE MANAGEMENT SYSTEM )

A MICRO-PROJECT REPORT ON

“ACME DVD RENTAL SHOP ”

FOR THE AWARD OF

DIPLOMA IN INFORMATION TECHNOLOGY

(INFORMATION TECHNOLOGY-IF4I)
2020-21
UNDER THE GUIDANCE OF
Prof. J.B. Nemane

ROLL NO. NAME Enrollment SIGN

No.

55 Bochkari Shruti Balaji 2011620274

56 Sormare Krushana 2011620275

57 Sultane Ajinkya jagannath 2011620276

58 Tagad Pallavi Narayan 2011620277

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

59 Tayade Ashwin Rajiv 2011620278

60 Tope Gajanan Dattatray 2011620279

CERTIFICATE

GOVERNMENT POLYTECHNIC AMBAD

DEPARTMENT OF INFORMATION TECHNOLOGY
( DATABASE MANAGEMENT SYSTEM )

This is to certify that the Micro-project entitled “ ACME DVD RENTAL SHOP ”

being submitted herewith for the award of DIPLOMA IN ENGINEERING &

TECHNOLOGY in INFORMATION TECHNOLOGY of MAHARASHTRA STATE

BOARD & TECHNICAL EDUCATION (MSBTE) is the result of Micro-project work

completed under my supervision and guidance by

Mr. / Miss--------------------------------------------------------------

Place: Ambad (PROF. J. B. NEMANE)

Date: Micro-project Guide

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

DECLARATION

We, the undersigned, hereby declare that the project entitled “ ACME DVD
RENTAL SHOP ” is written and submitted by us to Government Polytechnic Ambad
during Year 2019-20, Third Semester for partial fulfillment of the ‘Micro Project’
requirement of ‘ DATABASE MANAGEMENT SYSTEM ’ subject under Maharashtra
State Board of Technical Education, Mumbai curriculum, under the guidance of PROF.
J. B. NEMANE.

ROLL NO. NAME Enrollment SIGN

No.

55 Bochkari Shruti Balaji 2011620274

56 Sormare Krushana 2011620275

57 Sultane Ajinkya jagannath 2011620276

58 Tagad Pallavi Narayan 2011620277

59 Tayade Ashwin Rajiv 2011620278

60 Tope Gajanan Dattatray 2011620279

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

ACKNOWLEDGEMENT

I have great pleasure to express my immense gratitude towards a dynamic person

and my project guide Prof .J.B.Nemane. Department of information technology
Government Polytechnic, Ambad for giving me an opportunity to work on an interesting
topic over one semester. The work presented here could not have been accomplished
without his most competent and inspiring guidance, incessant encouragement, constructive
criticism and constant motivation during all phases of our group Micro-project work. I am
greatly indebted to him.
I am very much thankful to Prof: Y.Sanap , HEAD OF INFORMATION
TECHNOLOGY, all HODs of various departments and Prof. Dr. A.M. JINTURKAR,
Principal, Government Polytechnic, Ambad, for his encouragement and providing me a
motivating environment and project facilities in the Institute to carry out experiments and
complete this Micro-project work.
I would like to extend our thanks to all our professors, staff members and all our
friends who extended their co-operation to complete the project.
I am indeed indebted to my parents and other family members for their immense
help at all levels with moral, social & financial support, care and support throughout my
studies without which my work would not have seen light of the day.
With warm regards,
Yours Sincerely ,

Place: Ambad Mr. / Miss. ------------------------------------------------------

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Date:

INDEX
1.VB.NET

Introduction
Definition

2.MS ACCESS

Introduction
Procedure

3.CONNECTING TO DATABASE

Procedure

4.OUTPUT

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Screenshots

INTRODUCTION

What is VB.Net?

VB.NET stands for Visual Basic.NET, and it is a computer programming

language developed by Microsoft. It was first released in 2002 to replace
Visual Basic 6. VB.NET is an object-oriented programming language. This
means that it supports the features of object-oriented programming which
include encapsulation, polymorphism, abstraction, and inheritance.

Visual Basic .ASP NET runs on the .NET framework, which means that it has
full access to the .NET libraries. It is a very productive tool for rapid creation
of a wide range of Web, Windows, Office, and Mobile applications that have
been built on the .NET framework.

The language was designed in such a way that it is easy to understand to both
novice and advanced programmers. Since VB.NET relies on the .NET
framework, programs written in the language run with much reliability and
scalability. With VB.NET, you can create applications that are fully object-
oriented, similar to the ones created in other languages like C++, Java, or C#.
Programs written in VB.NET can also interoperate well with programs

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

written in Visual C++, Visual C#, and Visual J#. VB.NET treats everything as
an object.

It is true that VB.NET is an evolved version of Visual Basic 6, but it's not
compatible with it. If you write your code in Visual Basic 6, you cannot
compile it under VB.NET.

History of VB.NET

 VB.NET is a multi-paradigm programming language developed by

Microsoft on the .NET framework. It was launched in 2002 as a
successor to the Visual Basic language. This was the first version of
VB.NET (VB.NET 7.0) and it relied on .NET version 1.0.
 In 2003, the second version of VB.NET, VB.NET 7.1, was released.
This one relied on .NET version 1.1. This version came with a number
of improvements including support for .NET Compact Framework and
an improved reliability and performance of the .NET IDE. VB.NET
2003 was also made available in the academic edition of Visual
Studio.NET and distributed to various scholars from different countries
for free.
 In 2005, VB.NET 8.0 was released. The .NET core portion was
dropped from its name so as to distinguish it from the classical Visual
Basic language. This version was named Visual Basic 2005. This
version came with many features since Microsoft wanted this language
to be used for rapid application developers. They also wanted to make
it different from C# language. Some of the features introduced by this
version of VB.NET included partial classes, generics, nullable types,
operator overloading, and unsigned integer support. This version also
saw the introduction of the IsNot operator.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

 In 2008, VB 9.0 was introduced. This was released together with .NET
3.5. Some of the features added to this release of VB.NET included
anonymous types, true conditional operator, LINQ support, XML
literals, Lambda expressions, extension methods, and type inference.

VB.NET Features

 VB.NET comes loaded with numerous features that have made it a

popular programming language amongst programmers worldwide.
These features include the following:

 VB.NET is not case sensitive like other languages such as C++ and
Java.
 It is an object-oriented programming language. It treats everything as
an object.
 Automatic code formatting, XML designer, improved object browser
etc.
 Garbage collection is automated.
 Support for Boolean conditions for decision making.
 Simple multithreading, allowing your apps to deal with multiple tasks
simultaneously.
 Simple generics.
 A standard library.
 Events management.
 References. You should reference an external object that is to be used in
a VB.NET application.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

 Attributes, which are tags for providing additional information

regarding elements that have been defined within a program.
 Windows Forms- you can inherit your form from an already existing
form.

DEFINITION

Definition of VB.NET
Visual Basic .NET (VB.NET) is a Microsoft object-oriented programming
(OOP) language. It evolved from Visual Basic 6 (VB6) to meet an increasing
need for easy web-services and web development.

VB.Net was designed to take advantage of the .NET framework-based classes

and run-time environment. It was re-engineered by Microsoft as part of its
.NET product group.VB.NET supports abstraction, inheritance, and
polymorphism.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

MS ACCESS

Introduction
 Microsoft Access is a database management system (DBMS) from
Microsoft that combines the relational Microsoft Jet Database Engine
with a graphical user interface and software-development tools.
 It is a member of the Microsoft Office suite of applications, included in
the Professional and higher editions or sold separately.
 Microsoft Access stores data in its own format based on the Access Jet
Database Engine. It can also import or link directly to data stored in
other applications and databases.[3]
 Software developers, data architects and power users can use Microsoft
Access to develop application software.
 Like other Microsoft Office applications, Access is supported by Visual
Basic for Applications (VBA), an object-based programming language
that can reference a variety of objects including the legacy DAO (Data
Access Objects), ActiveX Data Objects, and many other ActiveX
components.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

 Visual objects used in forms and reports expose their methods and
properties in the VBA programming environment, and VBA code
modules may declare and call Windows operating system operations.

How To Create Table In MS-Access

To create a table, select the Create tab in the toolbar at the top of the screen.
Then click on the Table Design button in the Tables group.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Next, add the fields to the table. In this example, we've added the fields
Customer_ID, First_Name, Last_Name, etc.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Next, you'll want to set up a primary key for your table. To do this, highlight
the field(s) that you want to use as the primary key. Then select the Design tab
in the toolbar at the top of the screen and click on the Primary Key button
under the Tools section.

Finally, you need to save your table by clicking on the save button in the top
left of the Access window.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Enter the name of your table and click on the OK button.

Now your table should be listed in the left window. In this example, we've
created a table called Suppliers.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Connecting To Database
1. Access the menu from which you can select SQL Developer:
o On a Windows system: From the Start menu, select All
Programs.

o On a Linux system:

 On Gnome: Click Application.

 On KDE: Click K.

2. Select Oracle - ORACLE_HOME.

3. Select Application Development.

4. Select SQL Developer.

If this is the first time you have started SQL Developer on your system,
you are prompted to enter the full path to java.exe (for example,
C:\jdk1.5.0\bin\java.exe). Either type the full path after the
prompt or browse to it, and then press the key Enter.

The Oracle SQL Developer window opens.

5. In the navigation frame of the window, click Connections.

The Connections pane appears.

6. In the Connections pane, click the icon New Connection.

The New/Select Database Connection window opens.

7. In the New/Select Database Connection window, type the appropriate

values in the fields Connection Name, Username, and Password.

For security, the password characters that you type appear as asterisks.

Near the Password field is the check box Save Password. By default, it
is deselected. Oracle recommends accepting the default.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

8. In the New/Select Database Connection window, click the tab Oracle.

The Oracle pane appears.

9. In the Oracle pane:

o For Role, accept the default.

o For Connection Type, accept the default (Basic).

o In the fields Hostname and Port, type the appropriate values.

o Select the option SID.

o In the SID field, type the appropriate value.

10.In the New/Select Database Connection window, click the button Test.

The connection is tested. If the connection succeeds, the Status

indicator changes from blank to Success.

11. If the test succeeded, click the button Connect.

The New/Select Database Connection window closes. The Connections

pane shows the connection whose name you entered in the Connection
Name field in step 7.

You are in the SQL Developer environment.

To exit SQL Developer, select Exit from the File menu.

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Output Screenshots

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Downloaded by Parth Attarde ([email protected])

 lOMoARcPSD|47939224

Downloaded by Parth Attarde ([email protected])