Picture
Course Code: MGT-342

Instructor: Omair Gull

Email: omairgull@gmail.com

Textbook:

1.     Database System Design, Implementation, & Management by Rob & Coronel Fifth Edition

2.     Teach yourself  Microsoft access 2003 visually by Maran Graphics

3.     Mastering Ms Access.
 

OUT Line

Assessment:

This course is assessed by three components: class participation including Assignments and quizzes (12 marks), Exam (48 marks = 18 (mid-term) + 30 (final)).

  Topics

File Systems and Database  
  • Why Database Design is important
  • A practical Approach to Database Design
  • A File Management System
  • Structural and Data Dependence
  • Problems in File Management System
  • Database Management System
  • DBMS Functions and Types
  • Database Models
The Relational Database Model
  • Logical View of Data
  • Entities and Attributes
  • Tables and their characteristics
  • Keys
  • E-R Model
  • Developing an E-R Diagram
Normalization of Database Tables
  • The need for Normalization
  • Normal Forms
  • Normalized E-R-D
  • De-normalization
  Concurrency and Security of Database
  • Transaction
  • Concurrency
  • Resource Locking
  • Deadlock
  • Database Failure & Recovery
  • Types of Backup
  • Database Security
Introduction to MS-Access
  • Access Application Window
  • Components of MS-Access
  • Creating Tables
  • Data Types in MS-Access
  • Modifying the Tables
  • Sorting, Searching and Replacing the Records
  • Wizards

Relationships in MS-Access
  • What is a Relation
  • How to create Relation
  • Query
  • Creating Query with Wizards and Design View
  • Wild Cards
  • Expression Builder
  • Summarizing the Data
  • Different Types of Query
Forms and Reports
  • Form and is Types
  • Subform
  • Reports and label Report
  MS Access Project
  • A group project Done by the Students by Using MS-Access
The Information System
  • Why Information Systems (IS) are important
  • The Fundamental Roles of Information Systems
  • System Concepts
  • Components of an Information Systems
  • Information System Resources
  • Information System Activities
  • Classifications of Information Systems
  • The Systems Development Cycle
  Electronic Commerce
  • E-Commerce Introduction
  • The Impact of E-Commerce
  • E-Commerce Styles
  • E-Commerce Architecture
  • Security
  • Payment Processing
  • Database Design for Online Application
Electronic Banking
  • E-Banking and Internet Banking
  • History of E-Banking
  • Reasons to join E-banking
  • Types of Internet Banking
  • Online Banking services
  • Risks in E-Banking
  • ATM
  • SWIFT
chapter_1.pptx
File Size: 118 kb
File Type: pptx
Download File
chapter_2.pptx
File Size: 277 kb
File Type: pptx
Download File
chapter_3.pptx
File Size: 444 kb
File Type: pptx
Download File
chapter4.pptx
File Size: 87 kb
File Type: pptx
Download File
chapter_5 Entity RelationShip.pptx
File Size: 215 kb
File Type: pptx
Download File
normalization_of_database_tables_chapter_4.ppt
File Size: 1530 kb
File Type: ppt
Download File
complete_reference_-_ms_access_2007.pdf
File Size: 39058 kb
File Type: pdf
Download File
ms_access_2013_step_by_step.pdf
File Size: 10187 kb
File Type: pdf
Download File