CSE2DBF 2023
Assignment 1– Part 2 (10%)
Due date: 11:59 pm Monday, May 1st 2023
AIMS AND OBJECTIVES:
✓ to convert the ER/EER model into a relational data model;
✓ to implement a relational database system (using ORACLE APEX).
This is an individual Assignment. You are not permitted to work as a group when writing this
assignment.
Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives
the impression that the work is your own. The Department of Computer Science and Information
Technology treats plagiarism very seriously. When it is detected, penalties are strictly imposed.
No extensions will be given: Penalties are applied to late assignments (5% of total assignment mark
given is deducted per day, accepted up to 5 days after the due date only). If there are circumstances that
prevent the assignment being submitted on time, an application for special consideration may be made.
See Student Handbook for details. Note that delays caused by computer downtime cannot be accepted
as a valid reason for a late submission without penalty. Students must plan their work to allow for both
scheduled and unscheduled downtime.
SUBMISSION GUIDELINES:
This assignment is to be submitted in soft-copy (one PDF file for Task 1, one .txt/.sql file
for Task 2) formats using the CSE2DBF submission link on LMS by 11:59 pm Monday
May 1st, 2023. The submission link can be found under “Assignment 1 – Part 2” under
the “Assessments” section on the subject’s LMS page.
SUBMISSION CHECKLIST:
✓ The transformation steps from the EER Model to final tables (Task 1); Make sure to show each step
of the transformation, and the final transformation tables (submit pdf).
✓ The DDL implementation for the ‘MapOnMe Database’ tables from Task 1 (create table
statements), and the required insert statements (Task 2a and 2b respectively, submit text or sql file).
Students are referred to the Department of Computer Science and Information Technology’s Handbook
and policy documents with regard to plagiarism and assignment return, and also to the section of
‘Academic Integrity’ on the subject learning guide.
TASKS:
1. Transform the EER model (Appendix A) to Relational tables, making sure you show all the
steps. The final set of tables should contain necessary information such as table names, attribute
names, primary keys (underlined) and foreign keys (in italics).
[50%]
2. a) Write create table statements to implement the tables in the ORACLE APEX. When
creating tables make sure you choose appropriate data types for the attributes and specify
any null/not null or other constraints whenever applicable.
b) Write one insert statement for each of your tables using realistic data. Make sure you take
into consideration all the necessary constraints.
[50%]
Submission note: You are required to submit two documents:
1. a PDF file with the answers for Task 1, where you clearly show all the relevant
transformation steps for the given EER model.
2. a text file (.txt) or an SQL file (.sql) for Task 2, where you have all the create table statements
and insert statements.
APPENDIX A
objectID
Region
Length
Area

d

POIName
RegionName
RoadName

Shop

Health

o

d

Primary Residential

AdminID
email
Name
TrajID
trajDateTime
trajDistance
Consists of
Trajectory Point
M(1,1)

Submit
tpTimeStamp
M(1,1)
U lastUpdate

Modified
M(0,M)
M(1,M)
trajDuration
Latitude
Longitude
Coordinate
CoorList
Points
email
Name
memberID
joinDate
Latitude Longitude
seq Coordinate
U U
U U U