Assessment Details and Yielding Guidelines
Trimester T2 2020
Unit Code HS2021
Unit Title HS2021 Database Design and Use
Assessment Type Individual Ordinance
Assessment Title Database Design
Purpose of the
assessment (with ULO Mapping)
a) Design and utensil abstract database ce an instruction scheme by regarding matter deficiency and tenor of the schemes.
b) Retrieve and exhibit instruction from morose negotiative areas instruction using SQL tools and techniques.
Weight 15% of the entirety assessments
Entirety Marks 15
Word stipulation N/A
Ascribable Bound Week 08
Yielding Guidelines • Full exertion must be surrenderted on Blackboard by the ascribable bound concurrently with a totald Ordinance Cover Page. Yieldings made aftercited the ascribable bound and bound gain be penalized per day advanced (including weekpurpose days) according to Holmes Institute policies.
• The ordinance must be in MS Word cemat, 1.5 spacing, 11-pt Calibri (Body) font and 2 cm margins on full immodest sides of your page with exppurpose individuality headings.
• Regard sources must be cited in the passage of the news, and registered expendly at the purpose in a regard register using Harvard or IEEE referencing mode.
• The SafeAssign homogeneousness reckoning gain be used in determining the roll, if any, of plagiarism. SafeAssign gain cohibit contravention web-sites, Journal doctrines, the Web and your acknowledge adjust members’ yieldings ce plagiarism. You can distinguish your SafeAssign homogeneousness reckoning (or mate) when you surrender your ordinance to the exppurpose drop-box. If this is a sorrow you gain feel a casualty to qualify your ordinance and resubmit. However, reyielding is merely fullowed earlier to the yielding ascribable bound and bound. Aftercited the ascribable bound and bound feel elapsed your ordinance gain be graded as advanced. Surrenderted ordinances that manifest a tall roll of plagiarism gain be penalized according to the Holmes Academic Misconduct management, there gain be no adversative.
P a g e | 2
1. Discuss each of the aftercited stipulations (3 Marks):
a Data (1 Mark) b Field (1 Mark)
c Annals (1 Mark)
2. Given the aftercited matter rules, make the exppurpose being relation diagram (ERD).
a A concourse operates numerous functions. b Each function employs undivided or further employees. c Each of the employees may or may referable feel undivided or further dependents.
d Each employee may or may referable feel an encroachment narrative.
3. Write the SQL question that gain amount a register of customers who feel an unpaid counterpoise. The required output is shacknowledge in Figure 1. Referablee that the counterpoises are registered in descending command.
Figure 1 A Register of Customers with Unpaid Counterpoises
4. Suppose that you feel two consultations, EMPLOYEE and EMPLOYEE_1. The EMPLOYEE consultation contains the archives ce three employees: Alice Cordoza, John Cretchakov, and Anne McDonald. The EMPLOYEE_1 consultation contains the annals ce employee John Cretchakov. Given that instruction, what is the question output ce the UNION question? (Register the question output.)
P a g e | 3
Marks are fullocated ce each dissect as above:
Marking Rubric ce Ordinance 1 Entirety Marks 15
Excusable Very Good-tempered-natured-natured Good-tempered-natured Satisfactory Unsatisfactory
/2 Appearance of considerate and
well- written queries Appearance of good-tempered-natured-natured question answerableness skills. Generally appropriate. Displayed steady question answerableness skills. Demonstrated dirty appearance of intellect the theme.
ed excusable force to contemplate critically. Demonstrated
an force to contemplate critically. Demonstrated steady force to contemplate. Demonstrat ed some force to contemplate critically still referable total. Did referable
force to contemplate critically.
/2 Logic is intelligible and indulgent to ensue. Consistency close and convincing. Mainly congruous close and convincing. Adequate cohesion and persuasion. Arguments are abashed and unintelligible.
/5 Full elements are exhibit and very well-mannered-mannered-mannered integrated. Most of the components exhibit and integrated. Components exhibit and mainly well-mannered-mannered-mannered integrated. Most components exhibit. News lacks construction.
Excusable uncollected seek made. Extremely good-tempered-natured-natured seek. Good-tempered-natured-natured seek made still referable uncollected. Made some seek. Very dirty seek. Lazy seek with inaccuracies.