CIS 764 Database Systems EngineeringSlide 2Slide 3Slide 4Slide 5Slide 6Slide 7Slide 8Slide 9Slide 10Slide 11Slide 12Slide 13Slide 14Slide 15Slide 16Slide 17Slide 18Slide 19Slide 20Slide 21Slide 22Fall 2008http://www.cis.ksu.edu1CIS 764 Database Systems Engineering L5: Reverse Engineering: Assignment and Exercise – Part 1Fall 2008http://www.cis.ksu.edu2CIS 764 Database Systems Engineering as of 2:15 Tuesday 09/09 10 of 22 people have submitted homework log page. review of CG for next Thursday. do not revise you submitted diagram comments about UML class diagram: classes are rectangles .. no circles / ovals in UML landscape layout, compress as needed show relationship … many just show an arrow ! distinguish kinds of arrows ! (some tools don’t show arrows, but show direction on the relation name) ◄►-- composition (the relation is composition) <>-- aggregation are kinds of relationsFall 2008http://www.cis.ksu.edu3CIS 764 Database Systems Engineering Clarification (for off-campus): ksu-ID … KSU e-services , e.g. WebMail ; must be activated. cis-ID … same name, but for CIS computing e.g. “home.html” in CIS directory apply via “self-serve” web page: CIS >> Resources >> ComputerSystems >> CIS Account >> Self-Help remote connection: “cisunix.cis.ksu.edu” or others (linux.cis.ksu.edu, unix.cis.ksu.edu, cislinux.cis.ksu.edu, camaro.cis.ksu.edu , 129.130.10.111)Fall 2008http://www.cis.ksu.edu4CIS 764 Database Systems Engineering Clarification (for off-campus): CIS-Oracle-ID … same as CIS name (usually) if you did not get an account, contact DBA ( the Systems Manager Seth, [email protected] ) Default password was announced in class (and sent by email of off-campus folks). Change the password now <<<<<<<<<<<<<<<<<<<<<<<<<<< Web access via: “isqlplus” … web interface for sql commands to Oracle: http://oracle.cis.ksu.edu/isqlplus (some versions of Mozilla may not connect; IE seems to work) leave the “connect” field blank See http://support.cis.ksu.edu/FrequentlyAskedQuestions …-> “how to Connect to Oracle”Fall 2008http://www.cis.ksu.edu5CIS 764 Database Systems Engineering Oracle: JDeveloper … contains tools for sqlplus (the firewall seems to block off-campus access!; VPN seems to work … or you may set up a local instance of Oracle) First step: make & test a DB connection. Check the Oracle tutorial: “Installing the Sample Schemas and Establishing a Database Connection” http://www.oracle.com/technology/obe/obe1013jdev/ common/OBEConnection.htm Note: we will not use the Oracle HR sample schemas.Fall 2008http://www.cis.ksu.edu6CIS 764 Database Systems Engineering Data Base for several assignments: A sample enterprise application (from Morisseau-LeRoy book) deals with people, departments, items, purchase orders (PO’s), etc. Download: http://people.cis.ksu.edu/~hankley/d764/book/introduction.zip which contains: loadPO.sql …. some sample data OracleAQS … not used now poexamples.sql … table definitions use case ….. Narrative textFall 2008http://www.cis.ksu.edu7CIS 764 Database Systems Engineering Reverse engineering assignment: a. Load tables in your Oracle account (fix any sql problems). Populate the tables with the sample data. Add your name as one of the people in the DB. Post an explanation of any sql problems/corrections (itemized list of points). b. Generate a table model class diagram (You can connect JDev to the database and import the class structure.) Examine the table structure. Post your assessment of any weaknesses in the table model (itemized list of points). … more … next slideFall 2008http://www.cis.ksu.edu8CIS 764 Database Systems Engineering Reverse engineering assignment: … continued c. Note that the table model is not a class model (it is lacking the operations). Based upon the use-case narrative, build and post a use-case diagram. (Generally, the diagram by itself is not an full model.) d. Build a class model (combining methods with the “table classes, adding some “session” classes). Post the class diagram. e. Define full specifications for two “key” methods. Post a text specification, including: parameters, types, mode (in / out), and assertions about input constraints / output results.Fall 2008http://www.cis.ksu.edu9CIS 764 Database Systems Engineering Why reverse engineering?Fall 2008http://www.cis.ksu.edu10CIS 764 Database Systems Engineering Practice with reverse engineering: The Northwind Traders DB Application. Standard Microsoft sample data base for Access and MS_SQLServer http://showroom.declarativa.com/northwind.gif contains the sales data for a fictitious company which imports and exports specialty foods from around the world.Fall 2008http://www.cis.ksu.edu11CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu12CIS 764 Database Systems Engineering Practice with reverse engineering: The Northwind Traders DB Application. Standard Microsoft sample data base / application for Access and MS_SQLServer http://showroom.declarativa.com/northwind.gif contains the sales data for a fictitious company which imports and exports specialty foods from around the world. Application includes: forms, queries, reports, macros, VBA Modules, etc.Fall 2008http://www.cis.ksu.edu13CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu14CIS 764 Database Systems Engineering Northwind Traders On-line: http://northwind.gatsbysoftware.com/Fall 2008http://www.cis.ksu.edu15CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu16CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu17CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu18CIS 764 Database Systems EngineeringFall 2008http://www.cis.ksu.edu19CIS 764 Database Systems Engineering So … class structure named relations aggregation, composition kinds of tables operations (use case) class model … merges operations to class structure adds “session” or collection-manager classes (for “create / find” operations )Fall 2008http://www.cis.ksu.edu20CIS 764 Database Systems Engineering … this will be an in-class work session: Off-campus: submit
View Full Document
Unlocking...