1 / 29

PREAMBLE OF Database Management Systems(ECS 402)

PREAMBLE OF Database Management Systems(ECS 402). FACULTY’S INTRODUCTION. 1. NAME OF THE INSTRUCTOR :- Vandana Bharti , Garima jaiswal 2. CABIN LOCATION 3. TELEPHONE NO. 4. EMAIL-ID : vandana_bharti54@yahoo.co.in,garima121@gmail.com

nuri
Download Presentation

PREAMBLE OF Database Management Systems(ECS 402)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. PREAMBLE OFDatabase Management Systems(ECS 402)

  2. FACULTY’S INTRODUCTION 1. NAME OF THE INSTRUCTOR :- Vandana Bharti , Garima jaiswal 2. CABIN LOCATION 3. TELEPHONE NO. 4. EMAIL-ID :vandana_bharti54@yahoo.co.in,garima121@gmail.com 5. MEETING HOURS:faculty should provide 1hr. On all week days preferably between extended lunch break.

  3. INDEX: - FACULTY’S INTRODUCTION PREAMBLE STRUCTURE HOLISTIC FIX KEY CONCEPT KEY RESEARCH AREA KEY APPLICATION INDUSTRIAL APPLICATION RESEARCH HOW WE STUDY KEY JOBS PROJECTS ONE CAN DO TRENDS

  4. PREMBLE STRUCTURE

  5. PREREQUISITES • (10th standard) • Basic Concepts of DBMS. • Data. • Database. • Management System. • Information. • Set Theory Operations. • Union • Intersection HOLISTIC FIX OF “DATABASE MANAGEMENT SYSTEM”

  6. HOLISTIC FIX OF “DATABASE MANAGEMENT” DATA STRUCTURE ( 3rd Semester)

  7. Database Management System includes 3 parts:- Basic Concepts of DBMS. Relational Calculas. Oracle

  8. ADVANCE COURSE 4th Semester HOLISTIC FIX OF “DATABASE MANAGEMENT SYSTEM” CORE DATABASE DRIVEN JOBS… Normalization Transaction Distributed DBMS

  9. HOLLISTIC FIX OF “DATABASE MANAGEMENT SYSTEM” ( Database Designer) ( Users Using Database) (Defining Database) • DBA • End User • DDA SCOPE IN OTHER FIELDS…

  10. KEY CONCEPT OF DBMS FINANCING DECISION

  11. KEY CONCEPT OF DBMS File sharing system http://comen.maxsea.fr/MaxSea/Communities/Common/Images/Htm

  12. KEY CONCEPT OF DBMS Set theory operation http://cnx.org/content/m28248/latest/relAlgebra-1.png

  13. Key concepts of DBMS

  14. KEY CONCEPT OF DBMS SQL

  15. KEY CONCEPT OF DBMS oracle

  16. KEY CONCEPT OF DBMS Oracle database

  17. KEY CONCEPT OF DATABASE MANAGEMENT SYSTEM NATURAL JOIN http://www.cs.umd.edu/class/spring2002/cmsc434-0101/MUIseum/applications/rldb.files/join.gif

  18. KEY CONCEPT OF DATABASE MANAGEMENT SYSTEM Binary union

  19. KEY RESEARCH AREA OF “DATABASE MANAGEMENT”

  20. Research areas… • Datamining • Datawarehousing • Distributed & Parallel DBMS • Multimedia Database System • Query Optimization

  21. INDUSTRIAL APPLICATIONS • RESEARCH KEY APPLICATIONS OF DBMS http://www.sas.com/industry/fsi/

  22. INDUSTRIAL APPLICATION 1. Annual Report • EDGAR ANNUAL REPORT • DIODES ANNUAL REPORT • MERGENT ANNUAL REPORT • IRIN ANNUAL REPORT • NAIC ANNUAL REPORT http://www.google.co.in/search?q=DATABASE+%28ANNUAL+REPORT%29&hl=en&sa=G&ei=xbyUS-65AYfslQfL-YD-AQ&oi=images_breadcrumbs_list&ct=images-breadcrumbs-list&cd=1

  23. INDUSTRIAL APPLICATION • SYSTEM SOFTWARE DESIGNING • APPLICATION & UTILITY SOFTWARE DESIGNING • SOFTWARE FOR DEFENCE & SPACE RESEARCH

  24. DATABASE RELATED RESEARCH… • Self tuning database system • Monitoring Databases • Yahoo Research : -Querying complex structured database

  25. KEY JOBS AND COMPANIESOF DBMS

  26. CORE DATABASE DRIVEN JOBS… • Commercial Banking • Corporate Finance • Insurance • Investment Banking • Investment Banking • Software Developer • Defence Sector(GIS & MULTIMEDIA SYSTEM)

  27. HOW WE STUDY......? REFRENCE MATERIAL LECTURE PLAN JOURNALS

  28. PROJECTS ONE CAN DO IN… • HOTEL MANAGEMENT SYSTEM • BANKING SYSTEM • LIBRARY MANAGEMENT SYSTEM • ONLINE EDUCATION • FINANCIAL SECTOR • AIRLINE RESERVATION SYSTEM • RAILWAYS RESERVATION SYSTEM

  29. THANK YOU

More Related