MIS602 Entire Course ( MIS602 Data Modelling and Database Design)

MIS_602_Data_Modelling_and_Database_Design  {Entire Course Solution}

MIS602 Assessment 1 Modelling report on existing practices (PART I & PART II)

MIS602 Assessment 2 Database programming evaluation practical (Part 1 and Part 2)

MIS602 Assessment 3 Reflective research report

---------------------------------------------------------------------------------------

Assessment 1 Modelling report on existing practices (PART I & PART II)

Context:

The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment.  


Introduction:

This assignment is based on the following scenario:

ABC library is a small community library in the northern suburbs of Adelaide. In the recent years, its collection of books and the number of registered users have increased significantly facing difficulties in manually handling its main functions efficiently. To improve its services, the senior management of the library has considered a computerized library management system. The library has a rich collection of books with different genres such as fiction, biography, and history to name a few. The main functions considered for computerizing include searching of book collection based on author name, book title and genre. For this, the system should allow common functions including add, delete and modification of book details. Similarly, the library also wants to keep records of all the transactions— book issue and return. Finally, the system should allow the library staff to view all transactions and associated borrowers (library members) for each transaction, transaction date and the library staff who handled each transaction.

This assessment comprises of TWO parts. 

PART I 

Requirements: Based on this scenario, you should identify key business data objects and their attributes and define them as columns in a spreadsheet using MS excel or similar software. For this you are required to create multiple versions, ideally one file with 4 sheets with each sheet numbered with the version number, of the spreadsheet file as per below instruction:  

·         Version 1 (V1.0): List all the data objects and their attributes as columns, and then add at least 10 rows of data.  

·         Version 2 (V1.1): Update last 2 records (highlight in blue) and add 5 additional records (highlight in yellow) to each data object identified. 

·         Version 3 (V1.2):  Add 2 new attributes (highlight in red) to each data object identified. 

·         Version 4 (V1.3) : Remove 1 existing attribute from each data object and add 5 more rows of data (highlight in green).  

After completing the spreadsheet versions, you are required produce and experience/reflection report (1000 words) in a word document summarizing your experience of doing these tasks. 

Submission:  Your submission must composed of the following files, which must be submitted to Blackboard on or before Week 4, Thursday 23:59 (Sydney time) 

1. Spreadsheet file.  

2. Experience/Reflection report (Approximately 1000 words) in a word document summarizing your experience of doing this assignment.

Note: On the following day, you will receive another student’s spreadsheet via email to review, for which you are required to write a short critique. This is explained in the following section.  
 

PART II:

Requirements: Based on the spreadsheet you received, you are required to write a critique of approximately 500 words. Please note that your critique should provide constructive feedback highlighting the strengths and areas for improvement in the report, as well as any new knowledge gained from evaluating the authors report. You should provide feedback on overall design of the database, and fulfil the following minimum requirements: 

·         Comment on the overall design of the database including the appropriateness of data objects and the attributes taken into consideration. 

·         Provide constructive criticism on how author could enhance the overall database design, data objects and attributes. 

·         Provide at least 4 useful readings the author may peruse to enhance understanding of business data objects and their characteristics. 


Submission: Your submission must composed of the following file(s), which must be submitted to Blackboard in a single zipped file on or before  Week 4, Sunday 23:59 (Sydney time). 

1. Critique of 500 words.

2. The author’s report, which your critique was based upon. 

Note: all non-submission or late submissions will be treated in accordance with the late assessment policy of the university.

 

 

Assessment Two – Database programming evaluation practical

(Part 1 and Part 2)

Context:

The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment.

Introduction:

You are required to create the database tables as per the ERD below, and then generate the SQL tasks given in the table.

Submission Requirements and Instructions

This assessment comprises of TWO parts. 

PART I 

Requirements:  Complete all the SQL tasks given in the table above. After completing the SQL tasks, you are required produce and experience/reflection report (1000 words) in a word document summarizing your experience of doing these tasks. 

 

Submission: Your submission must composed of the following files, which must be submitted to Blackboard on or before

Week 7, Thursday 23:59 (Sydney time)

1. SQL file (24 tasks) with results and outputs in a word document.

2. Experience/Reflection report.  


PART II

Requirements: Based on the assignment you received, you are required to write a critique of approximately 500 words. Please note that your critique should provide constructive feedback highlighting the strengths and areas for improvement in the report, as well as any new knowledge gained from evaluating the authors report. You should provide feedback on overall design of the database, and fulfil the following minimum requirements: 

·         Comment on the overall usage of SQL statements and commands used.

·         Provide constructive criticism on how the author can improve their understanding of SQL statements.

·         Provide some useful readings the author may pursue to help in developing the SQL skills in the future. 
 

Submission: Your submission must composed of the following files, which must be submitted to Blackboard in a single zipped file on or before  Week 7, Sunday 23:59 (Sydney time)

1. Critique of 500 words.

2. The author’s report, which your critique was based upon. 

Note: All non-submission or late submissions will be treated in accordance with the late assessment policy of the university.



Assessment 3 Reflective Research Report


Context:

The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment.

Scenario:

The scenario for this assessment is a multi-specialty hospital system, the Royal Rundle Hospital (RRH), that provides a broad range of services to the community which include surgical, maternity, obstetric care, dialysis, emergency, mental health, aged and palliative care, allied health services and a 24-hour emergency department. The RRH has been serving in the region for over 50 years and has been using paper-based forms and documents to store and manage all the data with some use of spreadsheets that started not so long ago.  Now that the management of RRH wants to take the advantages of Information Technology to maintain and manage the records of the various aspects of the hospital system more efficiently, they have put out a Request for Proposals (RFP) for appropriately qualified consultants to undertake a body of work that would help to scope the data requirements for such a system. With your success in your Torrens University Australia degree so far, and other similar projects that have garnered you some sustained success in the eyes of the profession and community, you have been shortlisted among no less than 10 other consultancies. There are expectations from them, then, as to the standard of report you will produce.

The management of the RRH has provided you with an overview and description of the hospital system as below-

Overview:

 The Royal Rundle Hospital (RRH) is a multi-specialty hospital that includes a number of departments, rooms, doctors, nurses, compounders, and other staff working in the hospital. Patients having different kinds of ailments come to the hospital and get checkup done from the relevant doctors. If required they are admitted in the hospital and discharged after treatment. The hospital maintains the records of various departments, rooms, and doctors in the hospital besides the most important records of the regular patients, patients admitted in the hospital, the checkup of patients done by the doctors, the patients that have been operated, and patients discharged from the hospital.

Description:

In RRH, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD where patients come and get a card (that is, entry card of the patient) for check up from the relevant doctor. After making entry in the card, they go to the relevant doctor’s room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the relevant department. The patient may choose either private or general room according to his/her need. But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges, etc. After the treatment is completed, the doctor discharges the patient. Before discharging from the hospital, the patient again has to complete certain formalities of the hospital like balance charges, test charges, operation charges (if any), blood charges, doctors’ charges, etc. 

Next, the management talks about the doctors of the hospital. There are two types of the doctors in the hospital, namely, regular doctors and call-on doctors. Regular doctors are those doctors who come to the hospital daily. Call-on doctors are those doctors who are called by the hospital if the relevant regular doctor is not available.

Instructions:

The management believes and understands that the benefits of an IT solution to manage and maintain their records are enormous and hopes to gain a thorough insight that should come from a lot of forethought and design elements fed into it before it could be seriously considered by them. The RRH management seeks consultation on what the data requirements of such a system might be.

 There are two objectives of this assessment: 

1. For the purposes of the client, the Royal Rundle Hospital (RRH) management, you are to  produce a design brief and, 

2. For the purposes of the assessment, you are to produce a reflection. 

So, this written submission should expertly mix a consultative style—that is, providing a solution to the problem as outlined by the client—with a deep reflection on what you have learned in the subject and the potential for such an automated system. You will need to use your judgement on this, it is likely to take several drafts to get it right. The deliverable for this assessment is plainly: 

You are required to create a consultative report that addresses the data requirements of the proposed Royal Rundle Hospital (RRH) System as well as commenting on the feasibility of such a solution, given what you learned in the subject. Following instructions will assist you in completion of the task. 

Some hints for you to heed while you develop and write your assessment: 

·         Consider all aspects of the hospital’s operations and flows of data and then explore the benefits and challenges that an automated system may present in regard to effectiveness, efficiency an also adaptation issues, when implemented. 

·         The RRH management has not provided any assumptions and you should list these if your proposal and reflection are to be considered cogent. 

Based on your learning from the course modules and previous assignments, you are expected to come up with data requirements and a logical design of the system and a brief commentary on the design.

Submission Instructions:

This consultative research and reflective report will be in a format that you choose and there are no prescriptions for what to include or what not to include. You will need to research consultant-grade reports (look for consulting reports form the Big Four firms as a guide and use them as the basis for their content, articulation presentation standard). 

Besides your research and reflection, you should include logical data requirements in a design summary that includes appropriate Entity- Relationship (ER) Diagram replete with connectivity and cardinality considerations, and the database schema with the final set of Relations normalised to 3NF (Note: you do not need to include the normalisation steps). You should list any and all assumptions used in your report as well as any limitations that the reader should consider as they read your report. 

You should treat the prescribed word limit as something you cannot breach as there is no plus-or-minus 10 per cent ascribed in this assessment. The reality of consultant-grade reports is that any that breach the requirements are rejected and no reasoning is provided to the consultant. As you are preparing for your professional life, treat this requirement as the same in this subject and that any report that breaches the word limit will not be marked. 

Requests for extensions must be compliant with the university policy and must be applied for before the due date. Include in your application a full draft of your assessment as this draft may be what is assessed if the extension request is denied. 

Submit your report to the submission point in Blackboard prior to the due date. In accordance with university policy, late assessments will attract a 10% of available grade penalty for every day late, up to a maximum of 5 days, after which the assessment will not be marked. 

Please note that requests for resubmissions of this assessment will not be considered