Skip to content

The Entity and Relationship Modeling Exercises from @devsuperior course

License

Notifications You must be signed in to change notification settings

jocile/Modeling

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DrawIO

 

Modeling

Github top language Github language count Repository size License

About   |   Features   |   Technologies   |   Requirements   |   Starting   |   References   |   License   |   Author


🎯 About

✔️ The steps presented in this task assume that the application's persistent data design will be implemented using a Relational Database Management System (RDBMS). It is assumed that you are familiar with database concepts, including normalization and denormalization, as well as database terminology, as covered in references such as ERD Modeling;
✔️ The steps of this task also refer to the UML (Unified Modeling Language) language profile for database modeling, and contains an overview of the process for modeling and designing relational databases using UML. For additional information about the relationship between relational data models and object models, see Concept: Relational Databases and Object Orientation;
✔️ Role: Database Designer - This function guides the design of the persistent data storage structure for use by the system;
✔️ The Entity and Relationship Modeling Exercises from DevSuperior course.

✨ Features

✔️ Entity relationship diagrams;
✔️ Class diagrams;
✔️ Object diagrams;

🚀 Technologies

The following tools were used in this project:

📝 Diagrams.net;
💻 VSCode IDE;
🔧 Draw.io Integration.

✅ Requirements

To get started 🏁 Modeling can be done online in the browser or using the IDE with the extension Draw.io.

🏁 Starting

to model start by accessing https://app.diagrams.net/

🏁 Diagrams

✔️ Social network system.

In this social network, users can follow and be followed by other users. The user's profile must allow the registration of name, email, date of birth, website, gender, phone and profile picture. Users can make text posts on their own "timeline" (timeline) of the social network, and they can also attach photos to the posts. A photo is referenced by the URI of its storage location. The photos can be organized into albums, with each album having a title.

🏁 More Diagrams

✔️ Social Object Diagram

Minimum instance: 4 users, at least one user with more than one post, at least one album with more than one photo.

✔️ Events System Diagrams;
✔️ Footballs System Diagrams;
✔️ Music System Diagrams.

📚 References

📑StarUML documentation - Entity-Relationship Diagram;
📑UML - ERD modeling;
📑UML Tutorials.

📝 License

This project is under license from MIT. For more details, see the LICENSE file.

Made with ❤️ by Jocile

 

Back to top