HS2021 Database Design and Use

Our custom writing team will address all your assignment
requirements and provide a top-grade paper; 100% plagiarism free.
We provide 24/7 customer Support.

Order Essay Papers with a Few Clicks



Get my paper done

By clicking “Get my paper done”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related emails.

HS2021 Database Design and Use

Assessment Details and Meekness Guidelines Trimester T2 2020 Unit Code HS2021 Unit Title HS2021 Database Design and Use Assessment Type Individual Provision Assessment Title Database Design Purpose of the assessment (with ULO Mapping) a) Design and instrument conceptional database restraint an knowledge rule by because occupation need and matter of the rules. b) Retrieve and confer-upon knowledge from peevish administrative areas knowledge using SQL tools and techniques. Weight 15% of the aggregate assessments Aggregate Marks 15 Word expression N/A Ascribable Purpose Week 08 Meekness Guidelines • Accomplished toil must be acquiesceted on Blackboard by the ascribable purpose parallel with a accomplishedd Provision Cover Page. Meeknesss made behind the ascribable purpose and duration accomplishedure be penalized per day slow (including weekpurpose days) according to Holmes Institute policies. • The

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
Ordinance Description
1. Discuss each of the aftercited stipulations (3 Marks):
(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).
(5 Marks)
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.
(4 Marks)
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.)
(3 Marks)
P a g e | 3
Marking criteria:
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
Question answerableness
Skills
/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.
Identification
/3 Demonstrat
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
demonstrate
force to contemplate critically.
Analyse
/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.
Design
/Presentation
/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.
Evaluate/
justification
/3
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.

IN NEED OF CUSTOM WRITING HELP FOR THIS PAPER OR SIMILAR ASSIGNMENTS? PLACE ORDER NOW & GET INSTANT ASSISTANCE!

essay assignment writing

  1. 1

    You fill in the Order Form by providing assignment details and all necessary instructions..

  2. 2

    We assign a writer who has similar background and a degree in your subject.

  3. 3

    The assigned professional takes the assignment and starts working on it.

  4. 4

    When everything is ready, we send the paper to your personal account and your email.

5 to 15% OFF Discount!!

For all your orders at Homeworkacetutors.com get discounted prices!
Top quality & 100% plagiarism-free content.