Database Design - Data Modeling/Analysis and Introduce to MySQL

Course Description:

This course introduces students to a design methodology they can use to create relational databases capable of storing and returning useful information in a consistent manner. Specifically, students will learn the principles of data modeling, culminating in the creation of an entity relationship diagram. Topics covered include requirements analysis, the entity-relationship modeling approach, and entities and attributes, techniques of data analysis involved in designing relational databases and how to apply them effectively in MySQL. Students will learn how to design an efficient relational database by creating relational constructs, normalizing tables, creating joins and views, optimizing the database's physical design, and avoiding common database design mistakes.

Learning Objectives:

After completing this course, students will be able to:

• Explain relational database design concepts and terminology
• Explain the difference between conceptual and physical models
• Develop a conceptual design
• Analyze user information requirements
• Describe the entity/relationship modeling approach
• Identify entitiess
• Model relationships and identify attributes
• Use primary and foreign keys
• Create relational constructs
• Normalize tables to first, second, and third normal forms
• Create databases, tables in MySQL
• Select, insert, update, delete data in MySQL database

Prerequisites:

• None.

Required Software:

• A word processing application, such as Microsoft Word.

Platform Support:

You can take this course on computers running Windows, Macintosh, or UNIX.