Introduction to Information Systems

Uitgebreide vaknaam	Introduction to Information Systems
Leerdoelen	At the end of the course, the student is able to: 1) gain understanding and knowledge of the process of data modelling, design, mapping of database schema to relations, realization, and use of relational databases. 2) define database schema and formulating queries using the SQL language. 3) use relational database systems and SQL queries in practice.
Omschrijving	Part 1: Introduction to Databases and DB Architecture - Databases and Database Users - Database Systems: Concepts and Architecture Part 2: Conceptual Data Modeling and Database Design using ER - Data Modeling Using the Entity Relationship (ER) Model - The Enhanced Entity Relationship (EER) Model Part 3: The Relational Data Model, Relational Algebra and SQL - The Relational Data Model and Relational Database Constraints - The Relational Algebra - Relational Database Design by ER- and EER-to-Relational Mapping - Basic SQL - SQL: Complex Queries, Views, and Schema Modification, Security
Uren per week
Onderwijsvorm	Hoorcollege (LC), Practisch werk (PRC)
Toetsvorm	Practisch werk (PR), Schriftelijk tentamen (WE) (The final grade will be based on the written exam and the assignments with weights: 70% WE, 30%Assignments. Passing grade for written exam is 50% (before rounding). Passing grade for assignments: none. Passing grade for the course is 5.5 or higher. Rounding will be done on the final grade as follows: 5.5 will be rounded to 6.0. Any grade above 6.0 will be rounded to the closest 0.5 point.)
Vaksoort	bachelor
Coördinator	prof. dr. D. Karastoyanova
Docent(en)	prof. dr. D. Karastoyanova , F.F.M. Mohsen, PhD.
Verplichte literatuur	Titel Auteur ISBN Prijs Fundamentals of Database Systems, 7th Edition, 2006 (available as PDF on Nestor for students enrolled in the course) Ramez Elmasri, Shamkant B. Navathe 978-1-292-09761-9
Entreevoorwaarden	Advisable: Logic
Opmerkingen	In the academic year 2020-2021, all CS bachelor courses have limited enrollment: - CS students can always enter each course, regardless of whether the course is mandatory for them or not. - A maximum of only 20 places per course is available for non-CS students. These places are filled on a first-come-first-served basis, with priority given to students with a strong CS-related background (e.g., CS exchange students, AI students, etc.). These students need to meet the course prerequisite requirements as mentioned on Ocasys. For more info about the enrollment procedure, see https://student.portal.rug.nl/infonet/studenten/fse/programmes/bsc-cs/general/vakintekening-procedure#cap This course was registered last year with course code INBIIS-08
Opgenomen in	Opleiding Jaar Periode Type BSc Artificial Intelligence 2 semester II a keuze BSc Artificial Intelligence 3 semester II a keuze BSc Computing Science 1 semester II a verplicht BSc Courses for Exchange Students: AI - Computing Science - Mathematics - semester II a