dbxpert case tool
Download
Skip this Video
Download Presentation
DBXpert : CASE Tool

Loading in 2 Seconds...

play fullscreen
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