DAMG 6210. Data Management and Database Design (4 Hours)

Course Outline:

1. Information Systems Design from a Data Perspective

• • Design principles for engineering and business applications
  • User-centric information requirements

1. Data Modeling Approaches

• • Entity-relationship (E-R) and object-oriented data modeling
  • Design considerations for different data models

1. Fundamental Concepts of Database Management Systems (DBMS)

• • Overview of DBMS and their applications
  • Alternatives to traditional relational databases

1. SQL and Data Normalization

• • Basics of SQL for database management
  • Data normalization techniques

1. Data-Driven Application Design

• • Design principles for various types of databases
  • Application of databases in personal computer, server-based, enterprise-wide, and Internet scenarios

1. Distributed Data Applications

• • Overview of distributed data applications
  • Challenges and opportunities in distributed data management

Assignments and Assessments:

• Database design projects
• SQL coding exercises
• Midterm exam
• Final project: Designing and implementing a distributed data application

Lesson Summary

DAMG 6210 is a course that focuses on data management and database design. It covers various aspects of designing information systems from a data perspective, including design principles for engineering and business applications and user-centric information requirements. The course also explores different data modeling approaches, such as entity-relationship (E-R) and object-oriented data modeling, and design considerations for different data models.

The course introduces students to fundamental concepts of database management systems (DBMS), including an overview of DBMS and their applications. It also covers alternatives to traditional relational databases and provides an introduction to SQL and data normalization techniques.

The course also covers data-driven application design principles for various types of databases and explores the application of databases in personal computer, server-based, enterprise-wide, and Internet scenarios. It also includes an overview of distributed data applications, including the challenges and opportunities in distributed data management.

The course includes various assignments and assessments, such as database design projects, SQL coding exercises, a midterm exam, and a final project that involves designing and implementing a distributed data application.