Briefly summarize 5 things what you have learned in the course so far.
- I've learned what relational databases are and how to use a relational database management system (MySQL)
- I've learned how to create queries using SQL
- I've learned about 1NF, 2NF, 3NF, and BCNF
- I've learned how to create an ER diagram
-I've learned how to read the "execute" statement diagram
List at least 3 questions you still have about databases.
- Is there a more clear-cut way to identify between a non-identify vs an identifying relationship? Sometimes I misjudge by believing the child table cannot exist independently without the parent but turns out it can.
- I feel that we need more practice on identifying candidate keys and determining the minimum number of appropriate composite primary keys.
- I still have questions about how database work is carried out in "industry practice." Do database engineers just sit there and produce a whole bunch of SQL tables, joins, ER diagrams, etc.? Surely there must be more to it than that.
No comments:
Post a Comment