Database Management Past Paper (2021/2022) - University of Ghana PDF

(All rights reserved) B. A. FIRST SEMESTER EXAMINATIONS: 202112022. DEPARTMENT OF DISTANCE EDUCATION. INFS 329: DATABASE MANAGEMENT (3 Credits) INSTRUCTIONS: ANSWER QUESTION ONE, AND ANY OTHER QUESTION. ALL QUESTIONS SHOULD BE ANSWERED IN THE ANSWER BOOKLET. TIME ALLOWED: ONE AND A HALF HOURS (11...

(All rights reserved) B. A. FIRST SEMESTER EXAMINATIONS: 202112022. DEPARTMENT OF DISTANCE EDUCATION. INFS 329: DATABASE MANAGEMENT (3 Credits) INSTRUCTIONS: ANSWER QUESTION ONE, AND ANY OTHER QUESTION. ALL QUESTIONS SHOULD BE ANSWERED IN THE ANSWER BOOKLET. TIME ALLOWED: ONE AND A HALF HOURS (111z) HOURS. COMPULSORY QUESTION 1. a. Use the following business rules to draw a well-labelled entity-relationship diagram using the Chen notation. "A company database needs to store information about employees (identified by unique SSNIT Number, with salary and phone as attributes), departments (with Department Name as its unique field. Its other fields are Number of employees and Budget Allocation), and children of employees (with name and age as attributes). Employees work in departments,' each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. A parent can register as many children as he or she has. We are not interested in information about a child once the parent leaves the company." [10 Marks] b. Distinguish between the following: i. Derived attribute and Composite attribute [2 Marks] ii. Week entity and Strong entity [2 Marks] iii. Database and Metadata [2 Marks] iv. Primary key and Foreign key [2 Marks] v. Work group database and Departmental database [2 Marks] c. When working with Microsoft Access, which data type will you assign to each of the following attributes? Also, indicate the rationale for each data type selected. i. Name [2 Marks] ii. Date of Birth [2 Marks] iii. Gender [2 Marks] iv. Nationality [2 Marks] v. Passport picture [2 Marks] Examiner: Mr. L. N. K. Commodore Page 1 0.. 2 CHOOSE ONLY ONE FROM QUESTIONS 2, 3, AND 4. 2. a. It is recOlnmended that the design and development of a database adhere to some systematic and cyclical process called the Database Development Life Cycle (DDLC). Explain how the various stages in the DDLC can guide the development of a database. [20 Marks] b. Explain prototyping as a methodology for database design and explain the categories of prototypes based on their fidelity. [10 Marks] 3. a. Discuss any four (4) benefits of a Database Management System. [10 Marks] b. Explain the hierarchical, the network and the relational database models. Comment on how an inadequacy of each model was catered for by its predecessor. [20 Marks] 4. a. The term Database Management System (DBMS) is used to refer to an organised set of components that define and regulate the collection, storage, management, and use of data within a database environment. Explain how the components of a DBMS contribute to the attainment of its goal of data collection, storage, sharing, security, and management. [10 Marksl b. File organization refers to the way records are physically arranged on a storage device. There are diverse types of file organizations, explain any four (4). Your explanation should include one (1) advantage and one (1) disadvantage of each type. [20 Marks] Examiner: Mr. L. N. K. Commodore Page 20.. 2