COMP1556 - DB Applications

Page 0 of 19
Authors:
University of Greenwich
[Date]
COMP1556 - DB Applications

Table of Contents
1 Introduction (Can be completed in pairs.)...............................................................................2
1.1 Who worked on what?......................................................................................................2
2 Assumptions (Can be completed in pairs.)..............................................................................3
3 Conceptual Model (Can be completed in pairs.).....................................................................4
4 Physical Model (Can be completed in pairs.)..........................................................................5
5 The Implementation of Applications (Can be completed in pairs.).........................................6
5.1 The INSERT commands for each table (or an INSERT command and saying which data
generation site was used and how many records were added to each table)...............................6
5.1.1 Table 1 : Name :........................................................................................................6
5.1.2 Table 2 : Name...........................................................................................................7
5.1.3 Table 3 : Name...........................................................................................................7
5.1.4 Table 4 : Name...........................................................................................................8
5.1.5 Table 5 : Name...........................................................................................................9
6 SQL Coding Tasks (To be completed individually.).............................................................11
6.1 Task 1 (plus screenshot of the results returned)..............................................................11
6.2 Task 2 (plus screenshot of the results returned)..............................................................12
6.3 Task 3 (plus screenshot of the results returned)..............................................................13
6.4 Task 4 (plus screenshot of the results returned)..............................................................14
7 Self-evaluation (What went well, what went less well and which lessons have you learned
from this work?) (To be completed individually.).........................................................................15
8 Self-Marking..........................................................................................................................16
Page 1 of 19

1 INTRODUCTION (CAN BE COMPLETED IN PAIRS.)
1.1 WHO WORKED ON WHAT?
Name of Student
% input to assumptions
% input to conceptual diagram
% input to physical diagram
% input to DB creation and population
% input to List A tasks
% input to List B tasks
Page 2 of 19

2 ASSUMPTIONS (CAN BE COMPLETED IN PAIRS.)
1. Frist of all it was assumed that only the teachers can create courses and each course table
will hold the primary key of the teacher who created it. As there will be many students
who can enroll into the courses and a single course can have many student, there will be
many-to-many relationship among the tables. That is why a bridge table called
enrollment has been created. It is also assumed that for now a single student can have
only one entry for homework. This can be changed but is used for now to test the
database.
Page 3 of 19