Revision Questions for Week 1 and 2: use the Student Notes book to answer these questions. The answers will be discussed briefly during the lecture.

What is the meaning of these acronyms?

  • DML = Data Manipulation Language
  • DDL = Data Definition Language
  • DBA = Database Administrator
  • DBMS = Dababase Management System
  • ER = Entity Relationship
  • ISO = International Standards Organisation
  • LOL = Laughing Out Loud (this is has nothing to do with databases :)
  • SQL = Structured Query Language

    Which of the following is NOT part of the database architecture?

    relational

    Which of the following is correct?

  • Redundancy can cause loss of integrity

    Which are the two main types of integrity constraints?

    Entity integrity and Referential integrity

    Which of the following is correct?

  • A primary key is a group of 1 or more columns which when taken together is unique in the table

    Which of the following is correct?

  • SELECT regno from car WHERE OWNER is NULL

    Which of these require AND, which require OR?

  • Find employees in department 7 and 9: depno = 7 OR depno = 9
  • Employees who took course 2 and work in department 5: courseno = 2 AND depno = 5
  • Employees who have never worked in department 7 or 8: NOT depno = 7 AND NOT depno = 8
  • Employees who have never worked in department 7 or 8: NOT (depno = 7 OR depno = 8)

    The list "Susan Smith, Tom Green, Walter Black" would have been derived using

  • ORDER BY name ASC

    Which of these is NOT an aggregate function?

    DISTINCT

    Which of the following is an entity type, entity, attribute or a relationship type?

  • John Smith : entity
  • employee: entity type
  • manages: relationship type
  • employee ID: attribute

    What is the cardinality (one-to-one, many-to-one, one-to-many, many-to-many) of

  • employee -- phone number: one-to many (or many-to-many if some employees share a phone)
  • employee -- empno: one-to-one
  • student -- module: many-to-many

    How are keys identified in an ER diagram?

  • They are represented in an oval and underlined.