Skip to content

abdelwahab-ahmed-shandy/Database-Design-with-ERD-EERD-Relational-Schemas-SQL-Implementation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 

Repository files navigation

Database Design with ERD, EERD, Relational Schemas & SQL Implementation

License Issues Stars Language Commits


🎯 Project Contents

  • ERDs: Visual representations of system entities and relationships.
  • EERDs: Enhanced version of ERDs, including additional concepts like inheritance, aggregation, and more.
  • Relational Schemas: Structured presentation of tables and their relationships within a relational database.
  • SQL Files: Ready-to-run SQL scripts for implementing the database schema in a database system.

🚀 How to Use

  1. Clone the repository:
    git clone https://github.com/Abdelwahab-Shandy/ER-Diagrams-And-Relational-Schemas.git
  2. Browse the folders to select the desired project.
  3. Open the ERD or schema files using the appropriate tool.

🛠️ Tools & Technologies

  • Diagram Tools: Draw.io, Lucidchart , ERDPlus
  • Database Systems: MySQL, PostgreSQL , SQLServer
  • Programming Language: SQL
  • Other Utilities: ERD/EERD visualization tools

📚 Useful Resources


✨ Features

  • Detailed ERD & EERD for comprehensive database design.
  • Relational schemas derived from diagrams with normalization techniques.
  • SQL scripts for:
    • Database creation
    • Table relationships
    • Constraints and indexes
    • Sample data population
  • Clear documentation and logical flow from design to implementation.

📫 Connect with Me

LinkedIn Medium GitHub


If you get bored , Make up a programming problem ").

About

A collection of projects featuring Enhanced Entity-Relationship Diagrams (EERDs), Relational Schemas, and SQL code .

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages