Answer Happy

Posted: **Sat May 14, 2022 3:35 pm**

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 1 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 2 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 3 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 4 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 5 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 6 (33.5 KiB) Viewed 56 times

: End Of Marketing 2 Assignment Regent Business School Ros 2021 Bachelor Of Commerce Year Academic And Assessment Calen 7 (41.65 KiB) Viewed 56 times

END OF MARKETING 2: ASSIGNMENT REGENT BUSINESS SCHOOL ROS-2021 BACHELOR OF COMMERCE YEAR - ACADEMIC AND ASSESSMENT CALENDAR DISTANCE 10.2.7 INFORMATION TECHNOLOGY :: ASSIGNMENT 2 [1001 QUESTION ONE 1201 11. Within the traditional file system, it is impossible to storing the same data in different Locations, this results in great inefficiency, use of system resources and other issues with regards to the above information elaborate on each of the challenges associated with data redundancy (10) 12. Examine how a database management system secures the integy and contency of data 110 QUESTION TWO 125 2.1. We the aid of a relevant diagram, discuss the hierarchical model of database design (15) 22. Explain the differences betwen a candidate and foreign hay (10) 1251 QUESTION THREE 3.1. Examine each of the SQL data definition commande 3.2 Elaborate on the three basic techniques to control or prevent a deadlock (10) 15 30 QUESTION FOUR 41 Examine the challenges associated with file systems 42 Determine the underlying factors for data redundancy occurring (15) (15) END OF INFORMATION TECHNOLOGY ASSIGNMENT 2 REGENT BUSINESS SCHOOL ROS- July 2021 BACHELOR OF COMMERCE YEAR) - ACADEMIC AND ASSESSMENT CALENCAR OSTANCE

10.2.7 INFORMATION TECHNOLOGY 3: ASSIGNMENT 2 QUESTION ONE [100] [20] 1.1. Within the traditional file system, it is impossible to storing the same data in different Locations, this results in great inefficiency, use of system resources and other issues. With regards to the above information elaborate on each of the challenges associated with data redundancy. (10) 1.2. Examine how a database management system secures the integrity and consistency of data. (10) QUESTION TWO (25) 2.1. With the aid of a relevant diagram, discuss the hierarchical model of database design (15) 2.2. Explain the differences between a candidate and foreign key. (10) QUESTION THREE [25] 3.1. Examine each of the SQL data definition commands (10) 3.2 Elaborate on the three basic techniques to control or prevent a deadlock. (15) [30] QUESTION FOUR Examine the challenges associated with file systems. 4.1 (15) 4.2 Determine the underlying factors for data redundancy occurring. (15)