ICT501

Who is the database administrator? List THREE managerial and technical skills required for a DBA. (5 marks)

Give TWO (2) advantages of data modeling. (4 marks)

Explain strong entity and weak entity in Entity Relationship Diagram(ERD). (4 marks)

Explain the disjointness and completeness constraints for generalization hierarchy.

Differentiate between the following pairs of terms: One-Sided Outer Join versus Full Outer Join. Intersection Operators versus Difference Operators. (1 mark each, total = 4 marks)

What are DBMS languages? Explain and give example in your answers. (4 marks)

Outline the importance of the data model to the database designer. (2 marks)

Explain the difference between structured data and unstructured data. (4 marks)

Give ONE (1) effect of a poor database design. (2 marks)