INF2603 Oct/Nov 2022 exam paper — questions

Free sample

  1. Question 1.1 · The relational model · 2 marks

    Identify which of the following statements about constraints is NOT true.Show the full question

  2. Question 1.2 · The relational model · 2 marks

    Complete the statement: the logical view of the relational database is facilitated by the blank.Show the full question

  3. Question 1.3 · Entity relationship modelling · 2 marks

    Identify the term that is commonly used in traditional entity relationship modelling to express the maximum number of entity occurrences associated with one occurrence of the related entity.Show the full question

  4. Question 1.4 · Entity relationship modelling · 2 marks

    State the purpose of an entity cluster.Show the full question

  5. Question 1.5 · SQL · 2 marks

    Indicate whether the statement 'A query language is a procedural language' is true or false.Show the full question

  6. Question 1.6 · Database concepts and terminology · 2 marks

    Indicate whether the statement 'Business rules apply to businesses and government groups, but not to other types of organisations such as religious groups or research laboratories' is true or false.Show the full question

  7. Question 1.7 · Database concepts and terminology · 2 marks

    Complete the statement: in the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) blank.Show the full question

  8. Question 1.8 · The relational model · 2 marks

    Identify which of the following is NOT a property of a relation.Show the full question

  9. Question 1.9 · The relational model · 2 marks

    Given the table definition CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM), identify which attribute(s) make up the primary key.Show the full question

  10. Question 1.10 · The relational model · 2 marks

    Identify which statement about NULL values is NOT true.Show the full question

  11. Question 2.1 · Normalisation and dependencies · 6 marks

    Name and briefly describe the six levels on which the quality of data can be examined.Show the full question

  12. Question 2.2 · Normalisation and dependencies · 6 marks

    Examine the file structure shown in Table 2.1, which lists project and employee data with the columns PROJ_NUMB, PROJ_NAME, EMP_NUM, EMP_NAME, JOB_CODE, JOB_CHG_HOUR, PROJ_HOURS and EMP_CELLPHONE. The records are: project 101 'Mogamolo' with employee 2011 Previn B. Mochabo (job code ZCM, charge rate R1300.00/hour, 17.7 project hours, cellphone 083-691-6060); employee 2051 Tumy A. Seoka (KZN, R800.00/hour, 20.6 hours, 072-389-9935); employee 2101 Charlotte P. Mkhize (KZN, R800.00/hour, 18.7 hours, 011-670-9085); project 102 'Savana' with employee 2011 Previn B. Mochabo (ZCM, R1300.00/hour, 24.2 hours, 083-691-6060); employee 2081 Thabo F. Mtsweni (ZCM, R1300.00/hour, 21.9 hours, 072-227-3895); project 103 'Nuclear' with employee 2101 Charlotte P. Mkhize (KZN, R840.00/hour, 15.0 hours, 011-670-9085); employee 2051 Tumy A. Nxumalo (KZN, R120.00/hour, 27.8 hours, 072-389-9935); employee 2231 Daphny M. Zulu (ZCM, R1300.00/hour, 23.5 hours, 065-155-8553); and employee 2121 Mampilo M. Seoka (BEE, R1300.00/hour, 25.1 hours, 081-021-9504). Based on this file structure, identify the data redundancies you can detect, and explain how these redundancies could lead to anomalies.Show the full question

  13. Question 2.3 · Normalisation and dependencies · 2 marks

    Define what is meant by an unnormalized relation.Show the full question

  14. Question 3.1 · The relational model · 2 marks

    Give a brief explanation of what is understood by the term data governance.Show the full question

  15. Question 3.2 · The relational model · 4 marks

    Describe what a table is and explain the role it fulfils within the relational model.Show the full question

  16. Question 3.3 · The relational model · 10 marks

    Explain the role played by a DBMS (database management system) and outline the advantages it offers.Show the full question

  17. Question 4.a · Normalisation and dependencies · 10 marks

    BTEE Shuttle Services is reconsidering how it manages its reservations. Rather than simply recording the number of persons linked to a single reservation, the company wants to store the name and address of every person associated with each reservation. Should BTEE Shuttle Services adopt this change, the trip price and other fee amounts charged for each trip would then depend only on the trip ID. Using the table definition RESERVATION(RESERVATION_ID, TRIP_ID, TRIPDATE, TRIPDATE, TRIP_PRICE, OTHERFEES, (CLIENT_NUMB, CLIENT_SURNAME, CLIENTFIRSTNAME, ADDRESS, CITY, PROVINCE, POSTAL_CODE, PHONE)), identify the multivalued dependencies present, and then transform this table into an equivalent set of tables that satisfy fourth normal form.Show the full question

  18. Question 5.1 · Entity relationship modelling · 6 marks

    Imagine you need to design a database to track data for mountain climbing expeditions. Each member of an expedition is referred to as a climber, and one climber is designated as the leader of that expedition. Climbers may participate in many expeditions over time. During each expedition, the climbers attempt to ascend one or more peaks by scaling one of several possible faces of those peaks. The information that must be tracked includes: the name of the expedition, the leader of the expedition, and comments about the expedition; the first name, last name, nationality, birth date, death date, and comments about each climber; the name, location, height, and comments about each peak; the name and comments about each face of a peak; comments about each climber's participation in each expedition; and, for each attempt by a climber to ascend a particular face, the highest height reached, the date of the attempt, and commentary on that attempt. Without drawing any dependency diagrams, write out the relational schema (i.e. the set of relations/tables with their attributes) needed to satisfy third normal form (3NF) requirements for the mountain climbing expedition data described above.Show the full question

  19. Question 5.2 · Entity relationship modelling · 24 marks

    Imagine you need to design a database to track data for mountain climbing expeditions. Each member of an expedition is referred to as a climber, and one climber is designated as the leader of that expedition. Climbers may participate in many expeditions over time. During each expedition, the climbers attempt to ascend one or more peaks by scaling one of several possible faces of those peaks. The information that must be tracked includes: the name of the expedition, the leader of the expedition, and comments about the expedition; the first name, last name, nationality, birth date, death date, and comments about each climber; the name, location, height, and comments about each peak; the name and comments about each face of a peak; comments about each climber's participation in each expedition; and, for each attempt by a climber to ascend a particular face, the highest height reached, the date of the attempt, and commentary on that attempt. Draw an entity-relationship diagram using UML notation to represent the mountain climbing expedition database described above. Your diagram must include all the appropriate entities, the relationships between them, and the correct connectivities and cardinalities for each relationship.Show the full question

  20. Question 6.1 · SQL · 3 marks

    All SQL syntax must be written correctly, since missing characters will be penalised. The questions that follow make use of data drawn from UNISA's student registration information, focusing on a STUDENT table that forms part of this database. The STUDENT entity's attributes are: STUD_NUMBER (the primary key), DEPT_CODE (a foreign key referencing DEPARTMENT), STUD_FIRSTNAME, STUD_SURNAME, STUD_INITIAL, and STUD_EMAIL. Write the SQL statement needed to create the STUDENT table shown, whose attributes are STUD_NUMBER (primary key), DEPT_CODE (foreign key referencing DEPARTMENT), STUD_FIRSTNAME, STUD_SURNAME, STUD_INITIAL and STUD_EMAIL. You should choose and apply your own appropriate data declarations for each attribute.Show the full question

  21. Question 6.2 · SQL · 3 marks

    All SQL syntax must be written correctly, since missing characters will be penalised. The questions that follow make use of data drawn from UNISA's student registration information, focusing on a STUDENT table that forms part of this database. The STUDENT entity's attributes are: STUD_NUMBER (the primary key), DEPT_CODE (a foreign key referencing DEPARTMENT), STUD_FIRSTNAME, STUD_SURNAME, STUD_INITIAL, and STUD_EMAIL. As a registered student, write the SQL code needed to insert your own correct personal information as a new record into the STUDENT table.Show the full question

  22. Question 6.3 · SQL · 3 marks

    All SQL syntax must be written correctly, since missing characters will be penalised. The questions that follow make use of data drawn from UNISA's student registration information, focusing on a STUDENT table that forms part of this database. The STUDENT entity's attributes are: STUD_NUMBER (the primary key), DEPT_CODE (a foreign key referencing DEPARTMENT), STUD_FIRSTNAME, STUD_SURNAME, STUD_INITIAL, and STUD_EMAIL. Write the SQL code required to update your email address in the STUDENT table, changing it from your UNISA 'mylife' email address to a Gmail address.Show the full question

  23. Question 6.4 · SQL · 1 mark

    All SQL syntax must be written correctly, since missing characters will be penalised. The questions that follow make use of data drawn from UNISA's student registration information, focusing on a STUDENT table that forms part of this database. The STUDENT entity's attributes are: STUD_NUMBER (the primary key), DEPT_CODE (a foreign key referencing DEPARTMENT), STUD_FIRSTNAME, STUD_SURNAME, STUD_INITIAL, and STUD_EMAIL. Write the SQL code required to delete the STUDENT table from the database.Show the full question