Skip to content
View menu
Miriam College
Log in
Computers

BSA 127: Database Theory and Applications


Class
Access code required
Enroll

About

The course introduces the student to database management systems. It focuses on fundamentals / entity relationships and data flow diagrams, access database fundamentals, random on-line access, shared data (use of common data structures) and system flexibility, efficient and reliable storage, and the relational data base management system (RDBMS).

Course Objectives:                

At the end of the course, the student is expected to:

Cognitive:

A.     Learn the Fundamental Concepts, Principles and Techniques related to Database Theory and Applications

B.     Preparation of Entity Relationship Diagrams

C.     Acquire knowledge as User / Developer / Auditor of Database Theory and Applications

Affective:

A.     Develop, further, the values of companies, integrity, creativity and objectivity Database Theory and Applications

B.     Appreciate, further, the sensitive nature of the qualitative aspects of Database Theory and Applications

Pre-requisite:    Computer Software and Applications

References: 

  1. Joseph Wilkinson, Michael Cerullo, Vasant Raval and Bernard Wong-On-Wing, Accounting Information System, 4th Edition,
  2. John Wiley & Sons, Inc. New York, 2000b.    Atezeni, Ceri, Paraboschi & Torlone.  Database Systems – Concepts, Languages and Architectures. McGraw Hill.
  3. Elmasri & Navathe. Fundamentals of Database Systems (3rd Edition) Addison Wesley.
  4. Ramakrshan, R. and J. Gehrke. (2006). Database Management Systems (3rd Edition). McGraw-Hill.

EXPECTATIONS FROM STUDENT:
The student’s responsibility is to come to each class prepared.  She is also expected to take all examinations on the dates schedule.  She should read the assigned problems prior to class.  She is expected to attend each class and participate actively in the discussions.

ACADEMIC DISHONESTY
All BSA students are expected to be academically honest.  Cheating, lying and other forms of immoral and unethical behavior will not be tolerated.  Any student found guilty of cheating in examinations or plagiarism in submitted course requirements will (at a minimum) receive an F or failure in the course.  Plagiarism and cheating refer to the use of unauthorized books, notes or otherwise securing help in a test; copying tests, assignments, reports or term papers; representing the work of another person as one’s own; collaborating without authority, wit another student during an examination or in preparing academic work; signing another student’s name on an attendance sheet; or otherwise practicing scholastic dishonesty.

GRADING:                                                                                                                                   
    Assignments, Seat Works, Recitations, Class Participation and Attendance: 1st Half= 5%, 2nd half=5%          
    Quizzes, Tests, and Case Studies: 1st Half= 20%, 2nd half=25%                                                                                        
    Preliminary Examination: 1st Half= 20%                                                                                                         
    Final Examination: 2nd Half= 25%                                                                             

  Total    100%