ERD for Courses Company

System Analysis & ERD Design

I conducted a complete System Analysis for a video courses company to understand the business requirements, workflows, and data structure.

Based on the analysis, I designed a professional Entity Relationship Diagram (ERD) that represents all entities, relationships, and constraints within the system to ensure a well-structured database architecture.

Database Mapping (ERD to Relational Model)

After designing the ERD, I performed the mapping process to convert the conceptual data model into a relational database schema.

This included defining tables, primary keys, foreign keys, and relationships to ensure data integrity and efficient database design.

SQL Server Database Implementation

Finally, I implemented the database design using Microsoft SQL Server.

All tables, relationships, constraints, and data types were created based on the mapped schema to build a fully functional and optimized database system.