60 likes | 188 Views
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.
E N D
CIT 613 : Relational Database Development usingSQL 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, Addison-Wesley, 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/