辅导ST1001、讲解java/C++、辅导Database Management、辅导CS/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---