CSIT115 Data Management and Security Assignment 1
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
CSIT115 Data Management and Security
Assignment 1
2022
Scope
This assignment is related to conceptual modelling of the sample database domain, extension of a given conceptual schema and logical design.
Please read very carefully information listed below.
This assignment contributes to 6% of the total evaluation in a subject CSIT115.
The outcomes of the assignment work are due by Saturday 2 April 2022, 7.00 pm (sharp).
A submission procedure is explained at the end of specification.
This assignment consists of 2 tasks and specification of each task starts from a new page.
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 Assignment 1 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 (3.0 marks)
Read and analyse the following specification of a sample database domain.
A multinational company consists of divisions, and each one
is in a different country.
A division is described by the name, address of its
headquarters, and the first name, initials, last name of
its CEO. The address of headquarters consists of the
country name, city, street, and building number.
Divisions consist of branches.
A branch is described by a city, street, building number,
and the first name, initials, last name of its director.
Each branch is in different addresses.
Each branch consists of departments. A department is
described by a name, the first name and last name of its
manager, and the budget allocated for the department. A
department name is unique within a branch.
An objective if this task is to construct a conceptual schema for the specification of a database domain listed above.
It is not allowed to add any artificial identification attributes to the specification listed above.
Use UMLet tool to create a drawing of a conceptual schema in a notation of UML simplified class diagrams explained to you during the lecture classes in CSIT115. No other notation will be accepted!
Remember to use CSIT115-815Palette palette!
Use an option File->Export as… to export your diagram into a file solution1.bmp in BMP format. Do not delete an exported file. You will submit it as one of the deliverables from your laboratory work.
In this task there is NO NEED to provide a detailed analysis of a conceptual schema. The final conceptual schema expressed in a notation of UML simplified class is completely sufficient.
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 (3.0 marks)
Consider conceptual schemas given below.
(1)
(2)
(3)
Your task is to perform logical database design, i.e. to transform conceptual schemas given above into a collection of relational schemas.
For each relational schema created clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume that the superset method must be used to implement a generalization (if any). A way how a conceptual schema can be transformed into a collection of relational schemas is explained in a presentation 06 Logical Design.
The relational schemas must be listed in a format presented in the slides 44 and 45 in a presentation 06 Logical Design. Listing of the relational schemas in the other format scores no marks.
Note that the order of the definitions on the relation schemas is important. You must define a parent relation schema (referenced) before its child relational schema (references to the parent relational schema).
Deliverables
A file solution2.pdf with a list of relational schemas, primary key for each relational schema, candidate keys (if any) for each relational schema, foreign keys (if any) for each relational 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 the correct files with the correct contents and correct types. No other submission is possible!
Submit the files solution1 .bmp and solution2 .pdf through 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 (S122) 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 Assignment 1
(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 file solution2 .pdf.
(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