ICT503–Database Management Systems Assessment 3 – Group Assignment

Overview

 This assignment aims to develop the student’s skills in designing a database system.

Timelines and important information

Percentage value of Task: 30%

2000-word report+10min recorded presentation.

Group Submission (max 4 Students)–choose your group on Moodle. Explain your work with all step-by-step details.

Due: Sunday, Week 7. Submitting your work late will attract a 10% reduction of the mark for

Each day beyond the due date. A delay of more than 5 days will result in being granted a0.

Assessment Details:

Scenario:

You are tasked with designing a relational database for a library system in Australia. The library serves a diverse community and offers a wide range of books, digital media, and other resources. The library needs an efficient system to manage its collections, track member activity, and provide valuable services to its patrons.

Requirements:

Entities:

-          Books: Each book has a unique ISBN (International Standard Book Number), title, author(s), publication date, and genre.

-          Members: Library members register with their name, contact information, and a unique member ID.

-          Borrowing Records: Track when a member borrows a book, including the due date for return.

-          Library Staff: Staff members have unique staff IDs, names, roles, and contact information.

Relationships:

-          Members can borrow multiple books, and each book can be borrowed by multiple members.

-          Each borrowing record is associated with a specific book and member.

-          Staff members manage the borrowing and returning of books.

-          Books can belong to different genres, and multiple authors may have contributed to a single book.

Normalization:

-          Apply normalization techniques to ensure the database is free of data redundancy and maintains data integrity.

SQL Schema:

-          Create an SQL schema that includes tables for books, members, borrowing records, and library staff.

-          Define primary keys, foreign keys, and appropriate constraints.

-          Ensure that the data base schema enforces referential integrity.

General Assessment Requirement

Incomprehensible submissions - Assessments provide the opportunity for students to demonstrate their knowledge and skills to achieve the required standard. To do this, assessment responses need to be both clear and easy to understand. If not, SISTC cannot determine that students have demonstrated their knowledge and skills. Assessments will, therefore, be marked accordingly, including the potential for 0 (zero) marks where relevant.

Check with marking rubric: Before submitting your assessment, you should check it against the assessment criteria and the marking rubric included in this specification to ensure that you have satisfactorily addressed all the criteria that will be used to mark your submission.

Feedback

Feedback will be supplied through Moodle. Authoritative results will be published on Moodle.

Academic Misconduct

To submit your assessment task, you must indicate that you have read, understood, and complied with, the Sydney International School of Technology and Commerce Academic Integrity and Student Plagiarism policies and procedures.