database design

Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 1 of 9
Instructions to Student
 Answer all questions.  Deadline of submission: 15/09/2020 23:59
 The marks received on the assignment will be scaled down to the actual weightage of the assignment which is 50 marks
 There is no marks allocated for work proposal. However, if you submit the work proposal within the given deadline (01/09/2020), a formal feedback will be provided. Work proposal can contain a description for initial understanding of each of the tasks and sub-tasks, identified references to complete the proposed assignment.
Module Learning Outcomes
The following LOs are achieved by the student by completing the assignment successfully
1) Manage database network (client/ server) connections using Database Net Services
2) Manage database instances and database storage.
3) Working with Distributed Databases.
Assignment Tasks
1) The Database Administrator (DBA) of a Client-Server environment needs to establish a connection between its clients and the database server. Consider the following sales event that happens in a hypermarket. “Customer picks up the items and reaches the sales counter to purchase the same”. Discuss the steps involved with respect to the sequence of actions as per the architecture of client server environment. Note that the discussion expects a customized diagram of the client server architecture (not the generic architecture) that is relevant to the sales event. Also note that generic explanation will carry no marks. Carry out some simulation experiments in the database lab and write an illustrative and reflective summary on the process involved. The discussion can have appropriate screen shots to illustrate the successful connectivity; and reflection on the process should be of not less than 1000 words.
(40 Marks)
2) Assume that you are employed as a database administrator (DBA) of a reputed hyper market in Sultanate of Oman overseeing all the operations of the hyper market database. Demonstrate the
`
IN SEMESTER (INDIVIDUAL) ASSIGNMENT
Module Code: COMP 30021
Module Name: Database Administration
Level: 3
Max. Marks: 100(Scaled down to 50)
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 2 of 9
mechanism of database replication process that is supported by the typical DBMS hosting the hyper market database. Please note that database replication involve providing backup of the database. The demonstration should include creation of some physical and logical database structures, and select appropriate backup mechanism to back up the created logical tables. (30 Marks)
3)
a. Al-Fajr polyclinic has different branches spread across multiple locations (like Ruwi, Al-Seeb, Sohar) in the Sultanate of Oman. Each branch has its own database. For effective utilization of all resources the management has decided to link all those independent databases to a Headquarter database simulating the distributed database concept. With the help of appropriate block diagrams, explain how you would view this in a homogeneous environment. (20 Marks)
b. With appropriate snippets of SQL code, discuss the concept of Database link which is used to enable the access to other databases. Write SQL command to link the above mentioned poly clinic database of a branch to the headquarters. (10 Marks)
Rules & Regulations:
 All resources should be cited using CU Harvard style.
 The final assignment must have a Title page, Table of Contents, References/ bibliography using CU Harvard Style and page numbers.
 Title Page must have Assignment Name, Module name, Session, your name, ID, and the name of the faculty.
 Softcopy in word format is to be submitted through Turnitin link on Moodle.
 Viva will be conducted after the assignment submission as per the requirements.
Guidelines:
 Assignment must be computer typed.
 Font – Times New Roman
 Font – Style – Regular
 Font – Size – 12
 Heading should be with Font Size 14, Bold, Capital and Underline.
 Explain with suitable diagrams wherever required. Diagrams must be drawn using suitable software or by pencil.
 Each student has to do the assignment individually / Students have to do the assignment collaboratively and each student should write a brief reflection on their contribution and learnings from group work.
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 3 of 9
 You can refer books in eLibrary or use internet resource. But you should not cut and paste material from internet nor provide photocopied material from books. The assignment answers should be in your own words after understanding the matter from the above resources.
Important Policies to be followed
1. Student Academic Integrity Policy*:
MEC upholds the spirit of academic integrity in all forms of academic work and any form of violation of academic integrity shall invite severe penalty. Any benefit obtained by indulging in the act of violation of academic integrity shall be cancelled.
All cases of violation of academic integrity on the part of the student shall fall under any of the below mentioned categories:
1. Plagiarism
2. Malpractice
3. Ghost Writing
4. Collusion
5. Other cases
If the student fails a module and has a proven case of academic integrity violation in this module, the student is required to re-register the module. This is applicable to first and second offenders of plagiarism.
1. Plagiarism
A. First offence of plagiarism
I. If a student is caught first time in an act of plagiarism during his/her course of study in any assignment other than project work, the student will be allowed to re-submit the assignment once, within a maximum period of one week. However, a penalty of deduction of 25% of the marks obtained for the resubmitted work will be imposed.
II. Period of re-submission: The student will have to re-submit the work one week from the date he or she is advised to re-submit.
III. If the re-submitted work is also found to be plagiarized, then that assessment will be awarded a zero mark. Re-submission of the work beyond the maximum period of one week will not be accepted and the assessment will be awarded a zero mark.
B. Second offence of plagiarism
If any student is caught second time in an act of plagiarism during his/her course of study (in a subsequent semester), the student will directly be awarded zero for the work in which plagiarism is detected. In such cases, the student will not be allowed to resubmit the work. A warning of
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 4 of 9
suspension shall be issued, and student has to sign an undertaking and undergo counselling session in such cases.
2. Malpractice/Ghostwriting/Collusion
A. First offence of Malpractice/Ghostwriting/Collusion
If a student is caught in an act of Malpractice/Ghostwriting/Collusion for an assessment component irrespective of coursework or end semester, the student shall fail the module and shall be required to re-register the module
B. Second Offence of Malpractice/Ghostwriting/Collusion
If a student is caught a second time in an act of Malpractice/Ghostwriting/Collusion for an assessment component irrespective of coursework or end semester, the student shall fail the module. A warning of suspension shall be issued, and student has to sign an undertaking and undergo counselling session in such cases.
3. Third Offence of Academic Integrity Violation
If a student is caught a third time in an act of Academic Integrity Violation for an assessment component irrespective of coursework or end semester (in a subsequent semester), the student shall fail the module and also shall be suspended for one semester from the College, as recommended by institutional level academic committee, Chaired by the Associate Dean, Academic Affairs.
4. Fourth Offence of Academic Integrity Violation:
If a student is caught a fourth time in an act of Academic Integrity Violation for an assessment component irrespective of coursework or end semester (in a subsequent semester), the student shall fail the module and also shall be expelled from the College, as recommended by institutional level academic committee, Chaired by the Associate Dean, Academic Affairs.
5. Other cases
If a student commits an act of academic integrity violation as per the definition of “other cases” mentioned in the previous section or of a different nature, student’s case shall be forwarded to an institutional level academic committee, Chaired by the Associate Dean, Academic Affairs. The committee shall investigate the case by means of a viva and/or a disciplinary hearing and shall take appropriate decision. The penalty that can be granted to a proven case of academic integrity violation which falls in this category of “other cases” can be a warning/component zero/ module fail/suspension/expulsion depending on the nature and gravity of the offence.
6. Types/Variations of Cases:
I. If plagiarism is detected in any component of one assessment, the deduction in marks will be applicable for the whole assessment, even if only the component or part submission alone needs to be resubmitted.
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 5 of 9
II. If plagiarism is detected in a group assessment, all students of the group will be considered as having committed an act of plagiarism and the policy will then be applied to all students
III. If plagiarism is detected in any component of a group assessment, the deduction in marks will be applicable for the whole assessment even if only the component or part submission alone needs to be resubmitted.
All students of the group would be considered as having committed an act of plagiarism and the policy will then be applied to all the students of the group.
IV. If the assessment consists of components or part submissions that could be a group assessment component (e.g. group assignment) and an individual assessment component (e.g. individual reflection), the following will be applicable:
a. If plagiarism is detected in the group assessment component, all students of the group will be considered as having committed an act of plagiarism, The policy will then be applied to all students of the group. Group assessment component will be resubmitted as per the policy.
b. If plagiarism is detected in the individual assessment component, the individual assessment component will be resubmitted and the policy will then be applied to that student alone.
c. For both (a) and/or (b), the deduction in marks will be applicable for the whole assessment.
* for further details Refer to MEC Student Academic Integrity Policy in Student Handbook.
2. Late Submission Regulations:
It is the students’ responsibility to check all relevant timelines related to assessments.
As per the Assessment Policy at MEC, late submissions are allowed for one week (5 working days) for all UG modules with a penalty. In such cases, a deduction of 5% of the marks obtained for the submitted work shall be imposed for each working day following the last date of submission till the date of actual submission. Assessment documents submitted beyond a period of one week (5 working days) after the last date of submission will not be accepted and will be awarded a zero for that assessment. In cases where the submission has been delayed due to extenuating circumstances, the student may be permitted to submit the work without imposing the late submission policy stated above. The extended period of submission will be one week from the original last date of submission. In such cases, the student is expected to submit the supporting certificates on or before the original last date of submission of the assessment and the decision of extension rests with faculty responsible for the assessment .The late submission policy shall be applied if the student fails to submit the work within one week of the original last date of submission.
Students may contact their teachers for clarification on specific details of the submission time if required.
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 6 of 9
3. Research Ethics and Biosafety Policy
To protect and respect the rights, dignity, health, safety, and privacy of research subjects involved including the welfare of animals and the integrity of environment, all student projects are expected to be undertaken as per the MEC Research Ethics and Biosafety Policy. Accordingly the following shall apply.
 Research and other enterprise activities shall be conducted by maintaining the high ethical standards consistent with national and international standards and conventions.
 Any research at MEC that is categorized as high-risk research shall be subject to review and approval by the Research Ethics and Biosafety Committee.
 Research activities involving collection of human or animal tissues and manipulation of microbial, animal or plant cells shall be subject to review and approval by the Research Ethics and Biosafety Committee.
 Participants involved in research must be informed about the purpose of research and intended uses of research findings. Written consent must be obtained from people involved prior to the commencement of research.
 Data obtained from participants must be treated with high confidence and should be used only for the intended purpose of research.
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 7 of 9
Assessment Evaluation Criteria
Classification And % Range <to be given as per requirement> Reflection and critical analysis. Knowledge and Understanding/ Application of Theory Evidence of Reading Referencing and Bibliography Presentation, Grammar and Spelling Outstanding
Highly competent analytical skills and reflective practice, demonstrating personal learning and growth, insight into required professional values and principles and professional development planning.
Extensive knowledge and depth of understanding of principles and concepts and /or outstanding application of theory in practice.
Evidence of reading an extensive range of educational literature/research and where applicable workplace strategies, policies and procedures.
Accurate referencing and bibliography correctly using appropriate referencing style
Excellent presentation, logically structured, using correct grammar and spelling, excellent cross-referencing and links to supporting evidence Excellent
Strong analytical skills and reflective practice used, demonstrating personal learning and growth, insight into required professional values, principles and competencies and professional development planning.
Excellent knowledge and understanding of principles and concepts and /or excellent knowledge and understanding of the application of theory in practice
Evidence of reading a wide range of educational literature/research and where applicable, workplace strategies, policies and procedures.
Appropriate referencing and bibliography correctly using appropriate referencing style
Good presentation, competently structured, using correct grammar and spelling, clear and easy to use links to supporting evidence Very Good Quality
Good use of analytical skills and reflective practice demonstrating personal learning and growth, insight into required professional values, principles and competencies and professional development planning.
Good knowledge or key principles and concepts and/or good knowledge of the application of theory in practice
Evidence of reading a good range of educational literature/research and where applicable workplace strategies, policies and procedures.
Generally well referenced with correct use of the appropriate referencing style
Reasonable presentation, completely structured, acceptable grammar and spelling, acceptable links to supporting evidence Good (Acceptable)
Acceptable use of analytical skills and reflective practice demonstrating personal learning and growth, insight into required professional values, principles and competencies and professional development planning.
Acceptable knowledge of key principles and concepts and/or knowledge of the application of theory in practice
Evidence of reading an appropriate range of educational literature/research and where applicable, relevant workplace policies and procedures
Adequate referencing. Generally accurate use of appropriate referencing style
Adequate presentation and structure, acceptable grammar and spelling, adequate links to supporting evidence Adequate/ Satisfactory
Adequate use of analytical skills and reflective practice demonstrating personal learning and growth, insight into required professional values, principles and competencies and professional development planning.
Adequate knowledge of key principles and concepts and/or satisfactory evidence of the application of theory in practice.
Evidence of minimal reading of educational literature/research and where applicable relevant workplace policies and procedures
Adequate referencing. Appropriate referencing style used but may contain some inaccuracies.
Weak presentation , satisfactory structure, grammar and spelling, links to supporting evidence Weak /Poor (all learning outcomes not adequately met)
Little use of analytical skills and reflective practice demonstrating personal learning and growth, insight into required competencies and/or professional development planning. Professional values and principles not reflected in the submission.
and/or
Insufficient/no use of analytical skills and reflective practice demonstrating personal learning and growth, insight into required competencies and professional development planning
Little evidence of knowledge of key principles or concepts and/or little evidence of the application of theory in practice
and/or
No evidence of knowledge of key principles or concepts and/or no evidence of application of theory in practice
Little or no evidence of reading outside of the course textbook and/or reference to relevant work place policies and procedures
and/or
No evidence of reading outside of the course textbook and/or reference to relevant workplace policies and procedures
Little or no referencing, incorrect style, or very inaccurate use of appropriate referencing style
Poor presentation, grammar and spelling, links to supporting evidence
and/or
Unacceptable presentation, grammar and spelling, structure is very poor, links to supporting evidence
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 8 of 9
Assessment Sheet – Basic Assignment Analysis
Student Id. and Name:
Deliverables
Aspects
0-10
11-30
31-40
Marks
Task 1
Client Server Architecture
No answer or irrelevant answer
Or very basic discussion.
Basic discussions with appropriate understanding of the concepts. Plus an average reflective summary covering most of the concepts.
Excellent way of discussion the simulation with relevant examples/diagrams and with appropriate references; Plus An excellent reflective summary.
Deliverables
Aspects
0-5
6-20
21-30
Marks
Task 2
Manage database instances and storage
No answer
Or
very basic discussion
without SQL
Adequate answers with/without diagram. SQL with/without discussions
Good level of discussions with diagram, SQL, appropriate examples; references and citations or
Excellent level of discussions with diagram, SQL, relevant examples and appropriate references and citations
Database Administration (COMP 30021) – Summer – 2020 – CW2 (Assignment) – All – QP
MEC_AMO_TEM_034_01 Page 9 of 9
Deliverables
Aspects
0-5
6-12
13-20
Marks
3. a.
Distributed database concepts.
No answer
Or
very basic discussion
Adequate answers with/without diagram.
Good level of discussions with diagram, appropriate examples; references and citations or
Excellent level of discussions with diagram, SQL, relevant examples and appropriate references and citations
3 b.
0-3
4-7
8-10
Database link
No answer
Or
very basic discussion
without SQL
Adequate answers with/without SQL with/without discussions
Good level of discussions with SQL, appropriate examples; references and citations or
Excellent level of discussions with diagram, SQL, relevant examples and appropriate references and citations
Detailed Comments / Feedback:
Signature of Faculty
Total Marks
Penalty
Final Marks

Calculate a fair price for your paper

Such a cheap price for your free time and healthy sleep

1650 words
-
-
Place an order within a couple of minutes.
Get guaranteed assistance and 100% confidentiality.
Total price: $78
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?