CST363: Learning Journal Week 3

1.Someone described normalization rule as  "a non-key column depends on the key, the whole key, and nothing but the key, so help me Codd."  Key refers a primary or other candidate key of a table.  If the key has multiple columns, then "whole key" means  all columns together and not just some part of the key.  Explain in your words what 3rd normal form is and why it is important.

Third normal form eliminates transitive dependencies in a table. It is important because it reduced redundancy, makes it easier to maintain the database, maintains data integrity.

2.What is an SQL view.  How is it similar to a table? In what ways is it different?

A SQL view is a virtual table based on a select query.

It is similar to a table in that select statements and operations on joins can be used in it.

It is different from tables since they don't store data, don't have indexes, and may not be updatable.

Comments

Post a Comment

Popular posts from this blog

CST438 Week 6 Journal

This week i learned about Service-Oriented Architecture (SOA) and its significant impact on modern software development. I learned that SOA promotes the creation of independent services that can communicate over a network, enhancing interoperability and system flexibility. This architecture allows for better scalability, as services can be independently updated and reused across different applications. However, I also recognized the challenges associated with SOA, such as increased complexity and the need for effective data management and governance. Overall, understanding SOA has given me valuable insights into designing systems that can adapt to changing business needs while optimizing resource utilization.
Read more

CST439 Week 10 Journal

What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall.     I looked for data for Ifo Business Climate and Manufacturing PMI for Germany. What is your plan for next week?     Look for  Ifo Business Climate and Manufacturing PMI for other European countries. What challenges, if any, are you currently facing in project development? Do you need instructor assistance?     None
Read more

CST499 Week 14 Journal

What project milestones did you accomplish this week? Started working on Part 1 and 2 of Project Status Update and Project Testing. Also started working on the presentation. What is your plan for next week? Finish the above. What challenges, if any, are you currently facing in project development? Do you need instructor assistance? None.
Read more