Databases

Course ID
DB101
CLASS (LEVEL)
Senior Five, Six
INSTRUCTOR (S)
TO BE COMFIRMED
HOURS PER WEEK
3 Hours

data

This course examines data structures, file!organizations, concepts and principles of database management systems (DBMS); as well as, data analysis, database design, data modeling, database management and database implementation. More specifically, it introduces hierarchical, network and relational data models; entity?relationship modeling; the Structured Query Language (SQL); data normalization; and database design. Using Microsoft’s SQL Server and Microsoft Office Access DBMSs as implementation vehicles, this course provides hands?on experience in database design and implementation through assignments and lab exercises. Advanced database concepts such as  transaction management and concurrency control, distributed databases, multi-tier client/server architectures and  Web?based database applications are also introduced.

Outcomes

Like any introductory class, we will be exploring a wide array of topics, rather than a detailed drill-down. It is the  primary objective of this class to expose you to the various ideas of databases and database design, with a major  focus on the relational model and SQL (Structured Query Language). With that in mind, the outcomes of this course are to:

  • Describe fundamental data and database concepts
  • Compare and contrast the relational database model with other database models
  • Explain and use database development lifecyce
  • Design databases using  data modelling  and data normalization  techniques
  • create databases using popular  database management  system products
  • solve problems by constructing database queries  using the structured  Query language (SQL)
  • Develop insights into future  data management  tool  and technique trends
  • Recommend and justify  strategies for  for managing data security , privacy , audit/control, fraud detection, backup and recovery
  • Critique the effectiveness of Database  Management Systems in computer information  systems
  • become proficient at modeling databases at conceptual and logical levels of design,
  • be able to develop database schemas with principled design that enforce data integrity,
  • become knowledgeable in the creation, altering, and manipulation of tables, indexes, and views using relational algebra and SQL,
  • become proficient at casting queries in SQL,
  • and at writing database application programs with an understanding of transaction management, concurrency control, and crash recovery.

Instructional Methods

Course sessions may include lecture, demonstration, supervised hands-on projects, and independent problem solving sessions, online web-based learning and student presentations. Delivery of course materials, assignments, and tests will vary from course to course based on in-class and on-line course types. Students should expect that work outside of class is a requirement to complete the assignments.

Required Software

  • Operating Systems
  • Microsoft Office Access
  • Microsoft SQL database
  • SQL Management tool
  • SQL Manager
  • Oracle database
  • Minibase
  • MYSQL database
  • XAMPP/ WAMP
  • Microsoft Visual Studio

Required Textbooks

  • Database Management Systems by Raghu Ramakrishnan & Johannes Gehrke
  • SQL for Smarties: Advanced SQL Programming by Joe Celko,
  • Database Systems:The Complete Book by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom
  • Database Systems: Design, Implementation and management by Carlos Coronel, Steven Morris
  • Database Systems: A Practical Approach to Design, Implementation and management by Thomas Connolly, Carolyn Begg
  • Modern Database Management by Jeffrey A. Hoffer, Ramesh Venkataraman,  Heikki Topi

Syllabus:

To read the full syllabus for this subject, please download the document in the download section below.

Course Downloads:

© 2015 Sofarider Inc. All rights reserved. WordPress theme by Dameer DJ.