Download Petshop Management System and more Study notes Javascript programming in PDF only on Docsity!
CHAPTER 1
INTRODUCTION
1.1 INTRODUCTION TO SQL
Structure Query Language (SQL) is a programming language used for storing and
managing data^ in^ Relational^ Database^ Management^ System^ (RDBMS).^ SQL^ was^ the^ first
commercial language introduced for E.F Codd's Relational model. Today almost all RDBMS (MySQL, Oracle, Infomix, Sybase, MS Access) uses SQL as the standard database language.
SQL is^ used^ to^ perform all^ type^ of^ data^ operations^ in^ RDBMS.^ Most^ of^ the^ actions^ you^ need
to pertorm on a database are done with sQL statements. SQL defines following data
languages to^ manipulate^ data^ of^ RDBMS:
1.DDL: Data Definition Language
All DDL commands are auto-committed. That means it saves all the changes permanently in
the database.
Eg: create-To^ create^ new^ table^ or database, alter-^ For alteration, truncate^ - Delete^ data^ from
table, drop- To drop a table
2.DML: Data Manipulation Language
DML commands are not auto-committed. It means changes are not permanent to database, they can be rolled back. Eg: insert To insert a new row, update - To update existing row, delete - To delete a row, merge merging two rows or two tables 3.TCL: Transaction Control Language
These commands are to keep a check on other commands and their affect on the database.
These commands can annul changes made by other commands by rolling back to original state. It can also make changes permanent. Eg: commit to permanently save, rollback - to undo change, save point to save temporarily 4.DCL: Data Control Language Data control language provides command to grant and take back authority.
Eg: grant- grant permission of right, revoke take back permission
5.DQL: Data Query Language DQL is used to operate on queries. Eg: Select retrieve records from one or more table
1.2 INTRODUCTION^ TO^ FRONT^ END^ SOFTWARE
The front end software used is PHP. PHP is an acronym for "PHP: Hypertext Preprocessor". PHP is a server scripting language, and a powerful tool for making dynamic
and interactive^ Web^ pages. It^ is^ a^ widely used,^ open source^ scripting^ language.^ It^ is^ free^ to
download and use.PHP files^ can^ contain^ text,^ HTML,^ CSs,^ JavaScript,^ and^ PHP^ code.^ PHP
code are^ executed^ on^ the^ server,^ and^ the^ result^ is^ returned^ to^ the^ browser^ as^ plain^ HTML.PHP
files have extension "php".
PHP code may be embedded into HTML or HTML5 makeup, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server software combines the results of the interpreted and executed PHP code, which may be any
type of^ data,^ including^ images,^ with^ the^ generated^ web^ page.^ PHP^ code^ may^ also^ be^ executed
with a command-line interface (CLI) and can be used to implement standalone graphical
applications.
13 PROJECT REPORT OUTLINE
CHAPTER 1: INTRODUCTION
The brief introduction about the backend software SQL, front end software HTML and the
project report outline details are specified
CHAPTER 2: REQUIREMENT SPECIFICATION
The basic software requirements and hardware requirements to do this project are mentioned. CHAPTER 3: OBJECTIVE OF PROJECT
The basic software requirements and hardware requirements to do this project are mentioned.
CHAPTER 4: IMPLEMENTATION
The implementation parts for developing the project are explained step wise briefly.
CHAPTER 2 REQUIREMENT SPECIFICATION
2.1 SOFTWARE REQUIREMENTS
Operating System: 64bit operating system, x64-based processor
Database MYSQL
Tools (^) :PHP, (^) Xampp (^) Server 3.2.
2.2 HARDWARE REQUIREMENTS
Processor Intel@ Celeron@ CPU N3060 @1.60GHz RAM 4.00^ GB Hard Disk I TB
Compact Disk :CD-ROM,CD-R, CD-RW
Input device Keyboard, mouse
Output device (^) :Monitorscreen
CHAPTER 3
OBJECTIVE OF THE PROJECT
The objectives of the project is to provide web based interface to a petshop owner to manages his petshop activities.
To provide an option for storing and managing the basic information about pets and pet products in the shop.
To provide an option for storing and managing the sales details of the shop. (^) 5/
To provide an option for storing and managing the basic information about the customer
To track the information about sold pets and products to a customer.
4.1 ER DIAGRAM
helght Det categ0ry noise
weight breed cOst type
animais ma es
r PP_name pP_ype COst
s_address 5010pers
petproducts CUStomer (^) N phone nciuoes
(cs name) belongs_to
cs_thame
= (^) sales_detals (^) OIOprooucts S_minit csname (^) 0ate quantty total
Fig.no 4.1: ER DIAGRAM OF PETSHOP MANAGEMENT SYSTEM
