FORMATIONS |
Fiche détaillée d'un cours
 | DATABASE SYSTEMS | ||
2018-2019 | FrIESEG School of Management
(
IÉSEG
)
| ||
Code Cours : | 1819-IÉSEG-M1S1-MIS-MA-FE74UE | MANAGEMENT OF INFORMATION SYSTEMS | |
| Niveau | Année de formation | Période | Langue d'enseignement |
|---|---|---|---|
| Master | 1 | S1 | FrEnglish |
| Professeur(s) responsable(s) | K.MOHAJERI |
|---|---|
| Intervenant(s) | Kaveh Mohajeri |
- Ce cours apparaît dans les formations suivantes :
- IÉSEG > IESEG Degree - Programme Grande École > Semester 1 > 2,00 ECTS
Pré requis
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
Objectifs du cours
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
Contenu du cours
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)
Modalités d'enseignement
Organisation du cours
| Type | Nombre d'heures | Remarques | |
|---|---|---|---|
| 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. | |
| Charge de travail globale de l'étudiant | 50,00 | ||
Méthodes pédagogiques
- Coaching
- E-learning
- Interactive class
Évaluation
- 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)
| Type de Contrôle | Durée | Nombre | Pondération |
|---|---|---|---|
| Others | |||
| Written Report | 0,00 | 2 | 20,00 |
| Continuous assessment | |||
| QCM | 0,16 | 2 | 15,00 |
| Mid-term exam | 1,33 | 1 | 30,00 |
| Final Exam | |||
| Written exam | 2,00 | 1 | 35,00 |
| TOTAL | 100,00 | ||
Bibliographie
- Database Systems Design, Implementation, & Management 13th Edition - Carlos Coronel and Steven Morris (ISBN-13: 978-1337627900 / ISBN-10: 1337627909)
Ressources internet
* Informations non contractuelles et pouvant être soumises à modification
