Tags: %TAGME{ tpaction="" web="Main" tag="" }% view all tags

Discussion Questions

Databases

  1. How often does a need for “junction table” arise in practice?

  2. How important is business logic integrity compared to other integrity rules?

  3. What’s the scaling of algorithm complexity as we increase efficiency approaching 5NF?

  4. How much do SQL servers cost to manage?

  5. Are there any instances when you want data redundancy?

  6. How are entities depicted in a database table?

  7. What are some of the benefits and drawbacks of other database systems out there (SQL or not), like MongoDB, Oracle SQL, or PostgreSQL

  8. What are some of the benefits and drawbacks of using your database engine (i.e. InnoDB) to deal with hashing sensitive data versus "outsourcing" it to some other program?

  9. How many normal form levels are required to have the database be efficient?

  10. What does it mean that “for every value in the parent table, there could be zero, one, or more rows in the child table, and every value in the child table, there is one and only one row in the parent table” (does it mean the primary key)?

  11. What are some of the examples that a primary key contains multiple columns?

  12. Can you explain what a primary key is and how it is used to speed up the system?

  13. What are the normalization rules for relational database design and how do you know which one to use?

  14. What are the advantages and disadvantages of using Entity/Relationship Diagrams versus UML Database Diagrams?

  15. Is refactoring always done even on small projects where redundant data stored is negligible?

  16. How common are Third and higher normal form? Is it a standard to always shoot for?

  17. I think I understand 3.5NF-5NF, but can we run through them in class to clarify exactly what they are?

  18. How can you tell what level of normalization you should implement and when the drawbacks of normalization are too much?

  19. Despite the difference in functions, can we say that database normalization and multidimensional data are similar structurally?

  20. What would be a real-world situation in which database denormalization is recommended or required?

  21. What are some more examples of relationships that are optional (vs. mandatory) and why is it important to know that they are optional?

  22. At what stage does database design take place during the software engineering process?

Topic revision: r1 - 2020-02-06 - JimSkon
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback