University : Middle East College UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : COMP1011
Assignment Task :

Module Learning Outcomes
The following LOs are achieved by the student by completing the assignment successfully
1. Create and maintain a database server
2. Design an enterprise data model that incorporates all of the data used by an organisation's business processes
3. Manage database network (client/ server) connections using Database Net Services

Assignment Objective
As a Database Administrator, to configure the database server, choose and apply skills relevant client/server environment and manage the data in an organization’s business processes.

Assignment Tasks
1.
Submit a work proposal for this assignment on or before 08/05/2020, 23:59 Hrs. which must include:
Understanding of deliverables – a detail description of deliverables.
General overview of proposed plan - initial understanding of solution to task2 to task-4.
Timeline for completion of the given tasks.

2. Using suitable examples of your own, discuss the need of database logical structures and their significance in effective management of database.
You should not simply discuss the concepts of logical structures, however, should focus on why it is not possible to maintain a database with just physical structures i.e. datafiles, log files etc. Solution should emphasize on the need of having tablespaces, segments, extents and data blocks and their usage by the Database Administrator in effective management of database.
Note: You may relate your examples with a database of any organization. No need to name any organization, you may use a bank, university, hypermarket etc.

3. As a Database Administrator, provide the solutions for the following with a brief elaboration of each SQL command. Ensure to follow Optimal Flexible Architecture (OFA) guidelines. SQL commands should be executed and screenshots should be included in the solution.
a. Create a tablespace with at least two optional features.
b. Create a user and assign the tablespace created in task-3a. User should be given privileges to perform the SQL commands given in task-3c.

c. For any relevant organization of your choice (e.g. bank, airlines, hypermarket etc.), create any two relevant tables of your choice, ensure that the table and the columns you choose are related with the chosen organization or scenario. The tables must be satisfying the following criteria:
i. Ensure to use overall at least four datatypes including a Date datatype.
ii. Demonstrate the usage of five data integrity constraints.
iii. Insert at least three relevant records in each of the two tables.

d. Choosing any one table created in the task-3c, demonstrate the usage of database object sequence. Solution must include the SQL commands to create the sequence and inserting at least two records using the sequence.

e. For the tablespace created in task-3a, list any six operations that can be performed by the Database Administrator in managing the tablespace. Your solution must include the SQL commands preferably as screenshots, to perform the listed operations and brief elaboration of, each SQL command indicating its impact on the database and/or user. In the elaboration part, you must choose any examples of your choice.
 

4. Operation of database client/server systems requires a networked environment where the processing of an application is split between the client and the server.
In view of the above context, as a Database Administrator, answer the following:
a. Using valid examples relating to real-time scenarios, in your own words, discuss the ideal situations to use two-tier and three-tier client/server database environments.

b. Discuss the role of client and server in a database client/server environment. Your solution must include relevant examples.  
 

Rules & Regulations:

  • All resources should be included in the references and 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 dates informed earlier.

 

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.
  • 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.
  • Code should not be copy and paste from other 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 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.
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.

 

This IT / Computer Science Assignment has been solved by our IT/ Computer Science Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : June 02nd, 2019

Whatsapp Tap to ChatGet instant assistance