Tag Info

Hot answers tagged


Which of the two options is the best? The relational design is clearly superior to the hierarchical design used in the NoSQL example. A database schema designed using relational principles does not favor one access path over another. Each table represents a real world entity type and through the use of relational algebra queries of arbitrary ...


Maybe, you should use staff, attendance_staff, and school. staff table ========== id, fullname, birthday ... school Table ============== id, name, founded, number_of_staff ... attendance_staff table ======================= id, staff_id, school_id, attended_date, ...

Only top voted, non community-wiki answers of a minimum length are eligible