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.