DB Design Practice

💡Note: I'm Currenlty working on it

• DB Design Practice
  • Description
  • Projects
  • How to Use
  • License

Description

Practice designing relational databases by creating ERDs from Business Requirement Documents, mapping them to DB schemas, and implementing them in SQL Server.

↑ top

Projects

• Musician Company
• Sales office On progress
• Hospital Todo
• Airline Todo

Explore the collection of projects to practice your database design skills:

↑ top

How to Use

1. Clone this repository to your local machine:

git clone https://github.com/{your-username}/DB-Design-Practice.git

2. Navigate to the project directory of your choice, for example:

cd projects/musician_company

3. Read the project's README file for detailed instructions and requirements.

4. Follow the instructions in the project's README to:

   • Review the Business Requirement Document (BRD).
   • Create an Entity-Relationship Diagram (ERD) based on the BRD.
   • Map the ERD to a Database Schema.
   • Implement the schema in SQL Server.

5. Repeat the process for other projects to practice different scenarios.

↑ top

License

This project is licensed under the MIT License.

↑ top