Database Design and Implementation


Course Description:

This course is an introduction to the design and use of database systems - systems that manage very large amounts of data. The well established approach to organizing and querying (asking questions about) data: the "relational model," which uses a two-dimensional table (relation) as its primary structure. The relational model underlies the major commercial database systems. We cover relational design using the entity-relationship model, followed by an overview of the relational model, how to convert E/R models to relations, and how one uses a relational database system to create a database. SQL (Structured Query Language), the standard query language for relational databases, will be learned and experienced.

Objectives/outcomes:

  • Develop an appreciation of the role of data, files and databases in information systems.

  • Understand the database development activities during the System Development Life Cycle (SDLC)

  • Be familiar with data modelling concepts (ER and Class diagrams) used in database development.

  • Be able to create databases and pose complex SQL queries of relational databases.

  • Develop an appreciation for several DBMS's (ACCESS, ORACLE and SQL Server)

  • Be familiar with a broad range of data management issues including data integrity and security.


Course Contents:

  • Fundamental concepts, system organization

  • Database Development Process:

  • Logical Database Modeling & Design

  • The Relational Model

  • Normalization (1st -3rd Normal Form) and BCNF

  • Relational Database Constraints

  • Relational Algebra (Select-Project-Join)

  • SQL Query Language

Text Book:

  • Modern Database Management by Jeffrey A. Hoffer, Mary B. Prescott, and Fred R. McFadden.

  • Database System Concepts. By Abraham Silberschatz, Henry F. Korth S. Sudarshan .

  • Fundamentals of Database Systems. By R. Elmasri and S. Navathe.

  • An Introduction to Database Systems, By C. J. Date.

Related Links
Course Name Location Link
     

For more information click here