Dbxpert case tool
This presentation is the property of its rightful owner.
Sponsored Links
1 / 31

DBXpert : CASE Tool PowerPoint PPT Presentation


  • 57 Views
  • Uploaded on
  • Presentation posted in: General

Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN L1S09BSCS0018. DBXpert : CASE Tool. Pro ject Title. DBXpert : CASE Tool. Problem Statement.

Download Presentation

DBXpert : CASE Tool

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Dbxpert case tool

Project Advisor:

PROF. ISHAQ RAZA

Group Members:

MUHAMMAD NABEEL ARIF L1S07BSCS0019

SHEIKH HASAN IMTIAZ

L1F06BSCS0024

MUHAMMAD NOUMAN

L1S09BSCS0018

DBXpert: CASE Tool


Pro ject title

Project Title

DBXpert: CASE Tool


Problem statement

Problem Statement

  • A web based database CASE Tool which supports Forward and Reverse Engineering.


Objec tives

Objectives

  • To Draw ER Diagram through drag and drop Interface.

  • To support ER Schema and Relational Schema in TXT & XML format.

  • To convert ER diagram into Relational Model.

  • To convert relational Model into ER diagram.

  • To make our CASE Tool online on Internet.


Er schema relational schema

ER schema & Relational schema

  • We will define a format for ER schema and relational schema.

  • Both schema are in txt or xml format.

  • These schema will contain all the information to draw ER diagram and relational diagram. E.g.


Forward engineering

Forward Engineering?

  • Convert ER schema (txt, xml) / ER diagram into Relational model / Relational schema (txt, xml).

  • Pictorial Diagram


Dbxpert case tool

Forward Engineering…


Dbxpert case tool

Forward Engineering in our CASE Tool


Dbxpert case tool

Forward Engineering in our CASE Tool…

ER Schema


Dbxpert case tool

Forward Engineering in our CASE Tool…


Dbxpert case tool

Forward Engineering in our CASE Tool…

ER diagram


Dbxpert case tool

Forward Engineering in our CASE Tool…


Forward engineering in our case tool

Forward Engineering in our CASE Tool…

Relational Model


Dbxpert case tool

Forward Engineering in our CASE Tool


Dbxpert case tool

Forward Engineering in our CASE Tool…

Relational Schema


Reverse engineering

Reverse Engineering?

  • Convert Relational model/Relational Schema(txt,xml) into ER diagram/ER schema(txt,xml).

  • Pictorial View


Reverse engineering1

Reverse Engineering…


Reverse engineering in our case tool

Reverse Engineering in our CASE Tool


Basic flow

Basic Flow

  • Basic flow in Forward Engineering

    • User will write ER schema in TXT or XML format.

    • CASE Tool will accept this ER schema as input.

    • It will generate ER diagram from this input file.

    • And Relational model will be generated from ER diagram.

    • Finally Relational Schema will be produced from this Relational model in txt or xml format.

  • Alternatively :

    • User will draw ER diagram through drag and drop facility.

    • And Relational model will be generated from ER diagram.

    • Finally Relational Schema will be produced from this Relational model in txt or xml format.


Basic flow1

Basic Flow…

  • Basic Flow in Reverse Engineering

    • User will provide Relational schema in TXT or XML format.

    • CASE Tool will accept this Relational schema as input.

    • It will generate Relational diagram from this input file.

    • And ER Diagram will be generated from Relational diagram.

    • Finally ER Schema will be produced from this relational model.


Er diagram notations

ER Diagram Notations

  • There are different notations to represent ER diagram

    • Bachman Notation


Er diagram notations1

ER Diagram Notations…

  • Erwin Notation: Crow Foots


Er diagram notations2

ER Diagram Notations…

  • Chen Notation

  • We will follow this notation is our CASE Tool.


  • Detailed example of chen notation

    Detailed Example of Chen notation


    Future work

    Future Work

    • Implement all ER-Notation mentioned above.

    • Generate Script from relational Schema for following databases:

      • MySQL

      • Oracle

      • MS Access


    Some currently available case tools

    Some Currently Available CASE tools


    What is new in our case tool

    What is new in our CASE Tool ?

    • Conversion of ER Schema(txt,xml) into ER diagram & vice versa.

    • Conversion of Relational Schema(txt,xml) into Relational Model & vice versa.

    • Web based Case Tool.

    • Use of Chen Notation which is easily understandable for the beginners.


    Tools to be used

    Tools to be Used

    • Asp.NET(For web related )

    • VB Script(Web Related)

    • VC++(For building controls)

    • Adobe Photoshop & Macromedia Flash

      (Interface Design)


    References

    References

    • Foundation of Database System by Elmasrie Navathen 4th Edition

    • The Case for Reverse Engineering by Michael R. Blaha

    • Deriving entity relationship and relational model diagrams, by Database Processing : Fundamentals, Design, and Implementation.

    • Database reverse engineering tools,2008 by Natash Ali Mian & TauqeerHussain. Dept. of Computer. Sci.,University of Central Punjab.

    • (Uj-Case-Tool) for Database Reverse Engineering by Fawaz A. Masoud,Heba_tallahKhattab, Mahmoud Al-Karazoon.

    • Reverse data engineering of E-R-designed relational schemas by Springsteel, F.;   Kou, C.; Dept. of Computer. Sci., Missouri Univ., Columbia, MO.

    • An Automatic Approach to Generate XML Schemas from Relational Models by Jumaa, H.  Fayn, J.  Rubel, P.INSA-Lyon, Univ. de Lyon, Bron, France

    • Schema Conversion Methods between XML and Relational Models by Dongwon Lee, Penn State University Murali Mani and Wesley W. Chu, University of California, Los Angeles


  • Login