5. Following are two sets of data used by ZapCo, in two different departments. Answer the questions that follow referencing these two sets of data. 6. Ideally, a field value change should be made in every place where it exists. True or False? (highlight the correct answer) (4 pts) Skill1 Date 2/14/2000 3/8/2007 B/10/2005 6/20/2009 9/30/2012 7. Data modeling, which is the focus of this course, is something that doesn't come naturally to people and must be learned (thus the reason you are in this course!). Instead, people naturally have alan view of their data environment. (5 pts) Clerk Human Resources Department ENum Name Title HireDate Skill 02345 Johnny Jones DBA 2/14/1995 Basic Database Management 08273 Marco Bion Analyst 7/28/2006 Basic Web Design 06234 Jasmine Patel Programmer B/10/2005 Basic Web Design 03373 Franklin Johnson, Jr. Purchasing Agent 3/15/2002 Advanced Spreadsheets 13567 Almond, Robert Analyst 9/30/2012 Basic Process Modeling 10282 Richardson, Amanda 4/11/2011 03382 Jessica Johnson Database Programmer 8/2/2010 Basic DB Design 1431Dug, Lm Programmer 9/1/2014 Basic Web Design Master Database Programming Basic Spreadsheets 09002 Ben Joiner Clerk 5/20/2010 Advanced Spreadsheets 13383 Raymond F. Matthews Programmer 3/12/2012 Basic C# Programming 09283 Chavez, Juan Clerk 7/4/2010 04893 Patricia Richards DBA 6/11/2004 Advanced Database Management 13932 Lee, Megan Programmer 9/29/2013 8/2/2010 9/1/2014 8. Proper database design is based on the designer precisely identifying the database's expected use. 5/16/2011 3/12/2012 8.a: What is the emphasis in a transactional database? 6/11/2004 (5 pts) 8.6: What is the emphasis in an analytical database? 15 pts) Payroll Department Employee_0 Employee_Name Employee_UName Employee_MireDate Employee_Title 02345 Johnny Wones 2/14/1995 DBA 03373 Franklin Johor 3/15/2002 Purchasing Agent 04893 Patricia Richards B/11/2004 DBA 05234 Jasmine Patel BIDAUA BI PHAI 08273 Marco Benz 7/28/2000 Analyst 03002 Ben Joiner 5/20/2010 Clerk 0823 Juan Chave 7/4/2010 Clerk 09302 Jessica Johnson 0/2/2010 Database Programmer 10282 Amanda 4/11/2011 Clerk 13000 Raymond Matthews 3/12/2012 Programmer 13567 Robert Almond 9/30/2012 Analyst 112 Megan Les 9/29/2013 Programmer 5. a: What is the term used to describe this same data stored in multiple places? (5 pts) 5.b: Jasmine Patel has been promoted to Sr. Programmer, as is shown in Payroll but not H/R. What develops when all required changes are not made? (5 pts) Richardson 8.C: For which of the above is speed in query response critical? (5 pts) 9. exists when it is possible to make changes in the data storage characteristics without affecting an application program's ability to access data. (5 pts) 5.c. Lee Duong has left the company, as is reflected in Payroll but not in H/R. This is an example of what kind of anomaly? (5 pts) 10. List the advantages of a DMBS. (14 pts) 5.d: Upon entering Franklin Johnson's last name, the data entry clerk spelled it Johnston. This type of issue, such as transposing numbers or making typographical mistakes is an example of a (5 pts)
