Login

u/Savings_Dark_9589

r/AskProgrammers r/reactnative r/FreeCodeCamp r/databasedevelopment r/learnprogramming
▲ 3 r/FreeCodeCamp

Is the SRS document still used in software development?

I am developing a web based LMS platform for an institute, and this is my first project for a client.

I suggested them to teach online through the LMS platform, they agreed. Now to build the software, should I prepare an SRS document properly? Or is it still just a habit of the concept taught by the uni?

reddit.com
u/Savings_Dark_9589 — 11 days ago
▲ 3 r/AskProgrammers+1 crossposts

How should I model department assignment history for faculty members in a relational database?

I have two entities, Faculty and Department, with primary keys faculty_id and department_id, respectively.

My database needs to satisfy the following requirements:

  • Every faculty member belongs to exactly one department.
  • Faculty members may change departments during their careers.
  • The university wants to preserve the history of department assignments.

To implement this, I came up with the following approach:

  1. Create a separate dept_assignment table with the following attributes:
    • assignment_id
    • faculty_id
    • department_id
    • assignment_date
  2. Add a foreign key column to the Faculty table that references the dept_assignment table to indicate the faculty member's current department assignment.

My understanding is that this introduces a ternary relationship, although I am not sure if that is correct.

Faculty --n-- belongs to --1-- Department
                  |
                  |
                  | n
          Dept_Assignment

My questions are:

  1. Does this relationship model make sense?
  2. Is the relationship cardinality correct?
  3. Is this a good approach for preserving department assignment history, or is there a better way to model it in a relational database?
u/Savings_Dark_9589 — 8 days ago
▲ 1 r/AskProgrammers

Looking for Students to Collaborate on a Database Design Practice Project

Hi app dev students,

I’m a web application development student currently learning system design. I’m about to start a database design practice project and I’m looking for other students who would like to collaborate.

This is purely a practice project to strengthen our database design and system design skills while also gaining experience working in a collaborative environment.

If you are interested, please let me know!

Thanks.

reddit.com
u/Savings_Dark_9589 — 23 days ago
▲ 2 r/reactnative+1 crossposts

Looking for Students to Collaborate on a Database Design Practice Project

Hi app dev students,

I’m a web application development student currently learning system design. I’m about to start a database design practice project and I’m looking for other students who would like to collaborate.

This is purely a practice project to strengthen our database design and system design skills while also gaining experience working in a collaborative environment.

If you are interested, please let me know!

Thanks.

reddit.com
u/Savings_Dark_9589 — 23 days ago
▲ 55 r/learnprogramming

How should I learn programming from official documentation?

I am a student who wants to learn programming through official documentation. However, official documentation often contains many concepts and features, and most of them are not needed for everyday programming tasks.

Is official documentation an inefficient way to learn programming?

If official documentation is an effective way to learn, how should I read it? How do I decide what to read in depth and what to skip?

reddit.com
u/Savings_Dark_9589 — 1 month ago