YEAR II SEMESTER II

Course Title:              ADLIS 2201: Computer Databases (3 Units: 45 hrs)

Course Level:            Year II Semester II

Course Description: 

This course introduces the student to contemporary electronic database theory and practice

Course Objectives:               

Students should be able to:

- Understand what a databases is

- Understand the different database concepts

- develop a Microsoft Access relational database 

 Course content: 

Theory                    

- Introduction to databases

- Database concepts 

- Introduction to relational databases

Practice: Building and Testing     

- Base tables 

- Relationships

- Queries and filters 

- Reports 

- Forms  

- Data types and Field properties  

- Securing a database 

 Mode of delivery:      Lectures and Presentations

 Reading List:            

 Sukula, S. (2008). Demystifying Databases: A Hands-on Guide for Database Management. New Delhi: Ess Ess Publications.

 Frye, C. (2010). Microsoft Excel 2010 Plain & Simple. Pearson Education.

 Singh Y. K. (2006). Database Management System. New Delhi: Shree publishers & Distributors