OUR ACADEMIC DEPARTEMENTS

Lesson details

DATABASE SYSTEMS
2018-2019	EnIESEG School of Management ( IÉSEG )
Class code :	1819-IÉSEG-M1S1-MIS-MA-FE74UE	MANAGEMENT OF INFORMATION SYSTEMS

Level	Year	Period	Language of instruction
Master	1	S1	EnEnglish

Academic responsibility	K.MOHAJERI
Lecturer(s)	Kaveh Mohajeri

IÉSEG > IESEG Degree - Programme Grande École > Semester 1 > 2,00 ECTS

Prerequisites

1. Digital literacy, i.e., a general understanding of basic computer concepts (software and hardware), the Internet, new information technologies and digital security
2. General understanding of how IT is being used in organizational settings
3. Familiarity with mathematical logic and set theory, including applications in Boolean algebras

Learning outcomes

At the end of the course the student should be able to :
1. recognize how data must be stored in a relational database
2. describe the relational set operators
3. practice data modeling and ER diagramming
4. explain the concepts of dependency diagram, partial dependency, transitive dependency and relational schema
5. apply normalization methods to any type of data structure in order to achieve 1st, 2nd, 3rd and Boyce-Codd normal forms
6. practice SQL (both data definition and data manipulation) programming
7. discuss the basics of the analysis and design of database systems
8. identify issues related to organizational administration and security of database systems

Course description

Chapter 1 (Database Systems)
Chapter 2 (Data Models)
Chapter 3 (The Relational Database Model)
Chapter 4 (Entity Relationship (ER) Modeling)
Chapter 6 (Normalization of Database Tables)
Chapter 7 (Introduction to Structured Query Language (SQL))
Chapter 8 (Advanced SQL)
Chapter 9 (Database Design)
Chapter 16 (Database Administration and Security)

Class type

Class structure

Type of course	Numbers of hours	Comments
Independent study
Estimated personal workload	15,00	Three assignments (two will be graded)
Face to face
Interactive class	16,00
Independent work
Reference manual 's readings	19,00	Reading the textbook's covered chapters and lecture slides.
Total student workload	50,00

Teaching methods

Coaching
E-learning
Interactive class

Assessment

- Two multiple-choice quizzes on Chapters 1, 2, 3 and 4 (covers learning outcomes 1, 2 and 3)
- Two homework assignments on Chapters 6, 7 and 8 (covers learning outcomes 4, 5 and 6)
- One mid-term exam which will be conducted during the class day 5 (out of 6) on Chapters 1-4 and 6 (covers learning outcomes 1 to 5)
- One written final exam on Chapters 7, 8, 9 and 16 (covers learning outcomes 6, 7 and 8)