CIS 764 Database Systems Engineering

1. CIS 764 Database Systems Engineering L3: Status Reverse Engineering Assignment JDeveloper Assignment http://www.cis.ksu.edu

2. CIS 764 Database Systems Engineering Discussion items: * bios were edited for style and consistency * please include first & last names in emails * KSU email was almost dead on Tuesday (it will recover) * only 14 people have submitted URL for homework page: that link should not be visible on your CIS page; the homework page should contain links to your homework items; it should not have an obvious name. * to find J2EE Overview slides: google ( “J2EE Overview Ian Cole “ ) * post the J2EE conceptual graph : with a link from your homework web with image as jpg or gif format http://www.cis.ksu.edu

3. CIS 764 Database Systems Engineering We reviewed two conceptual graphs in class today: one follows, the other will be posted later, comments follow (see if you can spot the issues before you view the comments). http://www.cis.ksu.edu

4. CIS 764 Database Systems Engineering http://www.cis.ksu.edu

5. CIS 764 Database Systems Engineering Issues: * missing relationship names on several arrows (as J2EE defines server_architecture) Note: Tomcat, OC4J, JBoss are instances of J2EE_Server , but that information would not be in the J2EE definition. * no items shown belonging to Web_Container (spelling ) * Session, Entity, Message beans are kinds of EJB (show extends arrow) * Server does not directly “connect to” JDBC; EJB_container uses JDBC * missing several key components: JAAS, JNDI, others * there are several kinds of clients (use extends arrow); html is not a kind of client (it is a format) http://www.cis.ksu.edu

6. CIS 764 Database Systems Engineering About your review of usability of two web sites: After approval of your selection of two sites, post your review of usability as an html page (and post the link on your homework page): Include: your name links to two sites screen snapshots of features discussed specific description of issues, as “too complex” … too vague but “because it has 183 buttons” explains why. You do not have to review the whole site, just discuss one bad feature and one good feature. http://www.cis.ksu.edu

7. CIS 764 Database Systems Engineering If you did not get an Oracle account (either late enrollment of no CIS account) contact system staff directly. Default password was announced in class (and sent by email of off-campus folks). Change the password now. You can use “isqlplus” … web interface for sql commands to Oracle currently older versions of Mozilla do not connect IE seems to work leave the “connect” field blank JDeveloper … contains tools for sqlplus currently the old version does not connect currently, the firewall seems to block off-campus access! See http://support.cis.ksu.edu/FrequentlyAskedQuestions …-> “how to Connect to Oracle” -> connecting from web http://www.cis.ksu.edu

8. CIS 764 Database Systems Engineering We now start two threads of homework: (1) reverse engineering of a model from tables + (2) Use of JDeveloper for forward development of enterprise apps http://www.cis.ksu.edu

9. CIS 764 Database Systems Engineering Reverse Engineering: A sample enterprise application (from Morisseau-LeRoy book). It 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 …. Sample data OracleAQS … not used now poexamples.sql … table definitions use case ….. Narrative text http://www.cis.ksu.edu

10. CIS 764 Database Systems Engineering assignment steps & items to post: a. Load tables in your Oracle account (fix the sql problems) b. Report explanation of sql problems c. Generate a table model diagram d. Reverse engineer an object model (UML), using the use cases e. Write specification assertions for the P.O. cases These steps and their relation to the design process will be discusses on Thursday. For now, start steps a and b. http://www.cis.ksu.edu

11. CIS 764 Database Systems Engineering Beginning JDeveloper: Find the Oracle JDeveloper Tutorials page at the Oracle site. Browse the “Introduction to JDeveloper IDE. Note that only trivial classes with text I/o to the console are presented! Some snapshots of a GUI application are shown at http://people.cis.ksu.edu/~hankley/d764/JDev/SimpleApp/ The snapshots illustrate concepts: workspace, application, project, package; project browser, code editor, attribute viewers, GUI builders, selection of GUI components, component attributes and events. All of these carry over in some way for web applications and middleware (for which there are Oracle step-by-step tutorials). http://www.cis.ksu.edu

12. CIS 764 Database Systems Engineering Assignment: Build a simple GUI (Swing) application that will accept some input and generate some result based upon the input: eg. Enter Age: 40 -> [compute_button] -> result = “you are middle aged”. Post screen snapshots to show use of the IDE and builder and execution of the program. http://www.cis.ksu.edu

13. CIS 764 Database Systems Engineering end. Do you need sound annotations for these slides? If yes, please send email. http://www.cis.ksu.edu