Description

Assignment 1: Conceptual Modelling

Group assignment (10%)
Introduction
The purpose of this assignment is to provide you with experience in conceptual modelling. You are given a partial domain description for an Online Book Seller (OBS). Your task is to create an entity relationship diagram that can capture all the concepts and requirements conveyed in this description.
This is a group assignment. You must be enrolled in an assignment group on Canvas (3 people per group).
Submission Details
Domain Description for an Online Book Seller (OBS)
OBS has given you the task of developing a new conceptual model that represents the customer-centric parts of the data held within their business. The full OBS system also holds data related to the order, supplier, payments and delivery processes, but these systems (and the data that drives them) are out of scope for this assignment.
The core business of OBS is selling books to its customers, in either paper or eBook editions, and a key part of doing this successfully is making it easy for customers to find (and buy) books of interest. Customers must be able to search for books by title/authors, browse through books in specific genres or on curated lists, and find books similar to ones they’ve already purchased or found while searching or browsing.
This description is very high-level as the purpose of the assignment is to get you to think about the entities and relationships that would be needed. Your solution only has to address these stated requirements, but you will not be penalised for not-strictly-necessary entities, relationships or attributes, such as those that might be needed to support out-of-scope functionality, such as the payment and delivery processes. There is no single ‘correct’ answer to this assignment, but there are a number of good and complete designs that will get full marks.
1
COMP9120 Assignment 1
Marking
This assignment is worth 10% of your final grade for the unit of study. Your group’s submission will be marked according to the attached rubric (see last section of this assignment description).
Group member participation
Level of contribution Proportion of final grade received
No participation. 0%
Full understanding of the submitted work. 50%
Minor contributor to the group’s submission. 75%
Major contributor to the group’s submission. 100%

Marking Rubric
Your submissions will be marked according to the following rubric, with a maximum possible score of 10 points.
Novice (0 pts) Competent (1.5 pt) Proficient (2.5 pts)
Notation Big mistakes in the usage of
E-R notation Good usage of E-R notation with a few mistakes Proficient usage of the E-R notation
Core Model Less than competent model of the given scenario Some entities, relationships, or attributes cannot be correctly captured by the model
The core model was very well designed, and all the main entities, relationships and attributes can be correctly captured by the model
Constraints No constraints captured at all Some constraints (key / total participation constraints on relationship types etc) are included in the model, but either incorrectly or incomplete All appropriate constraints are modelled correctly
Design Specialities No design specialities used At least one ISA, weak entity or aggregation is used, but
either incorrectly or incomplete All appropriate design specialities are used correctly

2