Transcript CIT 613 : Relational Database Development using SQL

CIT 613 :
Relational Database
Development using
SQL
Preliminary
Learning Outcomes of the Course



Ability to create simple relational
databases using SQL.
Ability to create Tables.
Ability to create Forms, Queries, Views,
Stored Procedures, Triggers, Reports
and Macros
Assessment

Assessment of this cause will involve:
 Assignment
and lab works which will weigh 10
marks
 Two tests:
Test 1 will weigh 15 marks
 Test 2 will weigh 15 marks

A total of 40 Marks will be given for Course
Work assessment.
 Final exam will carry 60 marks.

Required Readings
Thomas M. Connolly and Carolyn E. Begg
(2002), Database Systems: A Practical
Approach to Design, Implementation, and
Management, 3rd Edition, AddisonWesley, Harlow England.
 Ivan Bayross (2000), Oracle – 7: The
Complete Reference, BPB Publications,
New Delhi.
 Forrest Houlette (2001, Troubleshooting
SQL, Tata McGraw-Hill Company Limited,
New Delhi.

Recommended Readings
Raghu Ramakrishnan and Johannes
Gehrke (2000), Database Management
Systems, McGraw-Hill Higher Education,
Boston.
 Gelard V. Post (2002), Database
Management System: Designing and
Building Business Applications, Tata
McGraw-Hill Publishing Company Limited,
New Delhi.

Other

Material notices and other information
about this course will be available at my
website:
www.ifm.ac.tz/staff/bajuna/courses/