39 39 project on database database management

8/7/2019 39 39 Project on Database Database Management

http://slidepdf.com/reader/full/39-39-project-on-database-database-management 1/27

Project on DataBase

&Data Base

ManagementPresented By-Mayur Malik



WHAT

IS D ATA

B A

SE ? A database is a collection of relatedand ordered information , organisedin such a way that information can beaccessed quickly and easily . Hence ,an organised logical group of related

files would constitute a database.



THIRD GENER

ATIONL A NGU A GES (3GL)

Third generation languages are alsoknown as high level languages.

They are procedures oriented (viz.,a business application orientedlanguage FOR TR A N. They aredetached from machine design and

therefore the nomenclature highlevel language.



EX A

MPLES OF

TH

IRDGENER ATION L A NGU A GE(3 GL)

Common Business Oriented

Languages (COBOL)

Beginners all purpose SymbolicInstruction Code (B A SIC)

FormulaTranslation (FOR TR A N)



A D ATA

B A

SESYSTEMThe Database system represents achange in the way end user dataare stored, accessed ,andmanaged.

The databases DMBS providesnumerous advantages over file

system management by making itpossible to eliminate most of thefile systems disadvantages such asdata inconsistency data,anomolies,data dependency .



D ATA B A SE FILE

SYSTEM

DBMS

D ATA B A SE

EMPLOYEESCUSTOMERS

S A LESINVENTORY

A CCOUNTS

PERSONNEL DEPT.

S A LESDEPT.

A CCOUNTING

DEP.



A FILE

SYSTEM

S A LES DEPT.

EMPLOYEES

CUSTOMER

S A LESINVENTO

RY

A CCOUNTS

PERSONNEL DEPT.

A CCOUNTINGDEPT.



Five major parts of

database system

� Hardware�

Software� People� Procedures�

Data



HA RD WA RE

The hardware is the physical component of computersystem.The hardware comprises of Computer- a microcomputer , a mini computer , or amainframecomputerComputer peripherals- physical devices that controlcomputerInput and output as keyboard, mice , modems ,printer, any electronic devices that are used to connect two or morecomputers to produce computer network.Software

Software means the collection of programs ; Instruction that make thehardware work.



People would include all users of thedatabase system . They can be classifiedinto five types on the basis of their jobfunctions.�System administrators�Database designers�Database designers�System analysts and programmers�End users

PEOPLE

PROCEDUR

ESProcedures are instructions and rules thatgovern the design and use of the databasesystem.



D ATA

The word data covers the collection of facts stored in the database. Because data

are the raw material from whichinformation is generated, the determinationof which data are to be entered into thedatabase and how such data are to beorganised is a vital part of the database

designers job.



D ATA B A SE M A N A GEMENT SYSTEM (DBMS)

A Database Management System (DBMS)is a computer based system to manage a

database or a collection of database or files.

.



Microsoft A ccess 2007 is aDBMS package fromMicrosoft . The latest version of access 2007

provides a plethora of newfeatures designed to help ususe the internet and develop W orld W ide W eb

applications



PRIM A RY STEP IN CRE ATINGD ATA B A SE



Creating database with blank database



Create a table in design view



OVERVIE W



UERY DESIGN



MICRO BUILDER



FORMS

Forms are screens that can display information and they allow

the user to edit data in a specificlayout.Forms can comprise of asingle screen or they might only occupy part of a screen or can spanseveral screen.



CRE ATING A FORM IN DESIGN VIE W



CRE ATE A FORM BY USING THE BL A NK

FORM TOOL



CONTROLS

Controls are objects that display data,perform actions that enhances the userinterface, such as labels and images.

A ccess supports three types of control:Bound control A control whose sourceof data is a field in a table or query is abound control.Unbound control A control that doesnt

have source of data (a field or expression)is an unbound control.Calculated control A control whosesource of data is an expression ratherthan a field is a calculated control



REPOR T

Report helps in generatingprofessional results. The user can

distribute and publish the reporton Net. A report is an access objectused to pull off data from a table ,query or a form in a printed

format.



Thanking You

39 39 project on database database management

Documents