Database Discussion

  1. How do you decide on which normal form is appropriate for our project?
  2. How does the crow’s foot notation show transitivity among different objects?
  3. Would a software engineer need to change their technique for database design if there is an extremely large amount of data as opposed to a very small amount?
  4. When would it be necessary to store binary data in a table for database design?
  5. In what scenario does it make sense to not conform the data set to the next normal form?
  6. Why do we need alternate keys when the primary key is always present?
  7. What are some circumstances under which normalization might make storage more difficult, if there are any?
  8.  What are data structures are used in databases? Is a linked list structure used? Arrays? Does it matter?
  9. don’t get the column indexing thing. What exactly is column indexing and how does it make selections more efficient?
  10. Are terms like “third normal form” used often in discussions about databases, or is there just an assumption that the best practice when building a database is to put in 3NF? How common is it to move between normal forms?
  11. How are some ways that crowfoot notation can be used in software engineering?
  12. Relationships between two entities can be easy to understand, but how do charts with relationships between many entities work?
  13. What are consequences of not creating UML design?
  14. What is the common mistake when creating a UML design?
  15. What can be the uses of relational databases in a classroom at Kenyon? Discuss how the user can make classroom management more efficient and effective?
  16. What are examples of data normalization?
  17. What are some examples of entry relationships?
  18. Why is it best to start with a theoretical functioning of the database before actually constructing it?
  19. Is it absolutely vital for companies that are scaling to go up to 5NF?
  20. When do programmers usually use crow’s feet notation? Is it used often and only for representing relationships in databases? Are there more complex notations available?
  21. Is database normalization something that should be done in consultation with the database generator? What are the dangers of not doing this consultation?
  22. How can the normalization of databases prevent data redundancy?
  23. Why do we need a “bridge table” in a many-to-many relationship?
  24. Why is database important in a lot of software and system Design?
  25. Is that necessary to normalize a database?
  26. In practice, what are the conditions that would cause the developer to create a child table of the original database? Please give example
  27. Why is data redundancy so important to eliminate?
Scroll to Top