Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
INFS601 LOGICAL DATABASE DESIGN
Individual Assignment Database Project 50% of the final grade Due: 11.59pm,
4th June 2021 Part Tasks Marks Part A Entity Relationship Modelling and Logical Database Design
Tasks 1, 2, and 3 45 Part B Database Implementation Tasks 4, and 5 30 Part C Construct SQL Queries
Task 6 25 1. Introduction to Assignment Requirements This assignment is designed to
provide students with practical exposure to the stages involved in database development
including the development of entity relationship modelling, database design and implementation.
This is an individual assignment. It provides an opportunity for students to apply to a larger case
study the database concepts discussed in class and practised in exercises. The case study, described in detail,
is provided on Blackboard under Assessment -> Assignment - Database Project. Please read the case study
(available as a separate file) carefully for more details. Students may ask for additional clarification of the case study on the
discussion board on Blackboard. The details of the three parts along with the tasks are specified in Section 2.
Section 3 describes the submission details and dates. The marking scheme for the three tasks is provided in Section
4. Expectations The assignment includes 3 parts. Part A consists of Tasks 1, 2 and 3. Part B is comprised of Tasks 4 and 5.
Part C has task 6. Students are required to attempt all the tasks. Tools & Templates You are to use the specified CASE tool, Visual Paradigm CE version for this assignment. Page 2 of 8 Plagiarism Plagiarism means borrowing from the work of another without indicating by referencing (and by quotation marks where exact phrases are borrowed) that the ideas expressed are not one’s own. Students may use the ideas and information of other authors, but this use must be acknowledged. It is not acceptable to submit an assignment that is simply paraphrasing of extracts from other authors: the work submitted must include some intellectual contribution of the student. Unauthorised Collaboration Unauthorised collaboration means joint effort between students or students and others, in preparing material submitted for assessment, except where this has been pre-approved by the paper programme. Students are encouraged to discuss matters covered in classes, but the expression of ideas and arguments must be the student’s own work. Page 3 of 8 2. Assignment Parts and Tasks Part A Entity Relationship Modelling and Logical Database Design (45 marks) Task 1 Identify Entities & Develop Business Rules [10 marks] Identify all entities and relationships in the case study and develop a set of business rules. You should follow the syntax given below. Each relationship must be described by two rules, one in each direction. Each/A/An ENTITY_1 May/Must Relationship_Verb_Phrase number ENTITY_2 Task 2 Construct a logical Entity Relationship Diagram (ERD) [20 marks] Based on the business rules developed in Task 1, construct a logical ERD for the case study using the Visual Paradigm tool. • Identify all attributes in each entity including all primary and foreign keys (any composite and multivalued attributes must be transformed according to the rules of the relational model). • All relationships must be named (i.e. Verb phrases must be shown for all relationships) • If super/subtypes are used, indicate whether the super-subtype relationships are disjoint or overlapping, and fully or partially specialised (complete or incomplete). • Identify the Cardinality and Participation for each relationship.
• Resolve all M:N relationships. • Describe any assumptions you have made in a text note in the diagram.
Task 3 Use Normalisation to validate your ERD [15 marks] (a) Use the technique of normalisation to validate your logical ERD data model .
Demonstrate that each of your relations is in third normal form (3NF) by displaying (a list of dependencies)
the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF,
this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of
deriving relations from your model. Page 4 of 8 Part B Database Implementation (30 marks)
In this part you should develop a database based on your logical ERD developed and validated in Part A.
You must populate the tables with sample realistic data. Task 4 Create tables [20 marks]