MITS4003 Database Systems Assignment 2

MITS4003 Database Systems Assignment

FEBRUARY 2023

Overview

In this assessment, you will apply normalization techniques to evaluate the entities designed in Assessment 1 and ensure that all relations are normalized to at least the third normal form (3NF).

Note: This is an individual assignment carrying 10% of the total mark in this unit. The submission deadline is end of the week of session 9.

Objectives(s)

This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve students’ skills to analyze organization database requirements, normalize a database and use data manipulation language to manage a database. This assessment covers the following LOs.

  • Derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements; further use of data manipulation language to query, update, and manage a database
  • Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying normalization techniques.
  • Design and build a database system using the knowledge acquired in the unit as well as through further research on recent trends to demonstrate competence in various advanced tasks with regard to modelling, designing, and implementing a DBMS including Data warehousing, Data Management, DB Security.

Assessment Criteria

This assessment is designed to assess student’s knowledge, skill and application of

knowledge and skill in relation to

  1. Design guidelines for relational schemas.
  2. Database design process.
  3. Application of normalization techniques.
  4. Building a database.
  5. Data manipulation language.

Task 1                                                                                                                   (Weighting 20%)

Ensure all tables designed in Assignment 1 satisfies the design guidelines for relational schemas.

  • Identify any non-semantic columns in each table and transform tables where the tables should have semantic columns.
  • Identify tables which could possibly have any anomalies and remove all anomalies from the tables.
  • Identify any columns which may have frequently null values and remove or revised those columns. If nulls are unavoidable, then make sure that they apply in exceptional cases only.
  • Identify any possibility of spurious tuples and avoid such relations that contain matching columns that are not primary key and foreign key combination.

Task 2                                                                                                                   (Weighting 30%)

Apply normalization technique on all tables designed in Assignment 1.

  • Identify any repeating group of columns in each table and transform unnormalized tables into tables that are in 1st Normal Form.
  • Identify any partial dependencies in each table and transform 1NF table into tables that are in 2nd Normal Form.
  • Identify any transitive dependencies in each table and transform 2NF table into tables that are in 3rd Normal Form.

Please note: Your tables must be in 3NF.

Task 3                                                                                                                   (Weighting 50%)

This task must execute on MS SQL Server and be able to be demonstrated. SQL code required (Use MS SQL Server):

  • Write a Create database statement to create a database and also, write a Create Table statement for all tables including integrity constraints.
  • INSERT INTO statements for populating the database.
  • You must at least enter 5 records for each table.
    • Data may need to be inserted in a particular order to comply with the integrity constraints.
  • SELECT statement that will list all houses / apartments that have not been rented.
  • The details may be included like house id, classification, number of bedrooms, number of washrooms, garden, parking for number of cars, rent per day, etc.
  • SELECT statement that will produce the total amount paid per customer.
  • The details may be included customer id, registration date, customer name, customer address, customer phone number and total amount paid, etc.

General Instructions

  • Your submission should be clear and concise and in your own words.
  • One submission per student.
  • Use headings to guide the marker and include tables or diagrams where required.
  • The referencing style must follow the IEEE referencing style.

Submission Guidelines

  • Follow the link in Moodle to upload your submission on or before the deadline. All submissions must be done in LMS using the respective link provided.
  • Submission must be made by the due date and time as determined by the unit facilitator.

Submissions made after the due date/time will be penalized at the rate of 20% per day (including Saturday, Sunday and public holidays).

  • Incidence of plagiarism will be penalized based on VIT Academic Integrity Policy and Procedure.
  • Submit your work in a word document file named ‘Student_Id_MITS4003_A2’.

Marking Guide:

Marking Guide: Case Study 1UnacceptableAcceptableGoodExcellent
1.      Task 1   (Weighting 20%) 
1.1 Semantic columns (Weighting 5%)Does not adequately identify non-semantic columns.Identify a few of the non-semantic columns and precisely transform tables that are having semantic columns.Correctly identify most of the non- semantic columns and precisely transform tables that are having semantic columns.Correctly identify all of the non-semantic columns and precisely transform tables that are having semantic columns.
1.2 Anomalies (Weighting 5%)Does not adequately identify anomalies.Identify a few of the anomalies and remove those anomalies from the tables.Correctly identify most of the possible anomalies and remove those anomalies from the tables.Correctly identify all of the possible anomalies and remove those anomalies from the tables.
1.3 Null values (Weighting 5%)Does not adequately identify columns which may have frequently null values.Identify a few of the columns which may have frequently null values and remove or revise those columns.Identify most of the columns which may have frequently null values and remove or revise those columns.Identify all of the columns which may have frequently null values and remove or revise those columns.
1.4 Spurious tuples (Weighting 5%)Does not adequately identify possible spurious tuples.Identify a few of the possible spurious tuples and avoid those relationships.Identify most of the possible spurious tuples and avoid those relationships.Identify all of the possible spurious tuples and avoid those relationships.
2.      Task 2   (Weighting 30%) 
2.1 1NF (Weighting 15%)Does not adequately identify repeating group of columns and not transform unnormalised tables into 1NF tables.Identify a few of the repeating group of columns and correctly transform a few of the unnormalised tables into 1NF tables.Identify most of the repeating group of columns and correctly transform most of the unnormalised tables into 1NF tables.Identify all of the repeating group of columns in each table and correctly transform all of the unnormalised tables into 1NF tables.
2.2 2NF (Weighting 10%)Does not adequately identify partial dependencies and not transform 1NF tables into 2NF tables.Identify a few of the partial dependencies and correctly transform a few of the 1NF tables into 2NF tables.Identify most of the partial dependencies and correctly transform most of the 1NF tables into 2NF tables.Identify all of the partial dependencies in each table and correctly transform all of the 1NF tables into 2NF tables.
2.3 3NF (Weighting 5%)Does not adequately identify transitive dependencies and not transform 2NF tables into 3NF tables.Identify a few of the transitive dependencies and correctly transform a few of the 2NF tables into 3NF tables.Identify most of the transitive dependencies and correctly transform most of the 2NF tables into 3NF tables.Identify all of the transitive dependencies and correctly transform all of the 2NF tables into 3NF tables.
3.      Task 3   (Weighting 50%) 
3.1 Create table (Weighting 10%)Incorrect syntax.Partially correct syntax.Syntactically correct code and correctly created most tables.Correctly created all tables.
3.2 Insert statements (Weighting 10%)Incorrect syntax.Partially correct syntax and very few records are inserted as per the requirements.Syntactically correct and most of the records are inserted as per the requirements.Code is correct and all records are inserted as per the requirements.
3.3 SELECT statement that will list all houses / apartments that have not been rented (Weighting 15%)Incorrect syntax.Partially correct syntax and gives output somewhat near to requirements.Syntactically correct and gives output very near to requirements.Code is correct and used JOIN, etc. and gives the required output
3.4 SELECT statement that will produce the total amount paid per customer. (Weighting 15%)Incorrect syntax.Partially correct syntax and gives output somewhat near to requirements.Syntactically correct and gives output very near to requirements.Code is correct and used JOIN, etc. and gives the required output
Order Now

Get expert help for MITS4003 Database Systems Assignment and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (November 3, 2024) MITS4003 Database Systems Assignment 2. Retrieved from https://universalassignment.com/mits4003-database-systems-assignment-2/.
"MITS4003 Database Systems Assignment 2." Universal Assignment - November 3, 2024, https://universalassignment.com/mits4003-database-systems-assignment-2/
Universal Assignment May 5, 2023 MITS4003 Database Systems Assignment 2., viewed November 3, 2024,<https://universalassignment.com/mits4003-database-systems-assignment-2/>
Universal Assignment - MITS4003 Database Systems Assignment 2. [Internet]. [Accessed November 3, 2024]. Available from: https://universalassignment.com/mits4003-database-systems-assignment-2/
"MITS4003 Database Systems Assignment 2." Universal Assignment - Accessed November 3, 2024. https://universalassignment.com/mits4003-database-systems-assignment-2/
"MITS4003 Database Systems Assignment 2." Universal Assignment [Online]. Available: https://universalassignment.com/mits4003-database-systems-assignment-2/. [Accessed: November 3, 2024]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

ECON20001 Assignment #2

Assignment #2 Due Monday September 30th 2pm AEST The assignment is marked out of 25 points. The weight for each part is indicated following the question text. Style requirements: This assignment requires the submission of a spreadsheet. Please keep THREE decimal places in your answers and include your spreadsheet as

Read More »

RES800 Assessment 1 – Research Question and Literature Review

Subject Title Business Research Subject Code RES800 Assessment Title Assessment 1 – Research Question and Literature Review Learning Outcome/s     Utilise critical thinking to analyse managerial problems and formulate relevant research questions and a research design   Apply research theories and methodologies to assist in developing a business research

Read More »

Assessment Task 2 Health advocacy and communication plan

Assessment Task 2 Health advocacy and communication plan Rationale and multimedia plan presentation Submission requirements Due date and time:         Rationale: 8pm AEST Monday 23 September 2024 (Week 11) Multimedia plan presentation: 8pm AEST Monday 30 September 2024 (Study Period) % of final grade:         50% of overall grade Word limit: Time

Read More »

MLI500 Leadership and innovation Assessment 1

Subject Title Leadership and innovation Subject Code MLI500 Assessment Assessment 1: Leadership development plan Individual/Group Individual Length 1500 words Learning Outcomes LO1 Examine the role of leaders in fostering creativity and innovation LO5 Reflect on and take responsibility for their own learning and leadership development processes Submission   Weighting 30%

Read More »

FPC006 Taxation for Financial Planning

Assignment 2 Instructions Assignment marks: 95 | Referencing and presentation: 5 Total marks: 100 Total word limit: 3,000 words Weighting: 40% Download and use the Assignment 2 Answer Template provided in KapLearn to complete your assignment. Your assignment should be loaded into KapLearn by 11.30 pm AEST/AEDT on the wdue

Read More »

TCHR5001 Assessment Brief 1

TCHR5001 Assessment Brief 1 Assessment Details Item Assessment 1: Pitch your pedagogy Type Digital Presentation (Recorded) Due Monday, 16th September 2024, 11:59 pm AEST (start of Week 4) Group type Individual Length 10 minutes (equivalent to 1500 words) Weight 50% Gen AI use Permitted, restrictions apply Aligned ULOS ULO1, ULO2,

Read More »

HSH725 Assessment Task 2

turquoise By changing the Heading 3 above with the following teal, turquoise, orange or pink you can change the colour theme of your CloudFirst CloudDeakin template page. When this page is published the Heading 3 above will be removed, but it will still be here in edit mode if you wish to change the colour theme.

Read More »

Evidence in Health Assessment 2: Evidence Selection

Evidence in Health Assessment 2: Evidence Selection Student name:                                                                    Student ID: Section 1: PICO and search strategy Evidence Question: Insert evidence question from chosen scenario here including all key PICO terms.       PICO Search Terms                                                                                                                                                                                                          Complete the following table.   Subject headings Keywords Synonyms Population  

Read More »

Assessment 1 – Lesson Plan and annotation

ASSESSMENT TASK INFORMATION: XNB390 Assessment 1 – Lesson Plan and annotation This document provides you with information about the requirements for your assessment. Detailed instructions and resources are included for completing the task. The Criterion Reference Assessment (CRA) Marking Matrix that XNB390 markers will use to grade the assessment task

Read More »

XNB390 Task 1 – Professional Lesson Plan

XNB390 Template for Task 1 – Professional Lesson Plan CONTEXT FOR LESSON: SOCIAL JUSTICE CONSIDERATIONS: Equity Diversity Supportive Environment UNIT TITLE:    TERM WEEK DAY TIME 1   5           YEAR/CLASS STUDENT NUMBERS/CONTEXT LOCATION LESSON DURATION         28 Children (chl): 16 boys; 12

Read More »

A2 Critical Review Assignment

YouthSolutions Summary The summary should summarise the key points of the critical review. It should state the aims/purpose of the program and give an overview of the program or strategy you have chosen. This should be 200 words – included in the word count. Critical analysis and evaluation Your critical

Read More »

PUN364 – Workplace activity Assignment

Assessment 1 – DetailsOverviewFor those of you attending the on-campus workshop, you will prepare a report on the simulated simulated inspection below. For those of you who are not attending, you will be required to carry out your own food business inspection under the supervision of a suitably qualified Environmental

Read More »

FPC006 Taxation for Financial Planning

Assignment 1 Instructions Assignment marks: 95 | Referencing and presentation: 5 Total marks: 100 Total word limit: 3,600 words Weighting: 40% Download and use the Assignment 1 Answer Template provided in KapLearn to complete your assignment. Your assignment should be loaded into KapLearn by 11.30 pm AEST/AEDT on the due

Read More »

Mental health Nursing assignment

Due Aug 31 This is based on a Mental health Nursing assignment Used Microsoft word The family genogram is a useful tool for the assessment of individuals, couples, and families.  It can yield significant data and lead to important, new patient understandings and insights as multigenerational patterns take shape and

Read More »

Assessment 2: Research and Policy Review

Length: 2000 words +/- 10% (excluding references)For this assessment, you must choose eight sources (academic readings and policy documents) as the basis of your Research and Policy Review. You must choose your set of sources from the ‘REFERENCES MENU’ on the moodle site, noting the minimum number of sources required

Read More »

HSN702 – Lifespan Nutrition

Assessment Task: 2 Assignment title: Population Nutrition Report and Reflection Assignment task type: Written report, reflection, and short oral presentation Task details The primary focus of this assignment is on population nutrition. Nutritionists play an important role in promoting population health through optimal nutritional intake. You will be asked to

Read More »

Written Assessment 1: Case Study

Billy a 32-year-old male was admitted to the intensive care unit (ICU) with a suspected overdose of tricyclic antidepressants. He is obese (weight 160kg, height 172cm) and has a history of depression and chronic back pain for which he takes oxycodone. On admission to the emergency department, Paramedics were maintaining

Read More »

Assessment Task 8 – Plan and prepare to assess competence

Assessment Task 8 – Plan and prepare to assess competence Assessment Task 8 consists of the following sections: Section 1:      Short answer questions Section 2:      Analyse an assessment tool Section 3:      Determine reasonable adjustment and customisation of assessment process Section 4:      Develop an assessment plan Student Instructions To complete this

Read More »

Nutrition Reviews Assignment 2 – Part A and Part B

This assignment provides you with the opportunity to determine an important research question that is crucial to address based on your reading of one of the two systematic reviews below (Part A). You will then develop a research proposal outlining the study design and methodology needed to answer that question

Read More »

NUR332 – TASK 3 – WRITTEN ASSIGNMENT

NUR332 – TASK 3 – WRITTEN ASSIGNMENT for S2 2024. DESCRIPTION (For this Task 3, the word ‘Indigenous Australians’, refers to the Aboriginal and Torres Strait Islander Peoples of Australia) NUR332 Task 3 – Written Assignment – Due – WEEK 12 – via CANVAS on Wednesday, Midday (1200hrs) 16/10/2024. The

Read More »

NUR100 Task 3 – Case study

NUR100 Task 3 – Case study To identify a key child health issue and discuss this issue in the Australian context. You will demonstrate understanding of contemporary families in Australia. You will discuss the role of the family and reflect on how the family can influence the overall health outcomes

Read More »

NUR 100 Task 2 Health Promotion Poster

NUR 100 Task 2 Health Promotion Poster The weighting for this assessment is 40%. Task instructions You are not permitted to use generative AI tools in this task. Use of AI in this task constitutes student misconduct and is considered contract cheating. This assessment requires you to develop scholarship and

Read More »

BMS 291 Pathophysiology and Pharmacology CASE STUDY

BMS 291 Pathophysiology and Pharmacology CASE STUDY Assessment No: 1 Weighting: 40% Due date Part A: midnight Friday 2nd August 2024 Due date Part B: midnight Sunday 29th September 2024 General information In this assessment, you will develop your skills for analysing, integrating and presenting information for effective evidence-based communication.

Read More »

Assessment Task: Health service delivery

Assessment Task Health service delivery is inherently unpredictable. This unpredictability can arise from, for example, the assortment of patient presentations, environmental factors, changing technologies, shifts in health policy and changes in division leadership. It can also arise from changes in policy within an organisation and/or associated health services that impact

Read More »

LNDN08002 Business Cultures Resit Assessment

LNDN08002 Business Cultures Resit Assessment Briefing 2023–2024 (Resit for Term 1) Contents Before starting this resit, please: 1 Assessment Element 1: Individual Report 1 Case Report Marking Criteria. 3 Assessment Element 2: Continuing Personal Development (CPD) 4 Guidance for Assessment 2: Reflection and Reflective Practice. 5 Student Marking Criteria –

Read More »

Assessment Task 2 – NAPLAN Exercise

Assessment Task 2 (35%) – Evaluation and discussion of test items Assessment Task 2 (35%) – Evaluation and discussion of test items AITSL Standards: This assessmeAITSL Standards: This assessment provides the opportunity to develop evidence that demonstrates these Standards: 1.2        Understand how students learn 1.5        Differentiate teaching to meet with

Read More »

EBY014 Degree Tutor Group 2 Assignment

  Assignment Brief Module Degree Tutor Group 2 Module Code EBY014 Programme BA (Hons) Business and Management with   Foundation Year Academic Year 2024/2025 Issue Date 6th May 2024 Semester Component Magnitude Weighting Deadline Learning outcomes assessed 2 1 2000 words Capstone Assessment 100% 26th July, 2024 1/2/3/4 Module Curriculum

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?