6. Ideally, a field value change should be made in every place where it exists. True or False? (highlight the correct answer) (4 pts) 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) Human Resources Department ENum Name Title HireDate Skill Skill Date 02345 Johnny Jones DBA 2/14/1995 Basic Database Management 2/14/2000 08273 Marco Bienz Analyst 7/28/2006 Basic Web Design 3/8/2007 06234 Jasmine Patel Programmer 8/10/2005 Basic Web Design 8/10/2005 03373 Franklin Johnson, J. Purchasing Agent 3/15/2002 Advanced Spreadsheets 6/20/2009 13567 Almond, Robert Analyst 9/30/2012 Basic Process Modeling 9/30/2012 10282 Richardson, Amanda Clerk 4/11/2011 09382 Jessica Johnson Database Programmer 8/2/2010 Basic DB Design 82/2010 14311 Duong, L Programmer 9/1/2014 Basic Web Design 9/1/2014 Master Database Programming Basic Spreadsheets 09002 Ben Joiner Clerk 5/20/2010 Advanced Spreadsheets 5/16/2011 13383 Raymond F. Matthews Programmer 3/12/2012 Basic C# Programming 3/12/2012 09283 Chavez, Juan Clerk 7/4/2010 04093 Patricia Richards DBA 6/11/2004 Advanced Database Management 6/11/2004 13932 Lee, Megan Programmer 9/29/2013 8. Proper database design is based on the designer precisely identifying the database's expected use. 8.a: What is the emphasis in a transactional database? 15 pts) 8.b: What is the emphasis in an analytical database? Payroll Department 15 pts) Employee ID 02345 03373 04893 06234 08273 09002 Employee FName Johnny Franklin Patricia Employee LName ones Johnston Richards Patel Bienz Joiner 8.C: For which of the above is speed in query response critical? (5 pts) Jasmine Marco Ben Juan Employee HireDate Employee Title 2/4/1995 DBA 3/15/2002 Purchasing Agent 6/11/2004 DBA 8/10/2009 Sr. Programmer 7/28/2006 Analyst 5/20/2010 Clerk 7/4/2010 Clerk 8/2/2010 Database Programmer 4/11/2011 Clerk 3/12/2012 Programmer 9/30/2012 Analyst 9/29/2013 Programmer 9. 18283 Chavez 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) Jessica 09382 10282 13383 13567 13932 Amanda Raymond Robert Megan Johnson Richardson Matthews Almond Lee 10. List the advantages of a DMBS. (14 pts)