DISPLAY THE CAR REGISTRATION, COST, MODEL NAME, MODEL DESCRIPTION, CAR GROUP NAME AND RENTAL CHARGE PER DAY FOR EACH CAR BOUGHT AFTER 31 DECEMBER 2011.
DISPLAY THE CAR REGISTRATION, COST, MODEL NAME, MODEL DESCRIPTION, CAR GROUP NAME AND RENTAL CHARGE PER DAY FOR EACH CAR BOUGHT AFTER 31 DECEMBER 2011.
You must submit the assignment electronically by the due date on the study desk. If you are unable to complete the whole assignment, submit what you have done rather than nothing.
You must use the data modelling and normalization methodology introduced in the course. This methodology is based on Clive Finkelstein’s techniques (SR 2.1 and SR 2.2) and all the examples in the lectures and the tutorials use this methodology.
If you do not use the methodology, you will probably be awarded a mark of zero.
It is perfectly acceptable if you submit neat hand-drawn ERD’s. Alternatively, you might wish to use Word. If you use a CASE or drawing tool, you must adapt the drawing to conform to the 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 at examination standard.
SECTION A (Data Modelling) (40 marks)
MARKING CRITERIA
1. Entities – no missing entities, appropriate names, no redundant entities, etc.
2. Cardinalities and optionalities all shown and correct.
3. Complete list of relations, showing all applicable attributes, primary keys and foreign keys.
4. Sophistication: well presented solution; good layout; innovative approach; correct
diagrams/notation; solution easy to read and understand; solution comprehensive
5. SQL CREATE TABLE uses an appropriate relation, is syntactically correct and meets the business rules.
A medical practice in Brisbane needs to develop a patient appointment system so that the reception staff can easily check doctor schedule, allocate consultation times and manage medical tests for patients. You are required to develop a data model which will allow following information and activities to be recorded.
The system needs to store doctor’s name, address, qualification, contact number and date of joining the practice. A doctor is categorised as either a specialist or general practitioner. For a specialist the system also stores the area of speciality. Both categories of doctors provide consultation to patients. For a patient the system stores patient identifier, name, address, date of birth, gender and medical history. Medical history is stored as a single field of text in the current design.
When a consultation is setup between a patient and a doctor, we record the consultation date, start time, duration and fees. A consultation may result in a referral to a specialist. A referral is stored in the system with the following details: referral date, reason for referral, the specialist being referred and the consultation that led to the referral.
A consultation may also result in requests for one or more tests that are conducted by the practice. It is mandatory to have a consultation by a doctor before a test can be conducted. There are a number of tests such as blood tests and fitness tests that can be administered by the staff employed by the practice. For every test we store test identifier, cost, consultation identifier that requested the test, test date, test result date and a follow up flag in case the client requires further urgent consultation or further tests.
. .
The post DISPLAY THE CAR REGISTRATION, COST, MODEL NAME, MODEL DESCRIPTION, CAR GROUP NAME AND RENTAL CHARGE PER DAY FOR EACH CAR BOUGHT AFTER 31 DECEMBER 2011. appeared first on academicheroes.com.
DISPLAY THE CAR REGISTRATION, COST, MODEL NAME, MODEL DESCRIPTION, CAR GROUP NAME AND RENTAL CHARGE PER DAY FOR EACH CAR BOUGHT AFTER 31 DECEMBER 2011. was first posted on October 20, 2019 at 11:45 am.
©2019 "Essay Lords | Bringing Excellence to students world wide". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at support@academicheroes.com
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
