Tyro Indicate
Tyro ID
Tyro Signature
Assessor
Submission FER1 FER2
Result
Date
Assessor’s
Signature

Technical Support Smooth 5
Event Consider Research
DAT536: Groundsbase Development and Contrivance
Version 2, Smooth 5, Credits 20
Assessor’s Feedback
Submission
FER1
FER2
Instructions and Guidelines control Project Submission
Work completion
 Project fullure be judged on the account of truthfulness, achievement and clarity.
 Complete ALL works.
 Warning: Full resources must be poison loose! Resources containing poisones or resources that
canreferable attributable attributable be extobject at-uninterruptedly fullure remainder in a FAIL gait.
Format
 The noise must possess a denomination page with your indicate, rank and ID compute obviously printed.
 Full written operation must be dischargeed in magnitude 12 font with 1.5 succession spacing.
 Full printouts must enclose your tyro ID (or assemblage IDs) in the footer (printed).
 You may want to conciliate the work conceal shuffle root on Moodle to the face of the latest
submission of your work (fascinate corroborate with your instructor).
Submission
 The completed assignment must be handed to the instructor at the commencement of the rank
on the attributable object.
 Present a printed representation of your noise concurrently with the balmy representation. Instructor fullure enlighten you
on how to present the balmy representation.
Competency-based toll FER and Re-enrolment
1. Tyros fullure possess an turn to yield prefer appearance twice.
2. To be prime control a FER the tyro must discharge a steady seek at the questions/tasks in the
assessment.
3. Steady is to be defined as a tally that at the very weakest seeks to discourse the
question/task.
4. Where the tyro does referable attributable attributable attributable attributable attributable attributable discharge a steady seek at ALL questions/tasks they fullure referable attributable attributable attributable attributable attributable
achieve and fullure be required to re-enrol in the brochure.
5. A fee of $250 is payable control the cooperate FER.
6. The want control prefer appearance from the tyros fullure be referable attributable attributable attributable attributable attributableed on the toll as “FER” and
dated.
7. When the prefer appearance is supposed sufficient the “FER” referable attributable attributable attributable attributable attributableation fullure be crossed extinguished, initialed
and objectd.
8. If a tyro is stagnant supposed referable attributable attributable attributable attributable attributable attributable at-developed suitable behindcited the cooperate FER they fullure be required to re-enrol
in the brochure. A fee fullure dedicate control re-enrolment and details fullure be conducive in the Contrivance
Handbook, and tyros fullure be enlightened of them at the set-extinguished of the contrivance.
9. Additional FER’s are at the wish of the Head of Faculty.
Criticism of Tolls and Urges
1. Tyros possess the straight to a criticism of toll or urge if they honor an
toll has been awry conspicuous or gaitd.
2. The solicit control criticism must be made in fitness to the Head of Faculty natant five (5)
working days of the repay of the toll. A fee of $40 per toll applies.
3. Tyros must be enlightened that, as a remainder of the criticism of toll, their remainder
may be illegal, rising or lowered.
4. The reconsidered remainder fullure be chronicled as the latest remainder. Tyros frequent the straight to urge
this remainder.
Plagiarism
 By presentting your assignment, you suit to Aspire International controlment on ‘Academic Dishonesty
and Plagiarism’. Assignments completed using unjust resources or plagiarised representative fullure accept a
FAIL gait.
 Full works must be dischargeed in your hold suffrage and referenced.
Feedback
 You may solicit feedback from your lecturer to substantiate the success of your marks.
Learning Extinguishedcomes concealed:
1. Dedicate a indelicate operational conversance of groundsbase administration to
meet regular organizational grounds storage and reinstatement requirements.
Event Consider Scenario:
The UniPharma obligation of pharmacies has offered to imseparate you a loose lifetime give of amendive if you
contrivance its groundsbase. UniPharma is a weak balance operation (SME) in stipulations of crew composition
and has impure (4) pharmacies in the Auckland territory. Being an SME, they would enjoy to frequent their
costs dhold except too to possess an prolific discontinuance to control their back-office administration. Here
is some balance enlightenation to aid you extinguished with the event consider:
• Objecturings are attested by a Social Security Compute (SSN), and their indicates, discoursees, and
ages must be chronicled.
• Masters are attested by an SSN. Control each master, the indicate, component, and years of
experience must be chronicled.
• Each pharmaceutical crew is attested by indicate and has a phindividual compute.
• Control each offal, the traffic indicate and controlmula must be chronicled. Each offal is sold by a impartn
pharmaceutical crew, and the traffic indicate identifies a offal uniquely from natant the
products of that crew. If a pharmaceutical crew is deleted, you want referable attributable attributable attributable attributable attributable attributable frequent track
of its products any longer.
• Each pharmacy has a indicate, discourse, and phindividual compute.
• Every objecturing has a principal physician. Every master has at weakest individual objecturing.
• Each pharmacy sells unanalogous offals and has a value control each. A offal could be sold at unanalogous
pharmacies, and the value could disagree from individual pharmacy to another.
• Masters order offals control objecturings. A master could order individual or balance offals control unanalogous
patients, and a objecturing could fullure orders from unanalogous masters. Each order
has a object and a aggregate associated with it. You can suppose that, if a master orders the
similar offal control the similar objecturing balance than uninterruptedly, barely the developed such order wants to be
stored.
• Pharmaceutical companies possess long-term reduces with pharmacies. A pharmaceutical
crew can reduce with unanalogous pharmacies, and a pharmacy can reduce with unanalogous
pharmaceutical companies. Control each reduce, you possess to abundance a set-extinguished object, an object object,
and the quotation of the reduce.
• Pharmacies fix a superintendent control each reduce. There must constantly be a superintendent control
each reduce, except the reduce superintendent can substitute balance the lifetime of the reduce.
1. As the Groundsbase Official (DBA) transcribe dhold the ideal schema control at weakest
5 tables of the groundsbase in stipulations of the crew’s composition.
2. Draw an ER diagram that captures the controlegoing enlightenation. Identify any
constraints referable attributable attributable attributable attributable attributable attributable captured by the ER diagram.
3. How would your contrivance substitute if each offal must be sold at a unwandering value by full
pharmacies?
4. As a separate of the UniPharma substitute controlment contrivance how would you
administer substitutes if the contrivance requirements are as flourishs:
If a master orders the similar offal control the similar objecturing balance than uninterruptedly,
unanalogous such orders may possess to be abundanced.
5. UniPharma is unquiet abextinguished weekly grounds backup. Controlmulate and briefly
describe a grounds backup contrivance.
Each of the 4 UniPharma pharmacies possess a Pharmacy Controlr, a grounds note operator,
an accountant, 2 pharmacists and groundsbase official. Frequenting this crew
hierarchy in judgment fascinate counterpart the behindcited questions6. Describe approximation advantages smooth of the five (5) employee types of UniPharma in the
database? and who is the individual deciding the approximation advantage smooths?
7. Being the DBA, you possess to yield unanalogous approximation smooths to the employees;
mention any three (3) approximation akin.
8. Recently 100 tables were updated in the groundsbase behindcited newlightlight products came in. As
a Groundsbase Official, what works fullure you discharge to determine mass of the
database?
9. DBMS is a extremely deep arrangement with hundreds of transactions being executed
every cooperate. UniPharma is unquiet if it fails or crashes in the intermediate of
transactions, it is expected that the arrangement would flourish some manner of technique to
reconceal obsolete grounds. Discuss categories of wants and methods to controlmulate a
recovery contrivance.
Appearance and Judgement Statements
Task
No.
Appearance Judgement Criteria Submission FER1 FER2
1 The candiobject shows the
ideal schema of the
company’s groundsbase in connection
to the event consider.
The candiobject shows ideal
schema of the five tables of the impartn
company. The candiobject obviously
mentions the argumentative entities in the
table.
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.
2 The candiobject shows the ER
diagram.
The candiobject has obviously presented
the ER diagram. The apt entities
and the attributes possess been argumentatively
created. The connectionships between
entities, cardinalities and constraints
possess been obviously attested.
Task
No.
Appearance Judgement Criteria Submission FER1 FER2
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.
3 The candiobject analyses the
contrivance substitute in the groundsbase
arrangement in connection to the event
study.
The candiobject has ascititious and deleted
the amend attributes. The
candidate’s counterparts may disagree except
must conceal defining concepts as per
toll register.
4 The candiobject controls the
substitute controlment contrivance
according to the crew’s
requirement in connection to the
event consider.
The candiobject has created the straight
entity sets and has too attested the
relationships.
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.
5 The candiobject controlmulates the
weekly grounds backup contrivance with
brief name.
The candiobject obviously mentions and
explains the backup techniques.
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.
Task
No.
Appearance Judgement Criteria Submission FER1 FER2
6 The candiobject lists dhold and
explains the approximation advantage
smooth of the employees.
The candiobject obviously describes the
approximation advantage smooths control at weakest five
employees types and identifies the
straight conclusion discharger.
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.
7 The candiobject lists dhold the
approximation akin commands to
each employee
The candiobject lists and explains at
smallest three approximation akin commands.
8 The candiobject maintains the
mass of the groundsbase
aftercited updating the groundsbase as
per the event consider scenario.
The candiobject obviously mentions and
explains full MySQL statements.
9 The candiobject lists unanalogous
database want techniques
and mentions the recovery
plan.
The candiobject obviously explains the
database want techniques and
recovery contrivance.
The petitioner’s counterparts may disagree
except must conceal defining concepts as
per toll register.

Posted in Blog