-

 Week 3 – CST– 363 Introduction to Database Systems

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 to 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 own words, what 3rd normal form is and why it is important.

 The 3rd normal form is a rule used to design tables that eliminate redundancy. Redundancy is the repetition of related values in a table. When a table is in 3rd normal form, all the non-key columns depend on the key only. In case of a composite key, non-key columns must depend on all of the columns that make up the primary key. This is important because when non-key values depend on other non-key values it causes redundancies. Redundancies in a database can cause problems because all related values must be changed when updating, which makes queries take longer. There is also a higher chance of copies becoming inconsistent which makes it difficult to tell which version is correct.

 

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

A view in SQL refers to a view table. The view table is made using a SELECT statement called the view query.

CREATE VIEW ViewName  AS

SELECT column1, column 2, …

FROM table_name

WHERE condition;

A view restructures table columns and data types without changing the underlying database design. We would use a view table when we want to omit personal data from a table or save complex queries for reference without having to write the select statement multiple times.

They are similar to a result table in that you can generate the equivalent result table with a select statement. You can save the optimal select statement as a view to ensure fast execution.

A difference of views from tables is that using INSERT, UPDATE, and DELETE statements with views is problematic.

When trying to insert, if the primary key does not appear in the view, then insert will fail. When updating, if you are using aggregate functions, aggregate values correspond to many base table values. If you create a new aggregate value in the view table, this value must be converted to many base table values and the conversion will be undefined and therefore the update will not be allowed.

When deleting, if you have a join view, you might delete a primary key row, foreign key row, or both. This will make the delete undefined and not allowed.

 


Comments

Post a Comment

Popular posts from this blog

-
Image
  Week 2- CST-300 Module 2 OLI – Module 2 This week’s module focused on collective intelligence, reading the mind in the eyes, behavior of good teams, and why team skills will help after graduation. Collective intelligence illustrated how teams that have better collaboration skills were more successful. Meaning that everyone participated and contributed to complete the task or project. Some key features of successful teams were equal participation, higher number of women, and social sensitivity. I enjoyed the reading the mind in the eyes activity. It is difficult to tell a person’s emotions by examining just their eyes and not the entire face or body language. I scored about average. I will continue to participate and share my thoughts and ideas on topics being discussed in my team. Behaviors of good teams was a research article done at google looking for the perfect team. They found that teams promote better job satisfaction, better problem solutions and faster innovation.
Read more
-
Image
  Week 1- CST-300 Module 0 & 1 Team Resume Hello and welcome to my first post. This is a screen shot of our team resume. Although we ran into issues with some members missing, we eventually joined with another group and managed to collaborate on this assignment. Our team did an excellent job with their bios and completed the assignment on time. Module 1 Lecture   The readings from module 1 taught me about CSUMB's history and vision statement. It also covered the Degree programs from the School of Computing and Design and its faculty. The lecture also included a video titled "Study Tips to Succeed as an Online Student." The video taught me that I will need to read the syllabus, plan weekly study times, connect with classmates, check canvas frequently, and ask questions to be successful in this class.   Module 1 Lab   The lab for this week explains the American Psychological Association (APA) writing style. APA is the style used by the Computer Science departmen
Read more
-
  Week 3- CST-300 Module 3   OLI – Module 3 This week’s module is titled “What do You Bring to the Team?” and it is made up of six sections. The first section was Processing Styles and Diversity Communication. It explains approaches that would help an internal processor in your team. Some examples were to think silently for a minutes before discussing for answers, ask if members need more time before responding, and use email to communicate. The second section was Work Styles. Here we learned about work styles Get it Right – Task oriented, Get it Done – Task oriented, Get Along – people oriented, and Get Appreciation – People oriented. Each style had its strengths and weaknesses and we had to figure out how to balance them or how to help others with a different style. The third section was Your Booth Team Members. Here we watched a video of each booth member. We were then tasked with ways to support each member’s work style. The fourth section was Conflict Styles. It focuse
Read more