Your coursework assignment should be submitted as a single PDF file, using the following file-naming conventions:
computer science
Description
University of London
Computing and Information Systems/Creative Computing
CO2209 Database systems
Coursework assignment 1 2019-2020
ANSWER SHEET
Your
coursework assignment should be submitted as a single PDF file, using the
following file-naming conventions:
YourName_SRN_CO2209cw#.pdf
Example: GraceHopper_920000000_CO2209cw1.pdf)
- YourName is your full name as it appears on your
student record (check your student portal); Please use just your name, and
not any appellation such as ‘MR’ or ‘MS’.
- SRN is your Student Reference Number, for
example 920000000;
- CO2209 is the course number for this course
(databases).
- cw# is either cw1 (coursework 1) or cw2
(coursework 2).
A – Essay background
in databases, any problems installing MariaDB or MySQL.
[1 hour - 4 marks]
B – Data
B1 – How examples A
and C differ from B
[1 hour - 4 marks]
B2 – Which level is
being referred to?
1.
2.
3
4.
[1 hour - 4 marks]
B3 – SQL data types
(1) Smallint
(2) Mediumint
(3) Bigint
(4) Decimal
(5) Char
(6) Varchar
(7) Date
(8) Datetime
(9) Timestamp
(10)
Time
[1 hour - 4 marks]
B4 – Singapore address
formats
Formats:
|
|
|
|
|
|
|
|
|
Problem?
[1 hour - 4 marks]
B5 – Erroneous data –
the size of the problem
(a)
(b) (i)
(ii)
.
(c)
(d)
(e)
[2-4 hours - 8 marks]
B6 – Minimising data errors
- I
(a)
(i)
(ii)
(b) (i)
(ii)
(iii)
[1 hour - 4 marks]
