CSIT115 Data Management and Security Laboratory 2
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
CSIT115 Data Management and Security
Laboratory 2
2022
Scope
This laboratory is related to conceptual modelling of a sample database domain.
The outcomes of the laboratory work are due by Saturday 19 March 2022, 7.00 pm (sharp).
Please read very carefully information listed below.
This laboratory contributes to 3% of the total evaluation in a subject CSIT115. A submission procedure is explained at the end of specification.
This laboratory work consists of 2 tasks.
It is recommended to solve the problems before attending the laboratory classes in order to efficiently use supervised laboratory time.
A submission marked by Moodle as Late is treated as a late submission no matter how many seconds it is late.
A policy regarding late submissions is included in the subject outline.
A submission of compressed files (zipped, gzipped, rared, tared, 7-zipped, lhzed, … etc) is not allowed. The compressed files will not be evaluated.
All files left on Moodle in a state "Draft(not submitted)" will not be evaluated.
An implementation that does not compile due to one or more syntactical errors scores no marks.
It is expected that all tasks included within Laboratory 2 will be solved individually without any cooperation with the other students. If you have any doubts, questions, etc. please consult your lecturer or tutor during lab classes or office hours. Plagiarism will result in a FAIL grade being recorded for the assessment task.
Tasks
Task 1 (1.5 marks)
Read the following specification of a sample database domain.
(1) Each candidate has a candidate number, name, email, and
phone number. The candidate number is unique. The email of
a candidate is unique.
(2) A job is described by a job number, descriptions,
title, offered by company name, starting date, salary and
required skills. The job number is unique.
(3) A company has a name, address, phone number, website
address. The company name and address can uniquely identify
a company.
Your task is to create classes of the sample database domain given above and to draw such classes in a notation of UML simplified classes of objects explained to you during the lecture classes in CSIT115. No other notation will be accepted!
Use the UMLet application to draw the diagram of the conceptual schema. Remember to use the CSIT115-815Palette palette!
Mark the identifier(s) for each class if they are specified. It is not allowed to add any artificial attributes (not specified) to the classes listed above.
When you are ready, use the option File->Export as… to export your diagram into a file solution1.bmp in BMP format.
You can ask your tutor during a laboratory class and/or your lectures during their office hours.
Deliverables
A file solution1.bmp with the final design of a conceptual schema. Submission of a file with a different name and/or different extension and/or different type scores no marks.
Task 2 (1.5 marks)
Read the following specification of a sample database domain defined in Task 1.
A company offers many jobs. A job can only be offered by
one company.
A candidate applies for jobs. A job can be applied by many
candidates. We want to record the date of submission for
each application. A candidate cannot apply for the same job
more than once.
We want to record the historical information that includes
the candidate number, job number, and offer date if a job
has been offered to a candidate.
Your task is to draw the associations, association classes, and classes of the sample database domain given in Task 1 and Task 2 in the notations of UML simplified explained to you during the lecture classes in CSIT115. No other notation will be accepted!
Use the UMLet application to draw the diagram of the conceptual schema. Remember to use the CSIT115-815Palette palette!
When you are ready, use the option File->Export as… to export your diagram into a file solution2.bmp in BMP format.
You can ask your tutor during a laboratory class and/or your lectures during their office hours.
Deliverables
A file solution2.bmp with the final design of a conceptual schema. Submission of a file with a different name and/or different extension and/or different type scores no marks.
Submission
Note, that you have only one submission. So, make it absolutely sure that you submit correct files with the correct contents. No other submission is possible!
Submit a file solution1 .bmp and solution2 .bmp to Moodle in the following way:
(1) Access Moodle at http://moodle .uowplatform .edu .au/
(2) To login use a Login link located in the right upper corner the Web page or in the middle of the bottom of the Web page
(3) When logged select a site CSIT115 (S221) Data Management and Security
(4) Scroll down to a section Submissions
(5) Click on a link In this place you can submit the outcomes of Laboratory 2
(6) Click on a button Add Submission
(7) Move a file solution1 .bmp into an area You can drag and drop files here to add them. You can also use a link Add…
(8) Repeat step (7) for the files solution2 .bmp
(9) Click on the checkbox with a text attached: By checking this box, I confirm that this submission is my own work, … in order to confirm the authorship of your submission
(10) Click on a button Save changes
End of specification
2022-06-14