Introduction to Information Systems
Faculteit | Science and Engineering |
Jaar | 2021/22 |
Vakcode | WBCS021-05 |
Vaknaam | Introduction to Information Systems |
Niveau(s) | propedeuse |
Voertaal | Engels |
Periode | semester II a |
ECTS | 5 |
Rooster | rooster.rug.nl |
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. , M. Riveni, PhD. | ||||||||||||||||||||
Verplichte literatuur |
|
||||||||||||||||||||
Entreevoorwaarden | Advisable: Logic | ||||||||||||||||||||
Opmerkingen | 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. - Six weeks before the course starts, the 20 students that can join are selected and added to the course. If you enroll after this date, you will be placed on the waiting list. For more info about the enrollment procedure, see https://student.portal.rug.nl/infonet/studenten/fse/programmes/bsc-cs/general/vakintekening-procedure#cap |
||||||||||||||||||||
Opgenomen in |
|