FC21324 Database Management Systems
Course Outline
|
Course |
: FC21324– Data Base Management Systems |
|
Programme |
: BSc in Surveying Sciences – Foundation Course |
|
Department |
: RSGIS |
|
Faculty |
: Faculty of Geomatics |
|
Contact Hours |
: 150 |
|
Year |
: II |
|
Semester |
: I |
|
Lecturer/Instructor |
: |
|
Room No. |
: |
|
Telephone No. |
: |
|
|
: |
Synopsis
This course provides a complete overview of Database Management. Database Design and Database Concepts will be explained.
Contents
- Introduction to Database
- Database Environment
- Relational Model
- Relational Algebra
- Draw ER modelling
- Normalization
- SQL practice
Including relevant practical tasks
Learning Outcomes
|
No. |
Course Learning Outcome |
Programme Outcome |
Assessment Methods |
|
1. |
Identify database concept, data models. |
P01 |
Final Exam |
|
2. |
Identify relational databases and develop a relational database |
P02 |
Final Exam |
|
3. |
Working with SQL language to insert data, edit data and delete data from the database. |
P03 |
Final Exam |
Student Learning Time (SLT)
|
Teaching and Learning Activities |
Student Learning Time (hours) |
|
Direct Learning |
|
|
Lectures and Student Centered Learning (SCL) |
30 |
|
Lab Practical |
40 |
|
Independent Learning |
|
|
For Student Centred Learning activities |
20 |
|
Lab Practical activities |
15 |
|
Self-Learning (Library & Internet) |
18 |
|
Revision |
20 |
|
Assessment |
|
|
Continuous Assessment |
05 |
|
Final Examination(Written) |
02 |
|
TOTAL (SLT) |
150 |
Teaching Methodology
|
Lectures, and individual and group assignments |
References
- Database System Concepts, Abraham Silberschatz, Henry Korth, and S. Sudarshan
- Database Management Systems, Raghu Ramakrishna
- Principles of Database Systems,J. D. Ullman
- Foundations of Databases,SergeAbiteboul, Richard Hull and Victor Vianu
Grading
|
Assignment s and practical projects |
50% |
|
Final Examination (Written) |
50% |
|
Total |
100% |