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 (July 19, 2025) MITS4003 Database Systems Assignment 2. Retrieved from https://universalassignment.com/mits4003-database-systems-assignment-2/.
"MITS4003 Database Systems Assignment 2." Universal Assignment - July 19, 2025, https://universalassignment.com/mits4003-database-systems-assignment-2/
Universal Assignment May 5, 2023 MITS4003 Database Systems Assignment 2., viewed July 19, 2025,<https://universalassignment.com/mits4003-database-systems-assignment-2/>
Universal Assignment - MITS4003 Database Systems Assignment 2. [Internet]. [Accessed July 19, 2025]. Available from: https://universalassignment.com/mits4003-database-systems-assignment-2/
"MITS4003 Database Systems Assignment 2." Universal Assignment - Accessed July 19, 2025. 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: July 19, 2025]

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.

Categories

Get 90%* Discount on Assignment Help

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

Assignment Help in Lucknow – AI-Enhanced, Plagiarism-Free Academic Support

Are you a student in Lucknow struggling with complex assignments and tight deadlines? Whether you study at University of Lucknow, Amity University Lucknow, Integral University, or Dr. A.P.J. Abdul Kalam Technical University (AKTU), UniversalAssignment.com offers you reliable and high-quality assignment help in Lucknow with zero plagiarism and 100% confidentiality. We

Read More »

Assignment Help in Jaipur – AI-Powered, Plagiarism-Free Academic Assistance

Are you a student in Jaipur looking for high-quality, plagiarism-free academic support? Whether you’re pursuing engineering at MNIT, management at Jaipuria Institute, or law at Amity University Jaipur, UniversalAssignment.com is your one-stop solution for top-rated assignment help in Jaipur. We deliver AI-enhanced assignments with Turnitin-style plagiarism reports, expert-level research, and

Read More »

Assignment Help in Pune – AI-Based, Plagiarism-Free Academic Solutions

Are you a student in Pune struggling to complete assignments on time? Whether you’re from Savitribai Phule Pune University, Symbiosis International University, MIT-WPU, or Bharati Vidyapeeth, UniversalAssignment.com offers the most reliable and affordable assignment help in Pune — with zero plagiarism and AI-enhanced quality checks. We specialize in delivering university-specific,

Read More »

Assignment Help in Kolkata – AI-Enhanced, Plagiarism-Free Academic Support

Are you a student in Kolkata struggling with tough assignments, research papers, or academic deadlines? Whether you are studying at University of Calcutta, Jadavpur University, or Presidency University, UniversalAssignment.com is your trusted platform for reliable, plagiarism-free and AI-powered assignment help in Kolkata. We provide high-quality academic writing support to students

Read More »

Assignment Help in Mumbai – Trusted, AI-Powered & 100% Plagiarism-Free

Are you a student in Mumbai struggling with tight deadlines, complex assignments, or back-to-back submissions? Don’t worry — Universal Assignment offers the most trusted and professional assignment help in Mumbai, blending AI-powered tools with human expertise to deliver original, high-quality content every time. Whether you’re enrolled in Mumbai University, IIT

Read More »

Sociology Project: Case Analysis of Sarah

Assessment 3 – Final Project (35%)Final ProjectA 2000-word project consisting of three parts.Due: Sunday of Week 11Throughout the trimester, we discuss several serious social issues (e.g., family violence, inequality, poverty, mental health, addiction) and also examine various sociological perspectives (theories) that allow us to view these issues from different angles,

Read More »

ACC1AMD – Fundamentals of Accounting

GENERAL INFORMATION SUBMISSION: RELEVANT SUBJECT LEARNING INTENDED OUTCOMESSILO 1 – Explain the role of accounting in the business environmentSILO 2 – Apply fundamental accounting concepts and ethical principles in recording and reportingbusiness transactions.SILO 3 – Prepare basic financial statements and analyse financial reports for decision-making purposes.SILO 4 – Use information

Read More »

ICT504 IT Project Management

ICT504 IT Project ManagementActivity – Week 11Tech Innovate, a mid-sized technology firm specializing in software development, decided tooutsource its IT support services to a third-party provider, IT Assist Solutions, based in anothercountry. IT Assist Solutions was chosen for its competitive pricing, proven track record andability to provide 24/7 support. The

Read More »

EC502 Language and Literacy in the Early Years

Detailed Assessment Brief Assessment 1- Individual Assessment – Essay Unit Code/Description EC502 Language and Literacy in the Early Years Course/Subject Bachelor of Early Childhood Education Semester March 2025 Assessment Overview   Unit Learning Outcomes Addressed 1, 2, 3, 4 Assessment Objective Assessment 2: Essay Provide a critical review of relevant

Read More »

Examining the Factors Influencing Tourist Arrival

Assignment TaskYou are a strategist working for a major hospitality group based in Australia. The company is planninginternational expansion, and the board has asked you to compile a report to identify the most suitablelocation for the project. The board has shortlisted two international locations (which will be allocatedto you by

Read More »

Decision Making and Problem solving

Assignment Title:“What Are People Saying Online? Using Internet-Based Qualitative Research to SupportBusiness Decision-Making”OverviewIn this assignment, your group (2-4 students from same campus) will investigate howpeople talk online about a business, product, or issue. Using qualitative research techniques,you will collect online data, identify key themes, and recommend actions a business cantake

Read More »

HGA237|337 Juvenile Justice and Child Protection

InstructionsPlease read these instructions carefully. The submission time is Tuesday 10th of June 11:59pm. This is an open-book examination which should take no longer than2 hours to complete. You should set aside 15 minutes for readingtime in addition to these 2 hours. The total time therefore should be2 hours and

Read More »

Assignment Help in Turkey – AI-Powered, Plagiarism-Free Solutions

Are you a student in Turkey seeking reliable assignment help that’s fast, affordable, and 100% original? Universal Assignment combines expert academic guidance with advanced AI tools to deliver top-quality, plagiarism-free work—tailored for students in Istanbul, Ankara, İzmir, and all over Turkey. Why Universal Assignment is Turkey’s #1 Choice Turkish students

Read More »

Assignment Help in Greece – AI-Powered, Plagiarism-Free Academic Support

Struggling with tight deadlines and complex academic tasks in Greece? Whether you’re studying in Athens, Thessaloniki, Patras, or any other city, Universal Assignment is your trusted platform for assignment help in Greece. We combine expert academic writers with advanced AI tools to deliver high-quality, plagiarism-free solutions—on time, every time. ✅

Read More »

Assignment Help in Iraq – AI-Powered, Plagiarism-Free Academic Solutions

Need expert assignment help in Iraq? Whether you’re studying in Baghdad, Basra, Erbil, Mosul, or Karbala, Universal Assignment provides reliable, AI-driven academic support with 100% plagiarism-free work, fast delivery, and expert guidance for students at all academic levels. ✅ Why Students in Iraq Trust Universal Assignment With increasing academic pressure

Read More »

Assignment Help in Uzbekistan – AI-Powered, Plagiarism-Free Academic Services

Assignment Help in Uz Are you a student in Uzbekistan looking for expert, affordable, and 100% original assignment help? Whether you’re studying in Tashkent, Samarkand, Bukhara, Andijan, or Nukus, Universal Assignment delivers high-quality academic support that combines expert writers and AI-powered tools — ensuring you receive plagiarism-free, well-researched content every

Read More »

Assignment Help in Thailand – 100% Original & AI-Powered Academic Assistance

Are you a student in Thailand feeling overwhelmed by academic deadlines, complex assignments, or language barriers? Whether you’re studying in Bangkok, Chiang Mai, Khon Kaen, Pattaya, or Phuket, Universal Assignment is your trusted partner for fast, affordable, and high-quality assignment help in Thailand. We deliver AI-enhanced, plagiarism-free academic solutions tailored

Read More »

Assignment Help in New Zealand – Plagiarism-Free, AI-Enhanced Academic Support

Need assignment help in New Zealand that’s fast, affordable, and 100% original? Whether you’re studying in Auckland, Wellington, Christchurch, Hamilton, or Dunedin, Universal Assignment is your go-to academic partner. We combine expert writers and AI-powered tools to deliver assignments that meet New Zealand’s university standards—with a guaranteed plagiarism-free report. ✅

Read More »

Assignment Help in Colombia – AI-Powered, 100% Plagiarism-Free Support

Are you a student in Colombia facing academic pressure and tight deadlines? Whether you’re studying in Bogotá, Medellín, Cali, Barranquilla, or Cartagena, Universal Assignment provides expert, fast, and affordable assignment help in Colombia — powered by advanced AI tools and professional academic writers. ✅ Why Universal Assignment is Colombia’s Top

Read More »

Can't Find Your Assignment?