HS2021 Database Design and Use
Assignment 2 Individual Assessment
Assessment Weight: 15%
Due: Weeks 8
This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment
is designed to reinforce the lecture material and give students practice at applying Database design
techniques, as well as providing a relational schema using DDL statements and relational DML
statements to demonstrate access of the Database to be built.
Consider the following Case Study Scenario for ‘Holmes Software Engineering’
A relational database is to be designed for a medium sized Company dealing with industrial
applications of computers. The Company delivers various products to its customers ranging from a
single application program through to complete installation of hardware with customized software.
The Company employs various experts, consultants and supporting staff. All personnel are
employed on longterm basis, i.e. there is no short‐ term or temporary staff. Although the Company
is somehow structured for administrative purposes (that is, it is divided into departments headed by
department managers) all projects are carried out in an inter‐ disciplinary way. For each project a
project team is selected, grouping employees from different departments, and a Project Manager
(also an employee of the Company) is appointed who is entirely and exclusively responsible for the
control of the project, quite independently of the Company’s hierarchy. The following is a brief
statement of some facts and policies adopted by the Company.
• Each employee works in some department.
• An employee may possess a number of skills
• Every manager (including the MD) is an employee
• A department may participate in none/one/many projects.
• At least one department participates in a project.
• An employee may be engaged in none/one/many projects
• Project teams consist of at least one member.
For the above mini-case study, you are to analyze the data requirements and develop a set of
relational tables to suit the above case study.
• Draw and ER diagram depicting the relational database.
• Make sure the tables are normalized.
• Build the Database in PostgreSQL (storing your DDL statements in a script)
• Add test data to greSQL database (again store these DML statements in a script),
one of the employees you add must have an employee ID the same as your own Student ID.
This employee must also be part of a team working on some project
• Develop a set SQL queries to query this database (there should be at least 4 queries)
◦ at least 2 queries should joint multiple tables (1 should join at least 3 tables)
◦ at least one query should show the employee with the ID the same as your student ID
For each query, you should show the output from executing the Query in PostgreSQL by cutting
and pasting greSQL output into your assignment just under the Query.
This should be demonstrated to your tutor in class during a tutorial after the due date to be advised
by your tutor.
The day and time of the due week that the assessment must be submitted will be announced by your
Your documents should be a single MS Word or OpenOffice document containing your report. Do
not use PDF as a submission format,
All submissions will be submitted through the safeAssign facility in Blackboard. Submission boxes
linked to SafeAssign will be set up in the Units Blackboard Shell. Assignments not submitted
through these submission links will not be considered.
Submissions must be made by the due date and time (which will be in the session detailed above)
and determined by your Unit coordinator. Submissions made after the due date and time will be
penalized per day late (including weekend days) according to Holmes Institute policies.
The SafeAssign similarity score will be used in determining the level, if any, of plagiarism.
SafeAssign will check conference web-sites, Journal articles, the Web and your own class
members submissions for plagiarism. You can see your SafeAssign similarity score (or match)
when you submit your assignment to the appropriate drop-box. If this is a concern you will have a
chance to change your assignment and resubmit. However, re-submission is only allowed prior to
the submission due date and time. After the due date and time have elapsed your assignment will be
graded as late. Submitted assignments that indicate a high level of plagiarism will be penalized
according to the Holmes Academic Misconduct policy, there will be no exceptions. Thus, plan
early and submit early to take advantage of the re-submission feature. You can make multiple
submissions, but please remember we grade only the last submission, and the date and time you
submitted will be taken from that submission.
Holmes Institute is committed to ensuring and upholding Academic Integrity, as Academic Integrity
is integral to maintaining academic quality and the reputation of Holmes’ graduates. Accordingly,
all assessment tasks need to comply with academic integrity guidelines. Table 1 identifies the six
categories of Academic Integrity breaches. If you have any questions about Academic Integrity
issues related to your assessment tasks, please consult your lecturer or tutor for relevant referencing
guidelines and support resources. Many of these resources can also be found through the Study
Sills link on Blackboard.
Academic Integrity breaches are a serious offence punishable by penalties that may range from
deduction of marks, failure of the assessment task or unit involved, suspension of course enrolment,
or cancellation of course enrolment.
Table 1: Six categories of Academic Integrity breaches
|Plagiarism||Reproducing the work of someone else without attribution. When a
student submits their own work on multiple occasions this is known as
|Collusion||Working with one or more other individuals to complete an assignment, in
a way that is not authorised.
|Copying||Reproducing and submitting the work of another student, with or without
their knowledge. If a student fails to take reasonable precautions to
prevent their own original work from being copied, this may also be
considered an offence.
|Impersonation||Falsely presenting oneself, or engaging someone else to present as oneself,
in an in-person examination.
|Contract cheating||Contracting a third party to complete an assessment task, generally in
exchange for money or other manner of payment.
|Data fabrication and
|Manipulating or inventing data with the intent of supporting false
conclusions, including manipulating images.
Source: INQAAHE, 2020
Assignment status: Already Solved By Our Experts
(USA, AUS, UK & CA PhD. Writers)
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM - CUSTOM PAPER
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.
AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master's degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.