Dbxpert case tool
Download
1 / 31

DBXpert : CASE Tool - PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' DBXpert : CASE Tool' - keola


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











Reverse engineering
Reverse Engineering?

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

  • Pictorial View




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.



  • Future work
    Future Work

    • Implement all ER-Notation mentioned above.

    • Generate Script from relational Schema for following databases:

      • MySQL

      • Oracle

      • MS Access



    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


    ad