Syllabus 2011/2012 EDAA20

Syllabus academic year 2011/2012
(Created 2011-09-01.)

PROGRAMMING AND DATABASES

EDAA20

Credits: 7,5. Grading scale: TH. Cycle: G1 (First Cycle). Main field: Technology. Language of instruction: The course will be given in Swedish. EDAA20 overlaps following cours/es: EDA011, EDA016, EDA017, EDA501, EDA616 and EDAA10. Compulsory for: L2. Course coordinator: Anna Axelsson, Anna.Axelsson@cs.lth.se, Computer Science. Assessment: Written examination in programming. The final grade of the course is based on the result of this examination. Compulsory course items: laboratory work and assignments in programming and laboratory work in databases.. Parts: 3. Home page: http://cs.lth.se/edaa20.

Aim
The students shall learn how to write small and medium-sized computer programs and attain basic knowledge of object-oriented programing and the programming language Java. They shall also attain basic knowledge of databases.

Knowledge and understanding
For a passing grade the student must

be able to explain fundamental concepts in object-oriented programming
be able to explain and give examples of use of fundamental algorithms, e.g., for searching
be able to describe and give examples of use of fundamental data structures such as arrays and matrices
be able to describe information systems with E/R models and UML notation
be able to use the query language SQL to retrieve information from a database

Skills and abilities
For a passing grade the student must

be able to develop and implement algorithms to solve simple problems
be able to implement Java classes, starting from given specifications
be able to use tools to write, test and debug programs
be able to read program code and program documentation
be able to use tools to implement a database

Judgement and approach
For a passing grade the student must

be able to go further on his own in the field of object-oriented programming

Contents
Programs as models of real systems. Objects and operations, classes and methods. Basic Java programming, fundamental algorithms. Data structures: arrays, the class ArrayList. Inheritance, polymorphism. String classes. Introduction to database systems. The basics of the relational model, the query language SQL. E/R and UML diagrams.

Literature
Holm, P: Objektorienterad programmering och Java, 3rd Ed. Studentlitteratur 2007. ISBN: 978-91-44-04830-7.

Parts

Code: 0110. Name: Programming, Compulsory Course Items.
Higher education credits: 3. Grading scale: UG. Assessment: For a passing grade, the laboratory work and assignments must be completed. Contents: Programming laboratory work and assignments .

Code: 0210. Name: Programming, Written Examination.
Higher education credits: 3. Grading scale: TH. Assessment: Written examination in programming. The final grade of the course is based on the result of the written examination.

Code: 0310. Name: Databases, Compulsory Course Items.
Higher education credits: 1,5. Grading scale: UG. Assessment: For a passing grade, the database laboratory work must be completed. Contents: Laboratory work.