Fundamentals of RDBMS
The American College of Greece
Area of Study
Taught In English
ITC 1070 LE Information technology Fundamentals –orCS
1070 Introduction to Information Systems
ITC 2188 Introduction to Programming
Course Level Recommendations
ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.
Recommended U.S. Semester Credits3
Recommended U.S. Quarter Units4
Hours & Credits
Relational Database Management Systems concepts. Data modelling, systems development and data administration in a database environment. The relational model, normalization, transaction management, concurrency, control, database security and the Structured Query Language (SQL).
Database systems are powerful, complex structures for managing data and they provide a rich environment for study. A database management system is the most important part in application development. The course focuses on the functions of an RDBMS and its role as the foundation of modern information systems by exposing students to the fundamentals of planning and collecting data, designing, implementing, maintaining and managing databases.
As a result of taking this course, the student should be able to:
1. Demonstrate understanding of the fundamental concepts of the relational database model and utilize database management systems to organize, store and retrieve data.
2. Make use of SQL (Structured Query Language) for database definition and manipulation
3. Make use of a conventional programming language to implement database connections.
4. Apply conceptual database modelling methods such as entity-relationship to model business requirements.
5. Make use of a step-by-step approach from conceptual and logical to a physical model to design databases.
6. Identify functional dependencies and apply normal forms to evaluate the quality of a relational database design.
METHOD OF TEACHING AND LEARNING:
In congruence with the teaching and learning strategy of the college, the following tools are used:
• Lectures and class discussions. Laboratory sessions involving training on database tools and practice on the design and development of databases.
• Office hours held by the instructor to provide further assistance to students.
• Use of the Blackboard Learning platform to further support communication, by posting lecture notes, assignment instruction, timely announcements, and online submission of assignments.