Main Field of Study and progress level:
Computing Science: Second cycle, has only first-cycle course/s as entry requirements
Grading scale: TH teknisk betygsskala
Responsible department: Department of Computing Science
Contents
The goal of this course is to develop the foundations of modern database management systems, with major focus upon the relational model. The principal topics which are covered include foundations of the relational model, the design of relational schemata from ER- specifications, query languages including SQL, database programming using ODBC, and various aspects of system design, including storage representation, transaction processing, recovery from errors, and security and authorization. Also provided is a brief introduction to other data models, including particularly object-relational approaches.
Required Knowledge
Univ:To be admitted you must have 60 ECTS-credits in Computing Science or 2 years of completed studies, in both cases including C-programming and Unix (5DV006) and Logic for Computer Scientists (5DV007) or equivalent.
English proficiency equivalent to IELTS Academic Training minimum score 5.0 with no individual score below 4.5 (Tests taken before January 2005 not admissible or TOEFL minimum score 500 on paper based test and not below 4.0 on the TWE, Alternatively 173 on computer based test with iBT61 is also required as well as basic entrance requirements for higher studies in Swedish language proficiency if the course is taught in Swedish.
Database system concepts Silberschatz Abraham., Korth Henry F., Sudarshan S. 6th ed. : New York : McGraw-Hill : c2011. : xxvi, 1349 p. : ISBN: 978-0-07-352332-3 (alk. paper) Search the University Library catalogue
Fundamentals of database systems Elmasri Ramez, Navathe Shamkant B. 5. ed. : Boston, Mass : Pearson/Addison-Wesley : cop. 2007 : xxviii, 1123 s. : ISBN: 0-321-36957-2 Search the University Library catalogue