Course Title: Database Application
Course Code:
Course Credits: 3
Teaching Hours: 48
Prerequisites: Fundamental Computer Application
Overview
This course will teach non-computer majors to translate a business problem into a conceptual database design, and further to convert that design into a database application using Microsoft Access and SQL Server.
This course combines PowerPoint presentations, small and large discussion groups, writing and reading assignments and a final project. You will learn about the architecture and modeling of relational databases, and how they are designed by using the Entity Relationship Diagram and how they are developed using MS Access. During the development phases you will also become familiar with the principles of Human Computer Interaction and how Usability, Heuristic, and Designing Interfaces lead to the completion of a successful application.
Learning Outcomes:
After completing this course, you will be able to:
l Explain the principles and characteristics of good relational database design.
l Show the importance of the concepts and terms of the data base analysis, design in some implementations.
l Apply basic database concepts and use common database terminologies
l Design databases using appropriate designing notations
l Translate a schema into a database application in Access
l Understand and apply methodologies and approaches used for developing applications
l Conduct and apply a simple user-interface design
Syllabus
l Introduction
l The Database Environment
l File processing
l Database Development Process
l The Entity-Relationship (E-R) Model
l E-R Models, Enhanced E-R Models
l E-R Models, Enhanced E-R Models
l Logical Database Design and the Relational Model
l Physical Database Design
l Introduction to SQL
l Mid-term Exam
l Data and Database Administration
l Object- Oriented Models
l Object-Oriented Models and Databases
l Client/Server and Databases
l Distributed databases
l Project presentations
l Final Exam
Teaching Method
The course will be based on the following teaching and learning activities:
• Lectures covering the theoretical part using Power Point presentations.
• Review questions at the beginning of the lecture and at the end of the lecture.
• Case studies
• Lab sessions
Assessment
Students will be evaluated in this course using a combination of assessment methods, including:
• Written exams: 70%
• Lab Exams: 20%
• Assignments 10%.
Teaching Resources:
Main Textbook
• Fundamentals of Database Systems, 5th. Ed., Ramez Elmasri, and Shamkant B. Navathe.,Addison – Wesley.
• (Optional) Mannino, Michael. Database Design, Application Development and Administration 3rd Edition (2005) or 2nd Edition (2003), Irwin/McGraw Hill