辅导ST1001、讲解java/C++、辅导Database Management、辅导CS/python编程设计
- 首页 >> Python编程DBMS Assignment
ST1001 P a g e | 1
SCHOOL OF COMPUTING (SOC)
DIPLOMA IN BUSIESS INFORMATION TECHNOLOGY
DIPLOMA IN INFOCOMM SECURITY MANAGEMENT
DIPLOMA IN INFORMAION TECHNOLOGY
Database Management Systems ST1001
AY1819 Semester 2 Assignment 1
Warning: Plagiarism means passing off as one's own the ideas, works, writings, etc.,
which belong to another person. In accordance with this definition, you are committing
plagiarism if you copy the work of another person and turning it in as your own, even if
you would have the permission of that person. Plagiarism is a serious offence and
disciplinary action will be taken against you.
I. Part 1 Assignment Deadline
Deadline Deliverables
Week 8, 3rd Dec 2018 Monday 1700 Hrs ? Conceptual Data Model
Tabulation of entity types
Late Submission
50% of the marks will be deducted for assignments that are received within ONE (1) calendar
day after the submission deadline. No marks will be given thereafter. Exceptions to this
policy will be given to students with valid LOA on medical or compassionate grounds.
Students in such cases will need to inform the lecturer as soon as reasonably possible.
Students are not to assume on their own that their deadline has been extended.
II. Schedule
This assignment carries a weightage of 20% of the total assessment.
No Task
1 Draw the conceptual data model (ERD).
Determine attributes for each entity type based on the website and given features.
Identify the Primary key.
2 Prepare Assignment 1 report for submission.
DBMS Assignment
ST1001 P a g e | 2
III. Objective of Assignment
The objective of this assignment is to design and implement a relational database that
supports the enquiry of programmes and class schedules and registration of a student at
Learning Lab that satisfies the constraints set in this assignment.
IV. Overview of Assignment
In this assignment, students are to perform the following:
You may refer to Learning Hub’s for an overall understanding of programme
enquiries (https://www.thelearninglab.com.sg/programs/upper-primary/), class
schedules enquiries and student registration website
(www.thelearninglab.com.sg/class-schedules/). Note that you are NOT supposed to
design the database for the whole website. The URLs serve to give you some idea of
the terms used for programmes and schedules searching and student registration and a
flavor of a real website.
Note that the requirements furnished in this assignment do not represent the actual
system requirements of the Learning Lab website.
Design a conceptual data model for the database to be implemented to facilitate the
following features with the help of the URLs given:
o Enquiry of programmes
o Enquiry of schedules
o Registration of a student
V. Enquiry of Programmes
There are 3 types of programmes: MOE programmes (preschool, lower primary, upper
primary, secondary, junior college), workshops and holiday programmes. You need only to
focus on the requirements for the first 2 types of programmes. Both MOE programmes and
workshops have common information but MOE programmes focus on certain features while
workshops are listed under different categories.
DBMS Assignment
ST1001 P a g e | 3
MOE Programes
o MOE programmes are one of the types of programmes offered by Learning
Lab. The enquiry results should show the programme name, a description, and
the special features of that programme. Each feature has a title, brief
description and a picture. Features distinguish MOE programmes from
workshops.
o You may ignore the Testimonials section.
Workshops
DBMS Assignment
ST1001 P a g e | 4
o Workshops are listed under a category. Each category should display a
category name, a brief description and a picture.
V1. Enquiry of Schedules
A schedule enquiry screen typically contains the following:
o Academic Year refers to calendar year that the classes will be scheduled for.
Refer to the website for the options provided for the different search criteria e.g.
Academic Year, Location etc.
Search Result
The timings listed refer to the starting time of the class.
VII. Registration of Student
A new student who is keen to attend class at Learning Hub will usually search for
their preferred schedule before registering as a student through their parent. The
parent’s email is unique.
DBMS Assignment
ST1001 P a g e | 5
The day the student join the programme should be stored in the child’s record along
with the other personal particulars of the child. Each time student registers for a
programme, an attendance list will be generated for the student to facilitate attendance
taking. The attendance list should capture the following information:
o Date
o StartTime
o EndTime
o Attendance (stores a one character value of either ‘0’ for absent or ‘1’ for
present).
Note: All screenshots are referenced/adapted from www.thelearninglab.com.sg
IX. Requirements
The assignment requires you to translate the given scenario into a conceptual data model that
supports the required features. Form a group of 2 students to work on the assignment.
You must ensure that your conceptual data model includes:
All entities with relevant attributes (primary key and non-key attributes) that describe
them;
All relationships that facilitate implementation of the required features.
o relationships with cardinality and participation constraints
DBMS Assignment
ST1001 P a g e | 6
o generalization hierarchies
o attribute(s) of subtypes or relationships
The written report should include the following deliverables:
A conceptual data model represented by an Entity Relationship Diagram (ERD).
Print the diagram in landscape format.
A table that documents the attributes for all entities in the ERD:
S/No Entity Name (in alphabetical
order)
Primary Key Non-Key Attributes
1. Entity name1 Primary key Non-key attribute 1
Non-key attribute 2
…
2. Entity name 2 Primary key Non-key attribute 1
X. Grading Criteria
Design of conceptual data model: How accurate are you in translating requirements
of the given scenario onto the conceptual data model?
Coverage: Are there sufficient and relevant attributes to describe each entity
identified in the conceptual data model? Are assumptions stated clearly?
Completeness: Did you include all required features?
Marks will not be awarded if your work is copied or if you allow someone else to
copy from you.
XI. Submission of Assignment
You are to use the template provided for Assignment 1 to submit the hardcopy.
---The End---