InstructionstoStudent

• Answerallthe
• Deadlineofsubmission:19/05/25,23:59
• Themarksreceived on the miniproject willbescaled down to theactualweightage of the assignment which is 70% marks.
• Formative feedback on the complete mini-project draft will be provided if the draft is submitted at least 10 days before the final submission date.
• Feedbackwillbeprovidedwithin15daysafter

ModuleLearningOutcomes

ThestudentachievesthefollowingLO`sbycompletingtheminiprojectsuccessfully

1. CREATEANDMAINTAINADATABASESERVER
2. MANAGEDATABASE NETWORK(CLIENT/SERVER)CONNECTIONSUSINGDATABASENETSERVICES
3. IMPLEMENTINGDATABASESECURITYPOLICIES

MiniProjectObjective

Thestudentsareprovidedwiththeopportunitytoselectappropriateproblemsanduserelevanttoolsand techniquestoimplementdatabaseadministrationandsecurityskills.Studentswillformagroupof3to4 students to work on this assessment. The presentation will be conducted to assess the individual contribution and originality of work and quality of analysis.

Theorganizationofthereportshouldbeasfollows:

1. Tableof Contents
2. Introduction(scopeoftheworkanditsimportance)
3. Solutionofthetaskswithcode(ifapplicable)
4. References

MiniProjectRequirements:

1. Designandimplementationofthedatabasemanagementsystem
2. Report
3. Presentation Task1a(GroupTask)
4. OrganizationSelectionandIntroduction:

Asateam,selectonetypeoforganizationfromthefollowinglist:

CareerDevelopmentInstitute Art and Design Academy Technical Training School Teacher Training College

Onceselected,provideaconciseintroductiontotheprimaryfunctionsofthechosenorganization. Rationale for database requirements with justification and citation. Also, allocate individual tasks to each member based on their specific roles.

(5marks)

1. DatabaseRequirementsCollection:

Analyzetheoperationalanddatamanagementneedsofyourchosenorganizationtoidentifyit primary database requirements: such as data storage, access, and security.

In addition, provide a rationale for each identified requirement by referring to relevant literature, standards, or best practices. (10marks)

iii.Oracle21cInstallation:

InstallOracle21csoftwareanddocumenteachinstallationstepwithscreenshotsand explanations

(05marks)

1. OracleNetServicesGuide:

Draftadetailedstep-by-stepguideforestablishingaclient-serverconnectionusingOracleNet Services.

(5marks)

1. TablespaceManagement:

Aftercreatingthetablespace,discussandexecuteatleastfouressentialtablespacemanagement commands.

(2+8=10Marks)

Task1b(IndividualTask)

Asanindividual,basedontheselectedorganization,createoneuserandoneroleintheselected organization and assign appropriate privileges to the role. Additionally, one profile should be created and assigned to user based on the following criteria:

2limitationsonresourcesand2limitationsonpasswords.

Implementtwousermanagementcommandsrelatedtothecreateduserandrole.

(4+6+5=15marks)

Task1c(IndividualTask)

Asanindividual,basedontheselectedorganization,createaminimumoftworelevanttablesfor the scenario. Insert values in those tables using SQL Loader (Excel to tables). Create a complex view that limits access to sensitive data, displaying only essential, non-sensitive information.

(5+5+5=15marks)

Task1d(IndividualTask)

Use Flask/Django with SQLite/PostgreSQL/MySQL to implement the previous task. Ensure that youcreatethenecessarytables,insertvaluesindatabaseandgenerateacomplexviewtorestrict access to sensitive data while displaying essential information.

(3+3+4=10marks)

Task1e(IndividualTask)

Explain the conceptof a deadlock in Oracle , simulate a deadlock scenario using SQL commands, and outline the process to identify and prevent future deadlocks. Assuming tables you created and some relevant transactions.

(3+3+4=10marks)

2.Report(Group):

Submitthereportformattedaspertheguidelinesgiven.Yoursolutionmustincludethenecessary SQL commands like screenshots and brief explanation for each of the steps. Proper documentation of the above points is expected.

5marks

3.Presentation(Individual):

Studentmustbepreparedtopresentthemini projectindividuallyandanswerallthe questions from the examiner.

• Presentationusing
• Codingdiscussion
• Technicaldemonstration Total:10marks

SubmissionInstructions

Your answer should be in the form of a report, which should be submitted in MEC future in the link provided.

AssessmentSheetAssignmentAnalysis(COMP30021.1-Semester:SPRG2025)

Rules&Regulations:

• AllresourcesshouldbecitedusingAPA7theditionreferencing
• The final assignment must have a Title page, Table of Contents, References/ bibliography using APA 7th edition referencing style, and page numbers.
• Title Page must have a mini project name, Module name, Session, group members names and IDs, and the name of the faculty.
• SoftcopyinwordformatistobesubmittedthroughtheTurnitinlinkon
• Clear label and introduction of each task followed by the coding of that task. Include comments wherever possible to enhance the clarity of your coding.
• Presentationwillbeconductedaftertheminiprojectsubmissionasperthedatesinformed

Guidelines:

• Assignmentmustbecomputer
• Font-TimesNewRoman
• FontStyle -Regular
• Font-Size -12
• HeadingshouldbewithFontSize14,Bold,Capital,and
• Eachstudenthastodotheminiprojectbothindividuallyandin
• Sourcecodemustbetypedandimageformatnot
• Handwrittenminiprojectwillnotbeaccepted
• You can refer to books in eLibrary or use internet resources. But you should not cut and paste material from the internet nor provide photocopied material from books. The assignment answersshouldbe inyourownwordsafterunderstandingthe matterfromthe above

AssessmentEvaluationCriteria

ImportantPoliciestobefollowed

1.StudentAcademicIntegrityPolicy*:

• MEC upholds the spirit of academic integrity in all forms of academic work and any form of violationofacademicintegrityshallinvitesevereAnybenefitobtainedbyindulging in the act of violation of academic integrity shall be cancelled.
• MEC also reserves the right to notify the appropriate law enforcement authorities of any unlawful activity and to cooperate thereafter in any investigation of such activity.
• Faculty can conduct a viva to investigate and ascertain that the work submitted is students own work as per the guidelines for the same. A student can be given a maximum of 2 chances to attend the viva in such cases. It is expected that the student attends the viva during the first chance itself unless due to extenuating circumstances. If the student does not attend the viva in spite of being given 2 chances and fails to submit valid reasons, he/shewillbeawardedafailinthemoduleandthisshallbecountedasacaseofacademic integrity violation.

Allcasesofviolationofacademicintegrityonthepartofthestudentshallfallunderanyofthebelow mentioned categories:

1. Plagiarism
2. Malpractice
3. GhostWriting
4. Collusion
5. Othercases

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 offence of academic integrity violation of plagiarism type

a.FirstOffenceofAcademicIntegrityViolation:

1. Plagiarism

1. If a student is caught first time in an act of academic integrity violation during his/her course of study inany assignment other thanproject work and if the type of violation is plagiarism, then the student will be allowed to re-submit the assignment once as per the period allowed for re submission However, a penalty of deduction of 25% of the marks obtained for the resubmitted work will be
2. Period of re-submission: The student will have to re-submit the work within one week (5 working days) from the date he or she is advised to re-submit.
3. Re-submissionof theworkbeyond the allowed periodof resubmission will not be accepted and the assessment will be awarded a zero mark.
4. Ifthere-submittedwork(withintheallowedperiodofresubmission)isalsofound to be plagiarized, then that assessment component will be awarded a zero mark. It shall also contribute to the total count of academic integrity violation for that
5. IfplagiarismisdetectedinUGProjectwork(Project1,ProjectPlanningandProject DesignandImplementation),theaboveclausesdonotapply,andtheworkwillbe summarilyInthesecasesthestudentwillbeawardedafail(F)gradeand is required to reregister the module.

ii.Malpractice/Ghostwriting/Collusion

Ifastudentiscaughtfirsttimeinanactacademicintegrityviolationduringhis/hercourse of study for an assessment component irrespective of coursework or end semester and if the type of violation isMalpractice/Ghostwriting/Collusion, then the student shall fail the module.

b.SecondOffenceofAcademicIntegrityViolation:

1. Plagiarism

1. Ifanystudentiscaughtsecondtimeinanactofacademicintegrityviolationduring his/her course of study and if the type of violation is plagiarism, then the student will not be allowed to resubmit the work, and s/he will directly be awarded zero for the work in which plagiarism is detected.
2. Thestudentshallalsoreceiveawarningofsuspensioninsuch

ii.Malpractice/Ghostwriting/Collusion

1. If a student is caught a second time in an act academic integrity violation for an assessmentcomponentirrespectiveofcourseworkorendsemesterandifthetype of violation is Malpractice/Ghostwriting/Collusion, then the student shall fail the module.
2. Thestudentshallalsoreceiveawarningofsuspensioninsuch

c.ThirdOffenceofAcademicIntegrityViolation:

1. 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 then the student shall fail the module and also shall be suspended for one semester from the College, once the academic integrity violation case is confirmed by Institutional Assessment Review Committee.
2. The student shall be suspended for the immediate subsequent semester and can register for modules only after having served the suspension period fully. This is also applicable for semesters offered in block mode.
   1. Duringthesuspensionperiod,thestudentshallhavetomandatorilycompleteacourse on academic integrity/writing before s/he can register for any modules.
3. During the period of suspension, the student shall be allowed to attempt supplementaryexaminationsifs/heiseligiblefortheS/heshallalsobeallowed accesstoallcollegefacilitiespermittedforaregularstudentexceptforregisteringthe modules.

d.FourthOffenceofAcademicIntegrityViolation:

1. If a student is caught a fourth time in an act of academic integrity violation for an assessmentcomponent irrespectiveofcourseworkorendsemester, the studentshall failthemoduleandalsoshallbeexpelledfromtheCollege,oncethecaseisconfirmed by Institutional Assessment Review Committee.
2. The student shall be expelled from the college and all access to the college facilities and premises shall cease to exist. The documents shall be released only after getting the NOC (No Objection Certificate) from Registration Office.
3. On termination, the student shall not be refunded any fees paid for the academic semester in which academic integrity violation was observed.

e.Othercases

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, students case shall be forwarded to an Institutional Assessment Review Committee, Chaired by the Associate Dean,AcademicAffairs.Thecommitteeshallinvestigatethecasebymeansofavivaand/or a hearing of the parties concerned if required 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.

f.Types/VariationsofcasesofPlagiarismandassociatedactions

Type 1: In case plagiarism is detected in any component or part submission (submitted at different times) of one assessment (assignment), the deduction in marks will be applicable

forthewholeassessment(assignment),evenifonlythecomponentorpartsubmissionalone needs to be resubmitted.

Type2:Incaseplagiarismisdetectedinagroupassessment,allstudentsofthegroupwillbe consideredashavingcommittedanactofplagiarismirrespectiveofwhetherplagiarismison account of the act of all or a few or only one member. The policy will then be applied to all students.

If some students in the group are eligible to re-submit (first offence) and others are not eligible, only eligible students will be allowed to re-submit within a period of one week and thepenaltywillbeappliedasperthepolicyforeachstudentaccordingtohis/herhistoryof violations.

Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in anycomponent or part submission (submitted at different times) of a group assessment (assignment), the deductioninmarkswillbeapplicableforthewholeassessment(assignment),evenifonlythe component or part submission alone needs to be resubmitted. All students of the group would be considered as having committed an act of plagiarism irrespective of whether plagiarismisonaccountoftheactofallorafeworonlyonemember.Thepolicywillthenbe applied to all the students of the group.

If some students in the group are eligible to re-submit (first offence) and others are not eligible, only eligible students will be allowed to re-submit within a period of one week and thepenaltywillbeappliedasperthepolicyforeachstudentaccordingtohis/herhistoryof violation.

Type 4: Variation of Type 1 and Type 2: In cases where 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:

1. If plagiarism is detected in the group assessment component, all students of the group will be considered as having committed an act of plagiarism, irrespective of whether plagiarism isonaccountoftheactofallorafeworonlyoneThepolicywillthenbeappliedto allstudentsofthegroup.Insuchcasesthegroupassessmentcomponentwillberesubmitted.

If some students in the group are eligible to re-submit (first offence) and others are not eligible, only eligible students will be allowed to re-submit within a period of one week and the penalty will be applied for each student according to his / her history of violation.

1. If plagiarism isdetected inthe individualassessment component, the individual assessment component will be resubmitted - if the student is eligible for resubmission-. The policy will then be applied to that student alone.
2. In both cases (a) and/or (b), the deduction in marks will be applicable for the whole assessment (assignment).

g.Types/VariationofCasesofMultipleOffences

Ifstudentiscaughtwithmultipleviolationsofsameordifferentnatureindifferentmodules of the same semester, they will be considered as one offence and student will be penalized for each violation according to the type of the offence.

If student is caught with multiple violations of sameor different nature in the samemodule of the same semester, then they will be considered as different offences and each will contributetotheoverallcountofAIV.Thestudentthenshallbepenalized foreachviolation according to the count and type of each offence.

*ForfurtherdetailsRefertoMECStudentAcademicIntegrityPolicyinStudentHandbook.

2.LateSubmissionRegulations:

Itisthestudentsresponsibilitytocheckallrelevanttimelinesrelatedtoassessments.

AspertheAssessmentPolicyatMEC,latesubmissionsareallowedforoneweek(5workingdays) forallUGmoduleswithapenalty.Insuchcases,adeductionof5%ofthemarksobtainedforthe submitted work shall be imposed for each workingdayfollowingthelastdateofsubmission tillthedateofactualsubmission. Assessment documents submitted beyond a period of one week(5workingdays)afterthelastdateofsubmissionwillnotbeacceptedandwillbeawarded 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 ofextensionrestswithfacultyresponsiblefortheassessment.Thelatesubmissionpolicyshallbe applied if the student fails to submit the work within one week of the original last date of submission.

Studentsmaycontacttheirteachersfor clarificationonspecificdetailsofthesubmissiontimeif required.

Itisthestudentsresponsibilitytocheckallrelevanttimelinesrelatedtoassessments.

Late submission penalty for PG modules shall be imposed 10?duction of the marks obtained forworksubmittedupto1week(5workingdays)aftertheduedateforsubmissionandforwork submitted after this, but up to 2 weeks (10 working days) late, student will losea further 10% of the obtained mark (i.e. 20% overall). Work tendered for submission more than 2 weeks (10 working days) after the due date will not be accepted and an absence will be recorded for the assessment concerned. This will count as a failed attempt and may result in failing the module overall.

Studentsmaycontacttheirteachersforclarificationonspecificdetailsofthesubmissiontimeif required.

3.ResearchEthicsandBiosafetyPolicy

Toprotectandrespecttherights,dignity,health,safety,andprivacyofresearchsubjectsinvolved including the welfare of animals and the integrity of environment, all student projects are expected to be undertakenas per theMEC 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.
• Researchactivitiesinvolvingcollectionofhumanoranimaltissuesandmanipulationofmicrobial, animalorplantcellsshallbesubjecttoreviewandapprovalbytheResearchEthicsandBiosafety
• Participantsinvolvedinresearchmust beinformedabout the purposeofresearchandintended 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.