dbx pert : case t ool project advisor: prof. ishaq raza group members: muhammad nabeel arif...
TRANSCRIPT
![Page 1: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/1.jpg)
1
DBXPERT: CASE TOOL Project Advisor:
PROF. ISHAQ RAZA Group Members:
MUHAMMAD NABEEL ARIF L1S07BSCS0019
SHEIKH HASAN IMTIAZL1F06BSCS0024
MUHAMMAD NOUMANL1S09BSCS0018
![Page 2: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/2.jpg)
2
PROJECT TITLE
DBXpert: CASE Tool
![Page 3: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/3.jpg)
3
PROBLEM STATEMENT
A web based database CASE Tool which supports Forward and Reverse Engineering.
![Page 4: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/4.jpg)
4
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.
![Page 5: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/5.jpg)
5
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.
![Page 6: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/6.jpg)
6
FORWARD ENGINEERING?
Convert ER schema (txt, xml) / ER diagram into Relational model / Relational schema (txt, xml).
Pictorial Diagram
![Page 7: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/7.jpg)
7
Forward Engineering…
![Page 8: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/8.jpg)
8
Forward Engineering in our CASE Tool
![Page 9: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/9.jpg)
9
Forward Engineering in our CASE Tool…
ER Schema
![Page 10: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/10.jpg)
10
Forward Engineering in our CASE Tool…
![Page 11: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/11.jpg)
11
Forward Engineering in our CASE Tool…ER diagram
![Page 12: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/12.jpg)
12
Forward Engineering in our CASE Tool…
![Page 13: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/13.jpg)
13
FORWARD ENGINEERING IN OUR CASE TOOL…Relational Model
![Page 14: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/14.jpg)
14
Forward Engineering in our CASE Tool
![Page 15: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/15.jpg)
15
Forward Engineering in our CASE Tool…Relational Schema
![Page 16: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/16.jpg)
16
REVERSE ENGINEERING? Convert Relational model/Relational
Schema(txt,xml) into ER diagram/ER schema(txt,xml).
Pictorial View
![Page 17: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/17.jpg)
17
REVERSE ENGINEERING…
![Page 18: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/18.jpg)
18
REVERSE ENGINEERING IN OUR CASE TOOL
![Page 19: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/19.jpg)
19
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.
![Page 20: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/20.jpg)
20
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.
![Page 21: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/21.jpg)
21
ER DIAGRAM NOTATIONSThere are different notations to represent
ER diagram Bachman Notation
![Page 22: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/22.jpg)
22
ER DIAGRAM NOTATIONS… Erwin Notation: Crow Foots
![Page 23: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/23.jpg)
23
ER DIAGRAM NOTATIONS… Chen Notation
We will follow this notation is our CASE Tool.
![Page 24: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/24.jpg)
24
DETAILED EXAMPLE OF CHEN NOTATION
![Page 25: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/25.jpg)
25
FUTURE WORK Implement all ER-Notation mentioned above.
Generate Script from relational Schema for following databases:
MySQL Oracle MS Access
![Page 26: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/26.jpg)
26
SOME CURRENTLY AVAILABLE CASE TOOLS
![Page 27: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/27.jpg)
27
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.
![Page 28: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/28.jpg)
28
TOOLS TO BE USED Asp.NET (For web related )
VB Script (Web Related)
VC++ (For building controls)
Adobe Photoshop & Macromedia Flash(Interface Design)
![Page 29: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/29.jpg)
29
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 & Tauqeer
Hussain. Dept. of Computer. Sci.,University of Central Punjab. (Uj-Case-Tool) for Database Reverse Engineering by Fawaz A.
Masoud,Heba_tallah Khattab, 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
![Page 30: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/30.jpg)
30
![Page 31: DBX PERT : CASE T OOL Project Advisor: PROF. ISHAQ RAZA Group Members: MUHAMMAD NABEEL ARIF L1S07BSCS0019 SHEIKH HASAN IMTIAZ L1F06BSCS0024 MUHAMMAD NOUMAN](https://reader035.vdocuments.us/reader035/viewer/2022062621/551c450e5503467b488b4ca6/html5/thumbnails/31.jpg)
31