LIS 558
Database Management Systems and Programming
Home page

Basic course documentation

• General information
• Assignments

Additional information

• Bibliography
• Topics week by week
• DBMS functions
• Query By Example
• Reports in Microsoft Access
• Database design problems
• Relational database design
• Entity-relationship model
  • Entity-relationship model advantages and disadvantages
  • Entity-relationship model definitions
  • Database design using the entity-relationship model
  • Entity-relationship diagrams
  • Rules for relation generation from ER type diagrams
  • Example of relation generation from ER type diagrams
• Referential integrity
• Normalization in the relational model
• Programming and Visual Basic
• Visual Basic annoyances
• User interface design guidelines
• Sample applications. Download .zip file.
  • 558pvb00.mdb (form with samples of Visual Basic code)
  • Thesau00.mdb (thesaurus application)
    • Thesaurus application
  • Marcde00.mdb (reading a MARC record)
    • MARC records
    • Reading a MARC record in Microsoft Access
  • 558rst00.mdb (simple Recordset and file operations)
• Active Server Pages
• File structures
• Information retrieval operations
• DBTextWorks
• File name extensions