Tutorial for Week 6

1.  Readings:

Mandatory Readings

• Kerzner Chapter 1.14-1.16, & 3;
• PMI Implementing Organizational PM Chapter 2;

Optional Readings

• If you have time then please access the Project Management Journal Volume 44 No 1, pages 17-34 for the article by Besner C. & Hobbs B. (2012) Contextualized Project Management Practice: A Cluster Analysis of Practices and Best Practices

Make sure you have done the readings.

                                              Order Now

2. Watch recordings:

Also, watch YouTube: Project Governance by Darya Duma from Procept

Associates Ltd (9 mins)

3. Answer following Questions to reflect and assist in your Portfolio
   • What are the different ways of classifying projects?
   • How senior is a Project Manager in an organization?
   • Do you think that functional managers would make good project managers?

• Project managers are usually dedicated and committed to the project. Who should be “looking over the shoulder” of the project manager to make sure that the work and requests are also in the best interest of the company? Does your answer depend on the priority of the project?

• Is project management designed to transfer power from the line managers to the project manager?

• Explain how career paths and career growth can differ between project-driven and non–project-driven organizations. In each organization, is the career path fastest in project management, project engineering, or line management?Think about your own career into the future and describe a possible career path.

• Describe the different organizational structures and explain the pros and cons of each.
• Do you think that personnel working in a project organizational structure should undergo “therapy” sessions or seminars on a regular basis so as to better understand their working environment? If yes, how frequently? Does the frequency depend upon the project organizational form selected, or should they all be treated equally?
• How would each person identified below respond to the question, “How many bosses do you have?
• Project manager
• Functional team member o Functional manager

Tutorial for Week 5

1. 

    Readings:

Mandatory Readings

• Kerzner Chapter 9, 11.34;

• PMI Implementing Organizational PM Preface & Chapter 1;

Make sure you have done the readings.

2. Watch recordings:

Also, watch Week 5 Tutorial Recording (MP4 File 700KB) and Harold Kerzner

Video: An Introduction to the Best Practices in Project Management (MOV File - 220MB)

                                             Order Now

3. Answer following Questions to reflect and assist in your Portfolio

• How can project management deliver successful projects?
• How would you describe project management effectiveness?
• Is controlling expectations important for success? Why?  How?
• What is an example of best practice in your life?
• Below are twelve instructions. Which are best described as planning, and which are best described as forecasting?

o Give a complete definition of the work. o Lay out a proposed schedule.

o  Establish project milestones.

o  Determine the need for different resources.

o Determine the skills required for each WBS task or element. o Change the scope of the effort and obtain new estimates. o Estimate the total time to complete the required work.

o  Consider changing resources.

o Assign appropriate personnel to each WBS element. o Reschedule project resources.

o Begin scheduling the WBS elements. o Change the project priorities.

Tutorial for Week 4

 Readings:

2. Watch recordings:

3. Answer following Questions to reflect and assist in your Portfolio

• How do organisations employ the best staff? In particular, how does an organisation find the best project manager?
• What skills do you think are needed for a good project manager? Why?
• What happens when an organisation selects the wrong project manager?                                                                             

                                                               Order Now

• Do you think project managers of today are different from project manager ten years ago? How are they different?

• Are you different in how you do things today as compared to ten years ago?
• Do you ever try to improve your efficiency in how you do things?
• How do you improve? What do you do?

Tutorial for Week 3

1. Readings:

Mandatory Readings

• Kerzner Chapter 2, & 21;

• Please access the Project Management Journal Vol. 42, No. 5, 4-16 and read the following article Walker D., Dart C. J. (2011) Frontinus--A Project Manager From the Roman Empire Era

Make sure you have done the readings.

2. Watch recordings:

3. Answer following Questions to reflect and assist in your Portfolio

• After reading about the history about project management, describe what you think about project management? What has been the contribution to the world?

• What are the benefits of using project management?                                                                                                                                  Order Now

• Could you say that the method you approach things with has similarities to project management?

• How would you describe project management and change?
• Have you ever wanted to change something?
• Describe an example where you introduce change and how you achieved it.
• How would you describe a “System”, “Program and “Project”?
• Have you ever experienced a failed project?
• Describe it and why it failed? What could have been done differently to not fail?

• Describe a project life cycle? Can you name any?
• Why do you think we need project management methodologies?
• How does having project management methodologies relate to continuous improvement?
• Have you ever experienced continuous improvement in your life?
• Describe an example where you strived for ‘continuous improvement”
• Have you ever failed in an exam, a test, or done badly in an activity and then wanted to improve? What did you do to improve?

Project Management

Tutorial for Week 2

1. Readings:

Mandatory Readings

• Kerzner Chapter 1;
• Egelstaff (2013) Academic assignments: Critical thinking and writing critically;

• Additional readings will be made available when the course starts

Make sure you have done the readings.

2. Watch recordings:

3. Answer following Questions to reflect and assist in your Portfolio

• Put in your own words what you think Project Management is.

• Make a list of three activities that you do each day or each week which can be regarded as a Project
• Now, what is Project Success                                                                                                                                                                  Order Now

• Do you know of any projects that are successful? Describe one? How is it successful?
• Is Project Success the same as Project Management? Why?
• Make a list of three problems of Project Management?

• Can anyone be a good project manager? Do you think that functional managers would make good project managers?

• Project managers are usually dedicated and committed to the project. Who should be “looking over the shoulder” of the project manager to make sure that the work and requests are also in the best interest of the company? Does your answer depend on the priority of the project?

4. Now prepare your Portfolio for Week 2 Remember to use the template.

You will need to create weekly portfolios in your tutorial and submit them online. At the end of the term, you will also need to submit a consolidated portfolio.

Use the answers to your Questions above to provide evidence of previous and current experience.

Your task is to write a weekly portfolio reflecting upon your learnings from the prior week. In your portfolio you will identify:

• the learning outcomes and module/topic of the course,

• a description of your experience, including reading samples or records,

• your learning from your experiences, and

• any supporting documentation of prior or current learning.

You will notice that the questions that I have asked you in the tutorial help you to create this portfolio.

You will use the portfolio template provided on the Moodle web site for this weekly portfolio. You should upload your completed weekly portfolio to the Moodle web site after the tutorial.

Your portfolio should contain a coherent, but necessarily restricted review of the academic literature related to the project management topics for each week. You should also include a weekly reference list formatted in the prescribed Harvard style. You are also encouraged to include a bibliography.

This assessment item involves researching the topics to enhance your understanding of each concept through an utilisation of academic literature and secondary sources. Whilst you must use the recommended textbooks and web links, you should also refer to other sources on the Moodle web site and additional relevant peer reviewed academic journal articles of your choosing.

Your weekly portfolio can be as long or as short as you want it to be. It is your portfolio and shows your development of understanding during the course. Naturally, this will make the portfolio different for everyone. Each student’s background, education, current and past work experiences is what makes it different. Each student’s personal researches will be different.

What you need to do is to give yourself enough time to reflect and show how you have thought and come to grips with the ideas that address the learning outcomes of the course. The amount of time you should be allocating to the course is 12 to 16 hours per week (which includes writing the portfolio). So there should be a fair bit of time for you to make the reflections and reach a depth of insight that will make the portfolio meaningful.

With each weeks portfolio that you submit you do not include the writing that you made for a prior week. Instead you use the same portfolio template using only the section for the week you are writing about. In other words each week’s portfolio is a reflection upon that week. You should however, revisit the whole of the course learning outcomes each week. The portfolio for any previous week is a reflection of your insights and thoughts for that week. Once you upload the portfolio then leave it for that week. Over the duration of the course you will find that there is a development and change of your ideas as you study the material. You will then have opportunity at the end of the course to consolidate everything and show how you have gained the insights that the course is seeking to provide. At the end of the course you should review your weekly portfolios and consolidate them into a single submission. You should make a personal reflection in this submission. This is the assessment that gets marked. 

It is to your benefit to have the personal discipline to make sure that you do not get behind. If you are allocating 12 or 16 hours per week for the course then there is plenty of time for the portfolio. If you find that one week you slip then ok, but the course is fundamentally planned so that you need to allocate 12 to 16 hours each week. Two hours lost in one week means that you need to do 14 to 18 hours the next!

The course is straight forward, but there are lots of web sites to visit and material to download. The text books are only part of the story and you won’t be able to do the course with just the text books. Unfortunately, much of the material is written from a North American perspective. You will need to consider other industry sectors and also to be able to translate the learning outcomes into an Australian or other cultural perspective. Therefore, you will need to download other files and visit web sites to be able to gather the material you need in your portfolio.

There are no bonus points for getting the portfolio perfect from the first week! In fact the portfolio for the first week is much more likely to be an amateurish attempt. It is unlikely that you’ll really know what you’re doing in the first and second week, and if you pretended you do then it would be hard to believe you anyway! Understanding and familiarity will only develop over time. As you do the portfolios’ each week and keep revisiting the learning outcomes and adding the course material then you will gain insights required. Unless you do that on a weekly basis you won’t have the appropriate perspective to make the journey and reach the destination by the end of the course.

Ensuring you have accurate references is important and will allow the marker to easily identify where your portfolio maps to the course or other peer reviewed material. Also you need to show how you have made critical reflection on the material and added your own unique insights.

Information Security Management

Objectives

This assessment task can be undertaken in a group of up to 4 members or individually. Each student/group will analyse the given scenario given on page 2,and write a report. The reportshoulddiscuss theguidelines for managingthe information security risksof the organisation.

Assessment criteria

Students are assessed against their ability to analyse the given scenario and discuss the guidelines for managing the information security risks of the organisation.

The marking criteria for Assessment Item 4 are provided on page 3.Students need to familiarise themselves with the marking criteria to ensure that they have addressed them when preparing this assessment item.
                                                  Order Now

Assessment Task

Each student/groupis required to analyse the scenario given on page 2 and produce a report that discusses the guidelines for managing the information security risks of the organisation. Your report should havethe Executive Summary, Table of Contents, Introduction, Discussion (the guidelines),

Assumptions and References sections

Note:Each student in the group needsto upload the report of their group to Moodle. You must follow

Check the unit website at least once a week for further information relating to this assessment task. Please ensure that you write your answers in your own words to avoid possible plagiarism and copyright violation. You can understand the Plagiarism Procedures by following the corresponding link in the CQUniversity Policies section of the Unit Profile. Late assessments will be penalised as per the university policies and guidelines.

The Scenario for Information Security Management Assessment Tasks

Academics for Academics (A4A) is a Non-Governmental Organisation (NGO) that has its head office and the branch office in Sydney and Singapore respectively. Being a NGO, A4A funds all of its projects and activities from public donations. A4A has a team of 10 staff members, and 6 of them are located in Sydney office and the remaining four are located in the Singapore office. A4A was established to help small public and private universities and colleges in Australia and Southeast Asia. The private universities and colleges that are interested in receiving the service of A4A need to register with A4A and become its member institutions. The academics and experienced professionals who like to provide a voluntary service such as teaching a subject, supervising a research project or development of curricula for a member institution, can register their interests with A4A. After a recruiting process, they can become members of A4A.  A4A then recruit them to short term assignments at its member institution.

The members that are recruited to various projects will be provided with accommodation, meals, medical and travel expenses.

Once recruited to a project, the A4A member will work at the member institution but the information produced by the member, except the emails, marked assignments and exams will remain the property of A4A and the member. As such, all those information should be handled and stored by the information system of A4A irrespective of the location where the member works. A4A needs the guarantee that the various data and information in their information system are secured.

As A4A was established last year, the information security policies have not yet been developed. It is now in the process of developing a comprehensive set of information security policies for its information system.

Marking Criteria
Section	HD				D		C		P		F			Max Mark	Mark
	5		4.5	4.25	4	3.75	3.5	3.25	3	2.5	2.4	1.2	0
Executive summary	Covered all the sections of the report				Contained all sections but not enough detail.		Had too brief or missing sections.		Not clear but contained most sections.		Not clear and most sections missing.			5
Table of contents	Used decimal notation. Included all headings and page numbers. Used ToC auto-generation.				One feature was missing.		A few features missing.		Included only the main headings.		ToC missing.			5
Introduction	Set the scene for the report and described the purpose clearly.				Contained all parts but not enough detail.		Had too brief or missing parts.		Not clear but contained most parts.		Not clear and most parts missing.			5
	HD				D		C		P		F
	15		14	13	12	11	10.5	9.5	9	7.5	7	3.5	0
Discussion	Discussed the guidelinesfor managing information security risks based on the standard, including any issues.				Contained all information but not enough detail.		Had too brief or missing information.		Not clear but contained most information.		Not clear and most information missing.			15
	HD				D		C		P		F
	5		4.5	4.25	4	3.75	3.5	3.25	3	2.5	2.4	1.2	0
Assumptions	Correct list of assumptions.				A few assumptions missing		Several assumptions missing.		Many assumptions missing.		Not clear or not relevant..			5
References	All references are listed according to Harvard reference style.				A few referencing errors.		Not all references are listed but correctly referenced..		Many references missing		No or incorrect reference list.			5
										Plagiarism penalty
										Late submission penalty
										Total				40

Clinical Research

Be sure to use the following subtitles and discuss each of the points outlined below:

1. From bench to bedside (~1 page; 10 pts)

   1. Explain the process of developing new treatments or studying physiological/pathophysiological processes from the bench to the bedside. In other words, when would animal studies be necessary (bench studies) as compared to clinical trials involving humans (“bedside” studies)?

2. Clinical Research Ethics (~2 pages; 15 pts)

   1. Provide a brief history of some of the main ethical violations in clinical research based on your readings (and in your own words). Include a brief discussion on some of the major historical events which prompted laws to be created to protect humans in research.                                                                                                 Order Now

2. 1. What specific laws protect clinical research subjects or participants as a result of these violations?
   2. What is informed consent and why it is important to obtain prior to starting a clinical research project involving humans? What are the essential components of informed consent? When can informed consent be invalid?
   3. If you were reading a scientific article, how could you tell that the research was approved by an oversight committee? What is the name of the committee that approves and oversees research involving humans at universities?

• Use of Animals in Research (~2 pages; 15 pts)

  1. Give examples of ethical violations involving the use of animals in research. What was the outcome of these violations?
  2. What laws are in existence to protect laboratory animals? What committee is responsible for the approval and oversight of research involving any animal at universities? What federal organization oversees the university committee and performs annual inspections of all facilities involved in animal research? Can research be legally conducted using animals without having approval?
  3. Discuss some of the common misconceptions regarding the use of animals in research?
  4. Discuss why is animal research important in scientific discovery?
  5. Using PubMed to find relevant research articles, give at least 2 examples of scientific discoveries that have been made in animals. This could be something discovered in laboratory rodents, like improved vision for blind mice using a new chemical (this did just happen). Or it could be something that an animal was discovered to naturally have or be adapted to (ex: Gila monster saliva contains a chemical that lowers blood sugar and is now used to treat diabetes (drug: Byetta)). DO NOT re-use these examples!

1. References
   

   List all references used to write your paper in APA format and be sure to cite your references properly within the text of the paper.

 
Requirement:

1. Paper is at least 5 pages (NOT including references or title page). · References have been provided in a list at the end of the paper and are appropriately cited in the text using APA format. · Font is at least 12-point; paper is single or double spaced; margins are no larger than 1”. ·
2. Paper was free of grammatical errors and misspellings.
3. All aspects of this section were addressed as described in the instructions. · Clear evidence of reading the required materials by referring to information learned. · Terminology is clearly defined and used appropriately.
4. Clinical Research Ethics: Well-developed responses to each sub question (a-d) in the instructions were provided. · Knowledge gained from the readings was incorporated appropriately and effectively.
   
   5. Use of Animals in Research: Well-developed responses to each sub question (a-e) in the instructions were provided. · Knowledge gained from the readings was incorporated appropriately and effectively. · Chosen examples of scientific discoveries are current (within the last 10 years) and are not the ones provided in the instructions. These examples are described in sufficient detail

Data Model Development and Implementation

Assignment Description       60 Marks

Knox private  Hospital contracted with GreenIT  services to develop and design their hospital database, the hospital IT Manager provided the following business rules to the GreenIT services software developer:

Complete the information-level design for the database that satisfies the following constraints and user view requirements. In order to complete this information-level design you are required to answer questions given below 1(a) – (e)

User view 1 requirement   : Patients are identified by a PatientID, and their names, addresses, and ages must be recorded.

User view 2 requirement   : Doctors are identified by a DoctorID.  For each doctor, the name, specialty, and years of experience must be recorded.

User view 3 requirement   : Every patient has a primary physician/doctor. Every doctor has at least one patient.

User view 4 requirement   : Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors.  Each prescription can have more than one drug.

User view 5 requirement:  For each drug, identified by DrugID and the trade name and formula must be recorded. 

User view 6 requirement: Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.

User view 7 requirement: Each pharmacy has a unique name, address, and phone number.

ORDER NOW

1. Analyse the all user requirements given above, identify and list all entities described in each user requirement.       (5 Marks)

1. Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes. You are required to arrange them as given in the example below.

NB: Select suitable primary key for each table and underline them.

Eg.        Patient (PatientID, name,…….)                                                                       (5 Marks)

1. Outline all relationships between entities.

Eg. One project may belong to several departments - One-to-many,                          (5 Marks)

1. Determine the functional dependences.

Eg.  PatientID  à name, address,  ......           (5 Marks)

1. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency that causes it.  (10 Marks)

2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that doesn’t show from the problem, they must be described.

You are required to use Visio or any other software tool to create the ER diagram.  (10 Marks)

3. Build this model using MS Access by creating these tables and Relationships. Populate these tables with appropriate data, at least 3 records in each table. (10 Marks

4. Write SQL queries for the following questions and execute them on the database you created in Question 4.

 Include screen shots of the outputs and all SQL statements you used to answer following questions this model using MS SQL Server by creating these tables and Relationships.   Populate these tables with appropriate data, at least 3 records in each table.

1. Details of doctors registered at Knox private    (3 Marks)

1. The management is interested in knowing Name and address of patients who are older than 60 years.  (3 Marks)

1. Explain how to formulate a query to print Prescription of a patient.

Hint : You need to print patient name, drugs and doctor’s ID by using a suitable query. (4 Marks)

Marking criteria:

Example of marking criteria is shown in the following table. Marks are allocated as follows:

Section to be included in the report	Description of the section	Marks
1.
a.       identify all entities	Identify entities in all user requirements	5
b.       User Views as Tables	Represent the User Views as a collection of Tables	5
c.       Relationships	Determine the relationships between entities	5
d.       Functional dependences.	Determine Functional dependences.	5
e.       Normalise tables	Analyse above tables and normalise	10
2.
ER Diagram	Represent the structure of your database visually by using the ER diagram. Evaluate your proposed solutions	10
3.Model building	Model building on MS access	10
4. Write SQL queries	Writing queries to extract data	10
	TOTAL marks or the Report	60

Example Marking Rubric for Assignment 2 Report: Total Marks 60 for the report

Grade Mark	HD 100%		DISTINCTION 80%	CREDIT 60%	PASS 40%	Fail 0-40%
User Views as Tables	Ability to think critically and analysed clearly		Relevant and soundly analysed.	Generally relevant and analysed.	Some relevance and briefly presented.	Not relevant to the assignment question.
Relationships	Demonstrated   excellent ability to think critically and identified relationships		Demonstrated good ability to think critically and identified relationships.	Demonstrated   ability to think critically and identify some relationships	Demonstrated   some ability to think critically.	Did not demonstrate ability to think critically
Normalise	Logic is very clear and easy to follow		Logic is clear and convincing	Mostly consistent and logical	Adequate cohesion and conviction	Arguments are confused and disjointed
Dependency		All elements are present and very well integrated.	Components present and well integrated	Components present and mostly well integrated	Most components present	Representation lacks structure.
ER Diagram	Extremely good effort. All elements are present and very well integrated. Outstanding		Good effort. Most components are present and well integrated	Good effort made but not outstanding	Made some effort  with inaccuracies	Very little attempt. Lazy effort with inaccuracies
Model building and queries	Extremely good effort. All elements are present		Good effort. Most components are present	Good effort made but some components are missing	Made some effort  with inaccuracies	Very little attempt. Lazy effort with inaccuracies

E-commerce Implementation Report and Prototype Website

Learning objectives and graduate skills tested

1. demonstrate an understanding of the key drivers and challenges faced by digital enterprises that include technology infrastructure, business processes, social media, consumer behaviour and global markets (Problem solving)
2. demonstrate the ability to research and critically evaluate e-commerce business models to gain an understanding of their business application for transforming digital enterprises (Academic, professional and digital literacy)
3. demonstrate the practical skills required to formulate and evaluate a coherent plan for a digital enterprise, develop a prototype business website based on this plan and document and critically evaluate the end-product (Problem solving).
4. demonstrate the ability to write effectively in a clear and concise manner in report style for senior management (Written and oral communication)                                                                                                                                Order Now

Referencing Requirements

References are required and the Harvard AGPS standard of referencing must be used. This standard is detailed on USQ Library Site

Ensure that your reports are fully referenced , including any reference to the text book. Your report should include in text references and a List of References.

Do not repeat verbatim large slabs of information from other sources such as the text – you must put the ideas/information in your own words.

You must use at least ten (10) academically sound sources other than the textbook in completing this report.

Assignment 3 Specification

Assignment 3 requires you to present a report to discuss implementation issues in the e-commerce management sector, including further extending your prototype website from Assignment 2 to facilitate e- commerce transactions based on the same online business category as in Assignment 2.

You will be required to extend the development of your prototype website using the Joomla! content management system in. Details about setting up your website at CloudAccess.net is provided in Joomla Workshop 1.

Your implementation report and prototype website must be related to the online business category assigned to you. Failure to do so will result in your assignments being rejected and no marks will be allocated.

	Report: E-commerce Implementation	70 marks
	Report Structure and Presentation	5

Your report should include a title page, Table of Contents (including List of Tables and List of Figures if applicable) and Appendices.

Report Letter of Transmittal, Executive Summary and Introduction

5

(Introduction – approx. 250 words)

Your report should include a letter of transmittal, executive summary, and introduction to the report.

Report Section 1 – Implementation Plan (approx. 750 words)

10

The systems development life cycle (SDLC) is a methodology to understand the business objectives of an information systems and to design an appropriate information systems. Using the SDLC methodology, construct an implementation plan for the e-commerce presence for your online business.

The SDLC for an e-commerce site involves five major steps: Systems analysis, systems design, building the system, testing the system and continuing maintenance of the system. As a planning report, please list how these steps will be performed for your e-commerce website with reference to the e-commerce strategy adopted in Assignment 2.

Report Section 2 – Social Marketing Campaign (approx. 750 words)

10

The social marketing process is a series of five steps or stages: fan acquisition, engagement, amplification, community, and finally brand strength or sales.

Briefly explain the five steps and suggest how your website can assist during the five steps of social marketing campaign.

Report Section 3 – Privacy in Social Networks (approx. 750 words)

10

Your online website provides a link to social networks for better engagement with your customers. While such interactions are beneficial, your business is considering to adopt ethical ways to manage customer information on social networks.

Your business has decided to alert your existing customers regarding social network communication. You are asked to research why do social networks pose a unique problem to the issue of information privacy, and how might sharing personal information on a social site adversely affect a user? Your research findings will be emailed to your customers and hosted in your website.

Report Section 4 – Challenges in Online Retail (approx. 750 words)

10

Along with opportunities, there are unique challenges that online retailers face. Considering your online business category, describe three operational challenges that you may face, compared to offline business operations. Justify how each challenge is applicable to your business with an example.

Report: Conclusions and Recommendations to the Business (approx. 250 words)      5

Your report should include separate conclusions and recommendations sections.

• Conclusions provide a summary of your key findings from the body of the report.

• Recommendations provide a summary of the recommendations to your online business based on the implementation study conducted in the report.

Report: Referencing and Appropriateness of Sources

5

References are required and the Harvard AGPS standard of referencing must be used. This standard is detailed on USQ Library Site.

Ensure that your reports are fully referenced , including any reference to the text book. Your report should include in-text references and a List of References.

Do not repeat verbatim large slabs of information from other sources such as the text – you must put the ideas/information in your own words.

You must use at least ten (10) academically sound sources other than the textbook in completing this report.

Report: Appendix 1 Journal

10

Prepare a journal that records your activities and research related to completing this assignment. In date order, clearly list the following:

• Date of research & project activity

• Full description of activity / discussion

• Time duration of the activity

Submit this journal as Appendix 1 in the Report.

Checklist: Prototype Joomla                                                                30 marks

Ensure you setup your Joomla! website and complete the activities as listed in the checklist document. Your Joomla! Website URL should be accessible for the marker to assess the activities undertaken as per the checklist document.

1. Overall Presentation & Functionality Enhancements (5)
2. Product/ Service Catalogue (5)
3. Shopping Cart/ Enquiry Form (5)
4. Account Registration & Login (5)
5. Checkout/ Order Processing & Payment (5)
6. Discussion Forums/ Blog (5)

Data Model Development and Implementation

Assignment Description       60 Marks

Knox private  Hospital contracted with GreenIT services to develop and design their hospital database, the hospital IT Manager provided the following business rules to the GreenIT services software developer:

Complete the information-level design for the database that satisfies the following constraints and user view requirements. In order to complete this information-level design you are required to answer questions given below 1(a) – (e)

User view 1 requirement   : Patients are identified by a PatientID, and their names, addresses, and ages must be recorded.

User view 2 requirement   : Doctors are identified by a DoctorID.  For each doctor, the name, specialty, and years of experience must be recorded.

User view 3 requirement   : Every patient has a primary physician/doctor. Every doctor has at least one patient.

User view 4 requirement   : Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors.  Each prescription can have more than one drug.
                                                               Order Now

User view 5 requirement:  For each drug, identified by DrugID and the trade name and formula must be recorded. 

User view 6 requirement: Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.

User view 7 requirement: Each pharmacy has a unique name, address, and phone number.

1. Analyse the all user requirements given above, identify and list all entities described in each user requirement.       (5 Marks)

1. Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes. You are required to arrange them as given in the example below.

NB: Select suitable primary key for each table and underline them.

Eg.        Patient (PatientID, name,…….)                                                                       (5 Marks)

1. Outline all relationships between entities.

Eg. One project may belong to several departments - One-to-many,                          (5 Marks)

1. Determine the functional dependences.

Eg.  PatientID  à name, address,  ......           (5 Marks)

1. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency that causes it.  (10 Marks)

2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that doesn’t show from the problem, they must be described.

You are required to use Visio or any other software tool to create the ER diagram.  (10 Marks)

3. Build this model using MS Access by creating these tables and Relationships. Populate these tables with appropriate data, at least 3 records in each table. (10 Marks

4. Write SQL queries for the following questions and execute them on the database you created in Question 4.

 Include screen shots of the outputs and all SQL statements you used to answer following questions this model using MS SQL Server by creating these tables and Relationships.   Populate these tables with appropriate data, at least 3 records in each table.

1. Details of doctors registered at Knox private    (3 Marks)

1. The management is interested in knowing Name and address of patients who are older than 60 years.  (3 Marks)

1. Explain how to formulate a query to print Prescription of a patient.

Hint : You need to print patient name, drugs and doctor’s ID by using a suitable query. (4 Marks)

Marking criteria:

Example of marking criteria is shown in the following table. Marks are allocated as follows:

Section to be included in the report	Description of the section	Marks
1.
a.       identify all entities	Identify entities in all user requirements	5
b.       User Views as Tables	Represent the User Views as a collection of Tables	5
c.       Relationships	Determine the relationships between entities	5
d.       Functional dependences.	Determine Functional dependences.	5
e.       Normalise tables	Analyse above tables and normalise	10
2.
ER Diagram	Represent the structure of your database visually by using the ER diagram. Evaluate your proposed solutions	10
3.Model building	Model building on MS access	10
4. Write SQL queries	Writing queries to extract data	10
	TOTAL marks or the Report	60

Example Marking Rubric for Assignment 2 Report: Total Marks 60 for the report

Grade Mark	HD 100%		DISTINCTION 80%	CREDIT 60%	PASS 40%	Fail 0-40%
User Views as Tables	Ability to think critically and analysed clearly		Relevant and soundly analysed.	Generally relevant and analysed.	Some relevance and briefly presented.	Not relevant to the assignment question.
Relationships	Demonstrated   excellent ability to think critically and identified relationships		Demonstrated good ability to think critically and identified relationships.	Demonstrated   ability to think critically and identify some relationships	Demonstrated   some ability to think critically.	Did not demonstrate ability to think critically
Normalise	Logic is very clear and easy to follow		Logic is clear and convincing	Mostly consistent and logical	Adequate cohesion and conviction	Arguments are confused and disjointed
Dependency		All elements are present and very well integrated.	Components present and well integrated	Components present and mostly well integrated	Most components present	Representation lacks structure.
ER Diagram	Extremely good effort. All elements are present and very well integrated. Outstanding		Good effort. Most components are present and well integrated	Good effort made but not outstanding	Made some effort  with inaccuracies	Very little attempt. Lazy effort with inaccuracies
Model building and queries	Extremely good effort. All elements are present		Good effort. Most components are present	Good effort made but some components are missing	Made some effort  with inaccuracies	Very little attempt. Lazy effort with inaccuracies