COMP2350/6350 2020 S2 – ASSIGNMENT ONE (10%)
Database Modelling & Design
Macquarie University provides a range of support services for students.
The background knowledge for the assignments is given in the textbook(s), lectures, any other components of the unit, in the prerequisite units ISYS114 or COMP1350, and in the readings provided on ilearn. However, some parts of the assignments may not be answered without prior independent research and/or searching for other sources of information.
This assignment concerns database conceptual modelling and logical design. It will be marked out of 100 and will contribute 10% towards your final grade. It consists of developing an enhanced ER (EER) model (Conceptual data model - CDM), and transforming the EER model into a relational data model (logical data model – LDM). The description of the Problem domain is given below.
There are a number of publicly funded libraries in the Greater Sydney region. The objective of this assignment is to develop a database system that will be used to centrally store and manage all relevant information for these libraries. We will refer to this as Sydney Library (SL). The information to be stored include information on different branches of SL (Ryde, Epping, etc), the collections they hold (books, magazines, movies, etc.), staff they employ (librarians, security personnel, etc.), members of the library, events they host (book reading and signing by author-guests). The basic requirements gathered from the stake holders is presented in the following five points. As typically the case, these requirements are often underspecified. Use your judgment in interpreting them when required, and keep a note of the assumptions you made.
paid is recorded. Furthermore, the actual cost of a event is calculated from a range of information such as: cost of staff time and infrastructure cost.
You will first put all your answers to the tasks below into a file Assignment1.doc (carefully following the instructions provided), then generate a .pdf file called Assignment1.pdf which you will submit on iLearn.
Construct a conceptual data model in the form of an enhanced ER (EER) model for the above problem domain (see the Appendix for a sample). Identify and justify the use of, if any, generalization /specialisation, weak entity types, and attributes on relationships. This model should include entities, attributes, primary keys, the relationships among entities with cardinality and participation constraints. You can make any reasonable assumptions if there is a lack of information on particular aspects and/or you think there is ambiguity. If necessary, you may also introduce additional entities to ensure that every data requirement is captured. Note that you should not show the foreign keys in the EER model.
You can do this task through a data modeling tool such as PowerDesigner or a drawing tool such as draw.io . Add/paste the EER model into the Assignment1.doc file.
Construct a logical data model (a relational data model) by transforming the conceptual data model of Task 1, showing the relations, their attributes, and foreign and primary keys. The relational data model can be presented either as a relation diagram or a relational schema (see the Appendix for samples).
You can choose to construct the relational data model either through MySQL Workbench or another tool such as PowerDesigner, or using a text editor. Add/paste the model into the Assignment1.doc file.
You must submit all the work in a single documents named Assignment1.pdf through the electronic submission site on ilearn. If you modify your file(s) after submission, you may re-submit your assignment again before the due date.
No extensions on assignments will be granted without an approved application for Special Consideration.
Late submissions will be accepted but there will be a deduction of 10% of the total available marks made from the total awarded mark for each 24 hour period or part thereof that the submission is late. For example, 25 hours late in submission for an assignment worth 100 marks – 20% penalty or 20 marks deducted from the total.
No submission will be accepted after solutions have been posted.
For solution, connect with online professionals.