1 / 10

Database courseware (NSF)

Kennesaw State University Database Courseware Project (http://coffee.kennesaw.edu/) Mario A.M. Guimaraes (mguimara@kennesaw.edu) and Martha Myers (mmyers@kennesaw.edu ). Database courseware (NSF). design and develop animations in support of key database concepts. Current topics

glynn
Download Presentation

Database courseware (NSF)

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Kennesaw State UniversityDatabase Courseware Project(http://coffee.kennesaw.edu/)Mario A.M. Guimaraes(mguimara@kennesaw.edu) and Martha Myers(mmyers@kennesaw.edu)

  2. Database courseware (NSF) • design and develop animations in support of key database concepts. Current topics SQL (finished prototypes) Database Design (few prototypes) Concurrency (design, 1st prototype)

  3. SQL Queries – prototypes available • Visual Basic (downloadable) Visualization • Java (java applets) Construction & Visualization

  4. SQL Queries - motivation • Low student scores in tests involving queries • Construction: allows student to break SQL queries into parts and quickly access the results. • Visualization: Associating code that students already know with code they are unfamiliar.

  5. Database Design – prototype available (Flash) • Convert E-R Diagrams to tables 1) Scenario 2) E-R Diagram is drawn 3) User is presented with several options 4) For each selected option, feedback, animating data redundancy and null value is shown.

  6. E-R Diagram -> Table – motivation • Instructor may show several conversion options in a few minutes. • Students memorize or are given the solution (test results) • Students have trouble detecting redundancy

  7. Concurrency • Lost Update (being implemented) • Deadlock (being implemented)

  8. The Lost Update:A Concurrency Problem(table view)

  9. Deadlock

  10. Next Prototypes • Database Design: Class Diagrams Object x Relational Normalization SQL Queries Indexes: B-Trees, Hashing, Bitmap

More Related