DATABASE SYSTEMS (4/2 Credits)

Learning Outcomes:

On completion this course, students will be able to: Describe database systems, terminology, environment, and new concept of database; Apply database language and SQL Programming language; Design database using Object Oriented data model; Examine database processing.

Topics:

1. Object Oriented Database Management Systems
2. Object Oriented Conceptual Modelling
3. Cloud Computing
4. Database Environment
5. Class Diagram
6. Material Review
7. Introduction To Database
8. Database Environment
9. Database Architectures and the Web
10. The Relational Model
11. SQL – Data Definition and Data Manipulation (1)
12. SQL – Data Definition and Data Manipulation (2)
13. Database System Development Lifecycle
14. Database Analysis
15. Advanced SQL
16. Transaction Management
17. Entity Relationship (ER) Modelling for Game Development
18. Enhanced Entity-Relationship Modelling
19. SQL – Data Definition (1)
20. SQL – Data Definition (2)
21. SQL – Data Manipulation (1)
22. SQL – Data Manipulation (2)
23. SQL – Data Manipulation (3)
24. SQL – Data Manipulation (4)
25. SQL – Data Manipulation (5)
26. Advanced SQL
27. Entity Relationship (ER) Modelling