Database Design and Implementation notes

JUNE / JULY 2021 INF3707 DATABASE DESIGN AND IMPLEMENTATION Date: 05 July 2021 Duration: 2 hours Total marks: 100 Examiners: First: Dr B. Chipangura Second: Dr L. Motsi External: Dr P. Nkomo This is a closed book examination. Instructions to students 1. Unisa examination policies apply. 2. Answer all questions. 3. Study the tables and data in Annexure A. 4. The marks for each question are given in brackets next to the question. 5. Please answer the questions in or...

INF3707 EXAM PACK 2022 Latest exam pack questions and answers and summarized notes for exam preparation. 100% TRUSTED workings, explanations and solutions.

1. Discuss each of the following terms: data field record file 2. What is data redundancy? 3. Discuss the disadvantages of file-based systems. 4. Explain the difference between data and information. 5. Use Figure 1.2 (below) to answer the following questions. In the table, how many records does the file contain? How many fields are there per record? What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file stru...

JUNE / JULY 2021 INF3707 DATABASE DESIGN AND IMPLEMENTATION Date: 05 July 2021 Duration: 2 hours Total marks: 100 Examiners: First: Dr B. Chipangura Second: Dr L. Motsi External: Dr P. Nkomo This is a closed book examination. Instructions to students 1. Unisa examination policies apply. 2. Answer all questions. 3. Study the tables and data in Annexure A. 4. The marks for each question are given in brackets next to the question. 5. Please answer the questions in or...

INF3707 EXAM PACK 2022 Latest exam pack questions and answers and summarized notes for exam preparation. 100% TRUSTED workings, explanations and solutions.

1. Discuss each of the following terms: data field record file 2. What is data redundancy? 3. Discuss the disadvantages of file-based systems. 4. Explain the difference between data and information. 5. Use Figure 1.2 (below) to answer the following questions. In the table, how many records does the file contain? How many fields are there per record? What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file stru...