CIS 2002 SEMESTER 3, 2014 Assignment 2 specification The assignment must be submitted electronically via the online assignment submission link on the study desk. Instructions will be provided on the course study desk. If you are unable to complete the whole assignment, submit what you have done rather than nothing. You must use the official USQ data modelling and normalization methodology. This methodology is based on Clive Finkelstein’s techniques ( http://usqstudydesk.usq.edu.au/file.php/117/content/reading4_1.pdfSR 2.1 and http://usqstudydesk.usq.edu.au/file.php/117/content/reading4_2.pdfSR 2.2) and all the examples in the lectures, study book and the tutorials use this methodology. If you do not use the USQ methodology, you will probably be awarded a mark of zero. You might wish to use a word processor or a drawing tool. In either case, you must adapt the drawing to conform to the USQ methodology. This assignment covers much of the same ground as the exam and will provide you with a strong indicator of your level of preparedness for the exam. Most of the questions are of examination standard. SECTION A (Data Modelling) (40 marks) A local pharmacy store in Wollongong wants to develop an online system to track their product inventory as well as prescription records of their products for regulatory requirements. As part of systems development, a data model is required to determine data entities and associated attributes and business rules. You are required to develop a data model which will allow the information and activities to be recorded. The most important data entity for the system is the ITEM entity – this entity represents all the products in the pharmacy. Item code, shelf, location and quantity are the attributes for ITEM entity. Every time an item is ordered, some of the order details such as order date, order quantity and special instructions to the patient for each item in every order are stored. Patient information includes an id,…