Modulhandbuch

Communication and Media Engineering (CME)

Internet and Media Technologies

Recommended prior knowledge

Master-Studiengang CME

Teaching Methods Vorlesung/Labor
Learning objectives / competencies

The students are:

• getting an overview over and insight into the topic of interactive media
• understanding the principles and applications of database systems
• gaining practical experience with database systems in the lab

Duration 1
SWS 5.0
Effort
Classes 75 h
Self-study / group work: 135 h
Workload 210 h
ECTS 7.0
Requirements for awarding credit points

Database Systems: written exam K60 (50%)
Interactive Media: written exam (K60)
Both written exams must be passed.
Database Systems Lab must be passed.

Credits and Grades

7 CP, 2 K60, LA

Responsible Person

Prof. Dr. Dipl.-Ing. (FH) Riempp

Recommended Semester 1
Frequency jedes Jahr (WS)
Usability

Master-Studiengang CME

Lectures

Database Systems Lab

Type Labor
Nr. M+I411
SWS 1.0
Lecture Content
  • SQL: Creating Tables and Data Manipulation

  • Databases in the WWW with JSP

  • NoSQL: MongoDB

Literature
  • R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, Addison-Wesley, 2013
  • Hector Garcia-Molina, Jeff Ullman and Jennifer Widom: Database Systems, Prentice-Hall, 2008

Interactive Media

Type Vorlesung
Nr. M+I402
SWS 2.0
Lecture Content
  1. Einleitung, Grundlagen
  2. Web-Technologien: HTML, CSS, CMS
  3. Typen und Formate von statische und dynamische Medienformen
  4. Daten-Kompression für statische und dynamische Medienformen, Container und Codecs
  5. Übertragungs-Technologien, Streaming
  6. Medienintegration und Multimedia-Produktion: Der grundlegende Arbeitsablauf einer Produktion
Literature
  • Istvan Novak (2014): Unraveling HTML5, CSS3, and JavaScript
  • Julie C. Meloni (2014): HTML, CSS and JavaScript All in One, ISBN-13: 978-0672337147
  • Jennifer Niederst Robbins (2012): Learning Web Design: A Beginner's Guide to HTML, CSS, JavaScript, and Web Graphics, ISBN-13: 978-1449319274
  • Tay Vaughan (2011): Multimedia - Making it Work, ISBN: 978-0071748469
  • T. M. Savage, K.E. Vogel (2008): An Introduction to Digital Multimedia, ISBN: 978- 0763750527
  • Dr. Nigel Chapman, Jenny Chapman (2009): Digital Multimedia, ISBN: 978- 0470512166

Database Systems

Type Vorlesung
Nr. M+I401
SWS 2.0
Lecture Content
  • Introduction: Database System, Data Model, Database Applications

  • The Relational Model: Relations and Attributes, Selection, Join, Projection

  • SQL: Schema Definition, Queries, Changing the Data, Views, Consistency, ACID-Principle, SQL-Transactions,

  • Databank Design: Design Phases, Semantic Data Models, Dependencies, Normalisation, Transfering the Entity-Relationship Model into Relations

  • Database-Programming: JSP, Object-relational Mapping, JDBC, Stored-Procedures, Trigger

  • Beyond Relations: SQL3, No-SQL-Datenbanken, CAP und BASE, MongoDB, Main Memory Databases

Literature
  1. R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, 7th Edition, Addison-Wesley, 2016.
  2. M. Keith, M. Schincariol: Pro JPA 2 -  A Definitive Guide to Mastering the Java Persistence API, Apress Media, 2013.
  3. Hector Garcia-Molina, Jeff Ullman and Jennifer Widom: Database Systems, Prentice-Hall, 2009.