Assessment Details – MN405 Unit Title Data and Information Management
[ad_1]
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
Assessment Details and Submission Guidelines
Unit Code MN405
Unit Title Data and Information Management
Assessment
Type
Assignment 2
Term, Year T2, 2019
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. Understand the fundamental principles of the networking and data requirements of a network.
b. Identify organisational information requirements.
c. Model organisational information requirements using conceptual data modelling techniques.
d. Convert the conceptual data models into relational data models and verify their structural
characteristics with normalisation techniques.
e. Implement and utilise a relational database using a database system.
Weight 20% of total assessment for the unit
Total Marks 60 Marks
Word limit No specific word limit
Due Date Week 11, 26th September 2019 before 5.00 PM
Description of
this
assignment:
This assignment is to develop a data models, map and implement a Database System in a
standard development environment to gain understanding of data model development 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, file name should be:
“MN405_T2_2019_Assigment2_your_name.docx”.
The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (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.
Extension If an extension of time to submit work is required, a Special Consideration Application must
be submitted online to AMS follow the link below you may require to login. You must submit
this application three working days prior to the due date of the assignment.
https://online.mit.edu.au/ams/PublicDocs/Student/MIT_Special_Consideration_Application.
pdf
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/policiesprocedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure. For further
information, please refer to the Academic Integrity Section in your Unit Description.
MN405 Data and Information Management Page | 2 of 2
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
Assignment Description
60 Marks
1. Complete the information-level design for a database that satisfies the following constraints and user
view requirements. In order to complete this information–level design you are required to answer the
questions given below 1(a) – (f).
The organisers of the GreenID2019 international multi-conference need to keep track of a large
collection of workshops associated with the event. Initial requirements analysis brings out the following
User view requirements / business rules about what needs to be recorded. Assume that you are given a
task to model the database by using these business rules.
Complete the information-level design of the database that satisfies the following constraints and user
view requirements.
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 particular 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 e.g. VIC, QLD,
etc..) 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 rooms 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 requirements.
In order to complete this information-level design you are required to answer questions given
below 1 (a) – (e)
MN405 Data and Information Management Page | 3 of 3
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
a. Analyse all user requirements given above and identify and list entities described in these user
requirements. (5 Marks)
b. Add attributes to these entities and represent them as a collection of tables and attributes
(Database schema):
e.g. Participant(Participant_ID , P_name, email , W_name.)
Note: Select and underline suitable primary key for each table. (5 Marks)
c. Outline 3 business rules that describe the relationships between entities. (5 Marks)
Note: You can make assumptions to create certain relationships, if it is not specifically
mentioned in the given business rules.
e.g. Every workshop needs an allocated meeting room
d. Determine the functional dependences. (5 Marks)
e.g. Participant_ID - name, address, ……
e. Then normalise these tables. Make the normalization to 3NF. State for every step in the
normalization, which functional dependency causes it. (5 Marks)
2. Represent the structure of your database visually by using an entity-relationship (E-R) diagram. If you
make any assumptions about data that are not explicitly given in the problem, these must be described.
Note: You need to use Visio, draw.io [1] or Lucid chart [2] or any other software tool, to
create the ER diagram. (15 Marks)
3. Model building
a. Build this model using MS Access/ SQLite by creating these tables and Relationships.
b. Populate these tables with appropriate data; include at least 2 records in each table. Include the
following in your MS Word document. (10 Marks)
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.
Figure 1 Datasheet view 1 Figure 2 Design View
MN405 Data and Information Management Page | 4 of 4
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
II. If you are using SQLite
Screen shots of CREATE TABLE command and you can use INSERT INTO
commands to add records.
Figure 3 CREATE TABLE command in SQLite
4. Report Generation
a. Write an SQL query to generate one example of useful information that can be obtained from
this database. (5 Marks)
b. For additional 5 marks you can execute more queries (at least 2) on the database you created in
Question 3 and include the screen shots of the outputs and all SQL statements.
(5 Marks)
Bibliography
[1] Draw.io. (2018, December). [Online]. https://www.draw.io/
[2] Lucidchart. (2018, December) ER Diagram Tool. [Online].
https://www.lucidchart.com/pages/tour/ER_diagram_tool
MN405 Data and Information Management Page | 5 of 5
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
Marking criteria:
Example of marking criteria is shown in the following table. Marks are allocated as follows:
Section to be included in the
report
Description of the section Marks
1. Information Requirements
a. Identify all entities Identify entities from the given user requirements 5
b. User Views as Tables Represent the User Views as a collection of Tables 5
c. Relationships Determine the relationships between entities 5
d. Functional
dependences.
Determine Functional dependences. 5
e. Normalise tables Analyse above tables and normalise 5
2. ER Diagram Represent the structure of your database visually
by using the ER diagram. Evaluate your proposed
solutions
15
3. Model building Build the model of the database using MS Access /
SQLite
10
4. Report Generation Show the operation of a useful SQL Query and its
outputs
10
TOTAL marks or the Report 60
Example Marking Rubric for Assignment 2 Report
Grade
Mark
HD
100%
DISTINCTION
80%
CREDIT
60%
PASS
40%
Fail
0-40%
1.(a),(b),(c)
Identify organisational
information requirements
(15 marks)
Ability to think
critically, and
analysed
clearly.
Relevant, and
soundly
analysed.
Generally
relevant,
and
analysed.
Some
relevance,
and briefly
presented.
Not relevant
to the
assignment
question.
1(d), (e)
Functional dependencies
and normalisation –
Convert the conceptual
data models into relational
data models and verify their
structural characteristics
with normalisation
techniques.
(10 marks)
Demonstrated
excellent ability
to think
critically and
identified
dependencies
correctly.
Demonstrate
d good
ability to
think
critically and
identified
dependencies
correctly.
Demonstr
ated
ability to
think
critically
and
identify
some
dependen
cies.
Demonstrate
d some
ability to
think
critically, and
identified
some
dependencies
.
Did not
demonstrate
ability to
think
critically.
2. ER Diagram –
Model organisational
information requirements
using conceptual data
modelling techniques.
(15 marks)
Extremely good
effort. All
elements are
present and
very well
integrated.
Outstanding.
Good effort.
Most
components
are present
and well
integrated.
Good
effort
made but
not
outstandi
ng.
Made some
effort with
inaccuracies.
Very little
attempt. Lazy
effort with
inaccuracies
MN405 Data and Information Management Page | 6 of 6
Prepared by: Dr. Deepani Guruge Moderated by: Dr. Mohammad Mohammad August, 2019
3. Model building on MS
Access or SQLite
(10 marks)
Extremely good
effort. All
elements are
present.
Good effort.
Most
components
are present.
Good
effort
made but
some
compone
nts are
missing.
Made some
effort with
inaccuracies
Very little
attempt. Lazy
effort with
inaccuracies.
4. Report Generation –
Implement and utilise a
relational database
using a database
system- SQL queries
(10 marks)
All elements
are present and
very well
integrated.
Logic is very
clear and easy
to follow.
Components
present and
well
integrated.
Logic is clear.
Compone
nts
present
and
mostly
well
integrate.
Logic is
mostly
consistent
.
Most
components
present; but
logic is not
clear and
consistent;
Representati
on lacks
structure.
Arguments
are confused
and
disjointed.
The post Assessment Details – MN405 Unit Title Data and Information Management appeared first on mynursinghomeworks.
[ad_2]
Source link
