Communication and Media Engineering

Bewerbung
Fakultät EMI

Modulhandbuch

←  Zurück 

Internet and Media Technologies

Empfohlene Vorkenntnisse

Interest in database systems and media interactivity
Lehrform Vorlesung/Labor
Lernziele / Kompetenzen

The students are

• getting 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
Dauer 1
SWS 5.0
Aufwand
Lehrveranstaltung 75 h
Selbststudium / Gruppenarbeit: 135 h
Workload 210 h
ECTS 7.0
Voraussetzungen für die Vergabe von LP

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

Prof. Dr. Dipl.-Ing. (FH) Riempp
Empf. Semester 1
Haeufigkeit jedes Jahr (WS)
Verwendbarkeit

Masterstudiengang CME
Veranstaltungen

Database Systems Lab

Art Labor
Nr. M+I411
SWS 1.0
Lerninhalt

  • SQL: Creating Tables and Data Manipulation

  • Designing a Database and Accessing it from the WWW

  • NoSQL: Working with MongoDB
Literatur
  • R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, Addison-Wesley, 2016

  • Hector Garcia-Molina, Jeff Ullman and Jennifer Widom: Database Systems, Prentice-Hall, 2009

  • D. Sullivan: NoSQL for Mere Mortals, Addison Wesley, 2015

Interactive Media

Art Vorlesung
Nr. M402
SWS 2.0
Lerninhalt

1. Introduction, Basics

2. Web technology: HTML, CSS, CMS

3. Media types and formats for static and dynamic media 

4. Data compression for static and dynamic media, container and codec formats

5. Transmission technologies, streaming

6. Basic workflow of media integration and multimedia production

 
Literatur
  • 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

Art Vorlesung
Nr. M+I401
SWS 2.0
Lerninhalt
  • 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,
  • Database 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: No-SQL-Datenbases, CAP und BASE, MongoDB, Main Memory Databases, Key-Value Databases
  • Indices, Roles and Rights in SQL

 
Literatur
  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.
  4. D. Sullivan: NoSQL for Mere Mortals, Addison Wesley, 2015.

 

 
←  Zurück