TASK ASSIGNMENT- HI5033 Database Design T1 2025 Assignment Help

HI5033 Database Design T1 2025 Assignment Help

Group Assignment

Group Assignment Guidelines and Specifications

Objectives

This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to reinforce the lecture material and give students practice at applying Database design techniques, as well as providing a relational schema using DDL statements and relational DML statements to demonstrate sophisticated access of the Database to be built.

Group Assignment Case Study

This assessment will be completed in groups of 4 students from the same class. Groups will be formed within the first 2 weeks, and students will be expected to work within these groups for the remainder of the semester on the group case study. 

Each group needs to choose a particular type of Information System, research the storage requirements then design and build a possible database for that system. For instance, a group may choose a POS system for a supermarket, a small online savings bank, a stock management system for a financial firm etc. 

This assessment is worth 40% of the unit’s grade and is a major assessment. Groups are advised to begin working on it as soon as possible.

Deliverable Description

The deliverable should consist of four parts, detailed as follows:

1.Requirement specification

Your group must provide an overview of the selected system and specify its requirements. These requirements should directly relate to the tasks outlined in the subsequent three parts.

2.Database ER Model

The ER Model should represent the database structure you plan to build for the group case study. It must be presented using Crow’s Foot notation and accurately reflect the database to be built. The model should provide a realistic depiction of the data requirements for the chosen system and include at least 10 entity types.

3.Database Schema DDL statements

You are required to create Schema DDL statements to build your database. Your tables should include all appropriate primary and foreign keys, as well as any relevant constraints.

4.Sophisticated DML statements

You are required to construct SQL INSERT statements to populate all your tables with initial data, ensuring that each table contains at least 5 rows. You have the freedom to choose appropriate data for insertion. Additionally, you must create 5 SQL statements to demonstrate sophisticated data access. These statements must involve joins between multiple tables (Inner Joins only are acceptable). The test data should be sufficient to effectively demonstrate the use of your SQL statements. These statements should be included in a script and presented in class to your tutor.

Finally, your group is required to prepare a single document in Microsoft Word format. This document should contain a cover page and the four parts mentioned above. Ensure that the SQL statements for Parts 3 and 4 are included. The file must be submitted via Blackboard.

Marking Rubric

Submission Guidelines

Your documents should be a single MS Word or OpenOffice document containing your report. Do not use PDF as a submission format,

All submissions will be submitted through the Safe Assign facility in Blackboard. Submission boxes linked to Safe Assign will be set up in the Units Blackboard Shell. Assignments not submitted through these submission links will not be considered.

Submissions must be made by the due date and time (which will be in the session detailed above) and determined by your Unit coordinator. Submissions made after the due date and time will be penalized per day late (including weekend days) according to Holmes Institute policies.

The Safe Assign similarity score will be used in determining the level,if any,of plagiarism.Safe Assign will check conference web-sites,Journal articles,the Web and your own class members submissions for plagiarism. You can see your Safe Assign similarity score (or match)when you submit your assignment to the appropriate drop-box. If this is a concern you will have a chance to change your assignment and resubmit. However, re-submission is only allowed prior to the submission due date and time. After the due date and time have elapsed your assignment will be graded as late. Submitted assignments that indicate a high level of plagiarism will be penalized according to the Holmes Academic Misconduct policy, there will be no exceptions. Thus, plan early and submit early to take advantage of the re-submission feature. You can make multiple submissions, but please remember we grade only the last submission, and the date and time you submitted will be taken from that submission