TU Delft
Year
print this page print this page     
NEDERLANDSENGLISH
Organization
2016/2017 Electrical Engineering, Mathematics and Computer Science Bachelor Computer Science and Engineering
TI1506
Web and Database Technology
ECTS: 5
Responsible Instructor
Name E-mail
A. Bozzon    A.Bozzon@tudelft.nl
Dr. C. Hauff    C.Hauff@tudelft.nl
Contact Hours / Week x/x/x/x
0/4/0/0 hc; 0/4/0/0 pr
Education Period
2
Start Education
2
Exam Period
2
3
Course Language
English
Expected prior knowledge
Knowledge of basic algebra. Proficiency in at least one programming language.
Course Contents
Web & Database Technologies is a first year course that provides an introduction to Web and Database technology and programming.

Topics related to Web technology and programming include:
= Introduction to the Web (low-level technical details);
= Introduction to Web development and app design;
= Front-end development: HTML5, CSS3, JavaScript;
= Back-end development: JavaScript;
= Mechanisms for authentication, security and sessions.

Topics related to Web technology and programming include:
= Introduction to Databases;
= Overview of Database Languages and Architectures;
= The basic relational model;
= SQL: Data Definition, Constraints, Updates, Queries, Views;
= Conceptual Data Modelling Using the Entity-Relationship Model;
= Mapping a Conceptual Design into a Logical Design.
Study Goals
Upon completion of this course, participants will have gained knowledge of Web and Database system concepts and the ability to:

1. Explain the basic architecture of the Internet and the Web;
2. Analyze the requirements for a Web application given a description of an application idea;
3. Create a Web application with HTML and CSS based on a given static design;
4. Create an interactive Web application with client-side JavaScript;
5. Recognize security issues in a given Web application;
6. Develop server-side code for authorization, cookies, sessions and database access;
7. Compare the weaknesses and strengths of different data management techniques, describing their most suited applications trough meaningful examples;
8. Enumerate and define the main elements of the Relational Model;
9. Describe and design SQL queries for the creation, altering, and manipulation of tables, indexes, and views;
10. Develop and refine conceptual data models, using appropriate design notation;
11. Derive a logical design from a conceptual design, taking into account the requirements of both the adopted database technology, and the designed application;
12. Develop logical database schema, with principled design that enforce data integrity;
13. Prototype and deploy database applications using open-source database systems (e.g.,MySQL).
Education Method
Lectures, tutorials, and practical work (Lab).
Literature and Study Materials
In addition to the official course’s books, students will be provided with:

= The slides presented in class, cross-referenced to the content of the books;
= Additional study materials, selected to provide insights on the topics covered during the lesson.
= Short Screencasts (10-15 minutes each), recorded by the lecturer, and describing topics related to the ones covered during the lesson.
Practical Guide
Additional information about: the organisation and rules of the course; schedule; labs; and exams; will be available upon enrolment in the course's syllabus.
Books
Learning Web App Development. Author: Semmy Purewal. O’REILLY, 2014. ISBN-13: 978-1449370190

Available online via the TUD network at http://proquest.safaribooksonline.com/book/ web-design-and-development/9781449371388


Fundamentals of Database Systems, 6/E. Authors: Ramez Elmasri, Shamkant Navathe. Pearson, 2011. ISBN-13: 9780136086208

URL: http://www.pearsonhighered.com/educator/product/Fundamentals-of-Database-Systems-6E/9780136086208.page

IMPORTANT NOTE: starting from September 2016, a new edition (7th) of the "Fundamentals of Database Systems" is also available. While there are differences between the two editions, both the 6th and the 7th editions are suitable for usage in the course.
Assessment
Both exams are in written form, with multiple choice questions.
Permitted Materials during Tests
No books or other materials are allowed during exams.
Judgement
Midterm Exam 40%
Final exam 40%
Lab assignments 20%
Weekly Quizzes - Bonus on the final grade

Both exams are in written form, with multiple choice questions. During the resit sessions, students are allowed:
= to resit the midterm and the final exam independently; or
= to resit both the midterm and the final exam at the same time.

Lab assignments and weekly quizzes are not mandatory, bot contribute to the final grade according to the percentages reported above. Lab assignments and weekly quizzes have no resit opportunities.
Co-instructor
Name E-mail
Dr. C. Hauff    C.Hauff@tudelft.nl