Prepared by: Dr. Deepani Guruge Moderated Dr. Wanod Kumar May2022
Assessment Details and Submission Guidelines
Unit Code BN204
Unit Title Database Technologies
Assessment
Type
Assignment 2 (Individual)
Term, Year T1, 2022
Assessment Title Data model development and implementation
Purpose of the
assessment
(with ULO
Mapping)
The purpose of this assignment is to develop data models and map Database System into
a standard development environment to gain understanding of data model
development. Then implement the data model using a commercially available database
management system development tool.
On completion of this assignment students will be able to:
a. Describe issues related to the integrity and security of database (DB) systems.
. Make an informed and critical assessment of database management systems
(DBMS).
c. Develop data models and implement DB systems.
d. Analyse business decisions related to DB information systems.
e. Demonstrate skills in building a database application using a commercially
available database management system development tool.
Weight 20% of total assessment for the unit
Total Marks 90 = 20 (for online quiz- Part A XXXXXXXXXXfor Part B)
Word limit No specific word limit
Due Date XXXXXXXXXXweek 11 : 5th June 2022 ; XXXXXXXXXX:55PM
Description of
this assignment:
This assignment consists of two parts:
Part A: An online quiz Assignment 2, which includes 30 questions. Students may
have 3 attempts at this quiz. The system will select the highest grade. This Quiz
will be opened only during the week 9 Laboratory class.
Part B: The creation of an ER diagram, checking data integrity and implementation
Submission
Guidelines
All work must be submitted on Moodle by the due date. Write your answers in this
document underneath the question and save as
“BN204_T1_2022_Assigment2_your_name.doc”.
The assignment must be in MS Word format, 1.5 spacing, 11-pt Cali
i (Body) font and
2.5 cm margins on all four sides of your page with appropriate section headings.
Reference sources must be cited in the text of the report, and listed appropriately at
the end in a reference list using IEEE referencing style.
Submit both the database that you created and the word document.
BN204 Database Technologies Page | 2 of 2
Prepared by: Dr. Deepani Guruge XXXXXXXXXXModerated by: Dr. Wanod Kumar May 2022
Extension If an extension of time to submit work is required, a Special Consideration Application
must be submitted directly to the School's Administration Officer, in Melbourne on
Level 6 or in Sydney on Level 7. You must submit this application three working days
prior to the due date of the assignment. Further information is available at:
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-
and-guidelines/special-considerationdeferment
Academic
Misconduct
Academic Misconduct is a serious offence. Depending on the seriousness of the case,
penalties can vary from a written warning or zero marks to exclusion from the course
or rescinding the degree. Students should make themselves familiar with the full policy
and procedure available at:
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-
guidelines/MIT-Student-General-Misconduct-Policy-Procedure
For further information, please refer to the Academic Integrity Section in your Unit
Description.
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/special-considerationdeferment
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/special-considerationdeferment
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/MIT-Student-General-Misconduct-Policy-Procedure
http:
www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/MIT-Student-General-Misconduct-Policy-Procedure
BN204 Database Technologies Page | 3 of 3
Prepared by: Dr. Deepani Guruge XXXXXXXXXXModerated by: Dr. Wanod Kumar May 2022
Assignment Description
Part A: (20 marks)
Paste below the summary of your Assignment 2 online quiz on Moodle.The quiz will be open in week 9
laboratory class.
Part B: (70 marks) - Database Design
1. Database Design
The organisers of the AI_2023 international multi-conference need to keep track of large collection
of workshops associated with the event. Initial requirements analysis
ings out the following User
view requirements / business rules about what needs to be recorded.
Assume that you are the database developer for this task, complete the information-level design for
the database for “AI_2023 international” that satisfies the constraints and user view requirements
given below.
In order to complete this information-level design you are required to read the user view
equirements/ business rules given below and answer the question.
User view 1 requirement / business rule
There are several participants, each of which may sign up to one or more workshops.
User view 2 requirement / business rule
Each workshop has a name, ID and an identified organizer.
Some workshops happen on a given date and some workshops last more than one day. You may
need separate entity to store days.
User view 3 requirement / business rule
For each participant, it is important to record their name, email address, state (VIC, QLD,..) and
the workshops which they wish to attend.
Every participant must register for at least one workshop.
User view 4 requirement / business rule
There are a number of meeting rooms at the conference venue, each of a fixed capacity. Meetings
ooms are identified by a floor and room number.
Every workshop needs an allocated meeting room; where a workshop lasts for two days, it will use
the same room on both days
Note: Write down any assumptions you make if they are not explicitly described here in user
equirements.
a. Identify and list entities described in the given case scenario. (5 Marks)
. ER diagram - Create a Crow’s Foot Notation Entity Relationship Diagram (ERD) to support the
following business operations.
You need add attributes and select suitable primary keys for each entity.
I. If you make any assumptions about data that are not explicitly given in the problem,
these must be described.
BN204 Database Technologies Page | 4 of 4
Prepared by: Dr. Deepani Guruge XXXXXXXXXXModerated by: Dr. Wanod Kumar May 2022
II. You are required to use a software tool to create the ER diagram. You can use
draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram.
XXXXXXXXXXMarks)
2. Data Integrity
a. Represent entities and attributes you listed above as collection of tables and attributes.
Eg. Student (Stu_ID, Sname,…….
NB: Select suitable primary key for each table and underline them. (5 Mark)
. Determine the functional dependences XXXXXXXXXXMarks)
Eg. Stu_ID --- > Sname, , ......, ......
c. Normalise these tables. Make the normalization to 3NF and explain every step in the process.
(10 Marks)
3. Model Building
Build this model using MS Access/SQLite by creating these tables and Relationships.
Populate these tables with appropriate data, at least 2 records in each table.
Include following into your MS Word document.
XXXXXXXXXXMarks)
I. If you are using MS Access include following screen shots
Relationship diagram created in Access. (Select database tools Relationships in the
Access menu)
Data sheet view and design view of your tables as given below in Figure 1 and 2. For
Participant_Name and email you need to use your MIT email and your name as one
data record.
Figure 1 Data Sheet View XXXXXXXXXXFigure 2 Design View
II. If you are using SQLite
Include screen shots of CREATE TABLE command and INSERT INTO commands.
Eg.
BN204 Database Technologies Page | 5 of 5
Prepared by: Dr. Deepani Guruge XXXXXXXXXXModerated by: Dr. Wanod Kumar May 2022
4. Report Generation
a. Write a query to extract useful information from this database XXXXXXXXXXMarks)
. Execute this query on the database and attach the screenshot of your output XXXXXXXXXXMarks)
5. Research Question
Medical Internet of Things (MIoT) is the group of devices connected to Internet, to perform the processes
and services that support healthcare. Read the research paper titled “Security and Privacy in the Medical
Internet of Things: A Review” and answer questions 5(a) to 5(b). Answer these questions with IEEE
eference style.
“Sun, W., Cai, Z., Li, Y., Liu, F., Fang, S., & Wang, G XXXXXXXXXXSecurity and privacy in the
medical internet of things: a review. Security and Communication Networks, 2018.”
You can download the paper saved in the assignment folder on Moodle or access it through
https:
downloads.hindawi.com/journals/scn/2018/ XXXXXXXXXXpdf
and download the paper.
a. Discuss
iefly the requirements needs to be considered (researchers indicated in this paper) to
protect security and privacy of the data collected from MIoT devices. (5 Marks)
. This paper presented a comprehensive literature review on security and privacy in the medical
internet of things. Briefly summarise the existing solutions discussed in this paper to protect
security and privacy of the data collected