Introduction to Software modeling and analysis

^{This repository is part of the Software modeling and analysis course for regular students of Software Engineering at Plovdiv University.}
The course is designed to provide an overview of the principles of building a database model according to the program specifications for software projects. Defining a conceptual, logical, and physical model of the data allows verification of program specifications and a better understanding of data flow and management methods from all parties in the project.

Course participants are introduced to the theory and formal processes of data modeling for various purposes.

POLL

Competencies

Upon successful completion of this course, participants will:

Knowledge:

• Understand the main types of specialized documents used in creating database models.
• Understand how conceptual, logical, and physical data models relate to functional requirements.

Skills:

• Identify the constituent elements of the model and their attributes.
• Define the relationships between the elements of the model.
• Define business rules for data integrity and content.
• Achieve data integrity through normalization.
• Design models for various practical purposes.

Course Structure

The course is structured into several key sections, each focusing on a different aspect of data modeling. The sections are designed to be followed in order.

• Course Roadmap

Getting Started

To get started with the course, clone this repository and follow the instructions in each section. If you have any questions or run into any issues, please open an issue and we'll do our best to help.

• Exercises need tools

Weeks Schedule

• First week:
  • presentations - Data Modeling - p1, Data Modeling - p2
• Second week:
  • pesentations - Conceptual Data Model - p3
• Third week:
  • presentations -Logical & Physical Data Model - p4, Logical & Physical Data Model - p5
• Fourth week:
  • presentations - Normalization & Denormalization - p6
• Fifth week:
  • presentations - Physical Data Model - p7
• Sixth week:
  • presentations - Data Warehouses - p8
• Seventh week:
  • presentations - Multidimensional Database - p9
• Eighth week:
  • presentations - Multidimensional Data Model - p10
• Ninth week:
  • presentations - Tabular Database - p11, Data Flow Diagrams - p12
• Tenth week:
  • presentations - NoSQL Database Model - p13, Business Intelligence - p14

Course assignment

• Task
• Assessment Requirements

License

This course is licensed under the MIT License. See the LICENSE file for more details.