Module Code: BM 245

Module Title: Information Management

Distributed on: Hand in Date:

Instructions on Assessment:

 

Part A is a GROUP piece of work

 

The Health and Fitness Group is a small gym that offers various fitness activities such as Group Exercise, Low Impact Aerobics, Aqua Aerobics etc. Recently they have realized that their customer numbers have increased and they want to use a database in order to capture all the Customer details (Excel File 1) and their Booking Information (Excel File 2). The Schedule file (Excel File 3) records detail of the center’s activities schedule and their details. The Employee file (Excel File 4) records details of their employees and the activities they are responsible for. ALL of these files can be found on Blackboard. Customers can reserve the session they require but due to high demand recently there have been a number of double bookings. The owner wants to provide better customer service and also reduce the stress of double bookings with his staff and therefore has decided to buy a database which will enable the business to operate more effectively. You were asked to design a prototype database in order for the owner to understand how the new system will operate and its capabilities. Therefore you are required to complete ALL the tasks below in your groups: 
健康和健身集團是一個小型健身房,提供各種健身活動,如組織運動,低沖擊有氧運動,水中有氧運動等。最近他們已經意識到,他們的客戶數量增加了,他們想要使用一個數據庫來捕獲所有的客戶詳細信息(Excel文件1)和他們的預訂信息(Excel文件2)。日程文件(Excel文件3)詳細記錄中心的活動安排和他們的細節。員工檔案(Excel文件4)記錄員工的細節和活動負責。所有這些文件都可以在黑板上找到。客戶可以保留會話他們需要但由于高需求最近已經有大量的重復預訂。業主希望提供更好的客戶服務,并減少重復預訂的壓力與他的工作人員,因此決定買一個數據庫,將使業務更高效地運作。你被要求設計一個原型數據庫為了讓業主了解新系統的運作和它的能力。因此你必須完成下面的所有任務在你的組:
 

 

1. Create the following 4 tables based on the data given and then enter the data in each table. Create the Customer table, Employee Table, Schedule Table and the Booking Table. (10 marks)

2. Establish the relationships between the 4 tables: Customer, Employee, Booking and Schedule.  Enforce referential integrity if this has not already been done. (5 marks)

3. The owner needs to provide cover for a member of staff that requested holidays. Create a Query in the Design View and list all the scheduled activities for Dave Humes between 1/10/2010 and 10/10/2010. (5 marks)

4. The owner needs to produce an invoice for a customer for the month of September. Create a Query in the Design View in order to list all the activity information and their cost for Mr. Ivan McDonald. (10 marks)

5. Create an Auto Columnar form based on the Schedule Table.  Add and format a heading in the Form Header area - ‘Schedule Details’, and re-size the fields/rearrange into a meaningful order.   (10 marks)

6. Create a Report using the Wizard showing all customer contact details and re-size the fields/rearrange into a meaningful order.   (10 marks)

 

 

Part B is an INDIVIDUAL piece of work

 

Enterprise Resource Planning (ERP) systems have become increasingly popular for assisting organizations in integrating their information.  This form of information systems has enabled more efficient business processes which cut across departmental boundaries, and enabled improved decision making, by enabling managers to access to the requisite information form specific departments.

 

Write a 2000 word assignment that covers the following:

1) An introduction to the assignment outlining the aims and objectives of the assignment.

2) A literature review of Enterprise Resource Planning systems and the costs and benefits they offer organizations.

3) A case study of a major organization which has introduced an Enterprise Resource Planning System, and a summary of the costs and benefits the organization has experienced through the implementation of the system.

X 1. Demonstrate current knowledge and understanding of the major functional areas of business.

X 2. Demonstrate current knowledge of specialist functional and professional areas of business where such specialisation is http://ukthesis.org/xxhzsglzy informed by relevant QAA benchmarks, professional accreditation requirements and applicable international educational standards.

3. Demonstrate, through the application of knowledge to business contexts and scenarios, their abilities of analysis and synthesis.

2. Skilful in the use of personal, professional and managerial techniques and processes

Objectives:

 

1. Demonstrate the acquisition and application of a range of personal transferable skills in numeracy, literacy, communication and time management. 

2. Exhibit an understanding of the needs of customers, clients and other important contacts through the demonstration of the awareness of key professional and managerial issues, problem solving and critical thinking. 

3. Apply managerial and leadership techniques, including negotiation, project management, team building and decision making to business problems appropriate to their level of study.

 

3. Employable as graduates

Objectives:

Students will be able to:

 

1. Demonstrate a range of key skills for securing graduate employment, including self presentation e.g. in CVs, interviews and assessment centres.

2. Demonstrate an active awareness of the graduate labour market in order to secure, retain and develop a graduate career.

3. Provide evidence of direct engagement with a range of graduate employers and professional bodies..

 

4. Aware of ethical issues impacting on business and professional practice

Objectives:

Students will be able to:

 

1. Demonstrate an understanding of UK and international organisations’ approaches to Corporate Social Responsibility and their implications for organisations and individuals.

2. Demonstrate an understanding of the ethical codes of professional bodies and the legal and regulatory contexts in which these operate.

3. Demonstrate an understanding of different perspectives towards organisational ethics including shareholder, stakeholder and critical approaches.

 

 

Assessment Criteria (NBS)

 

The first column indicates the general assessment criteria used within NBS the second column indicates the specific criteria used when marking your assessment.

 

 

Important note about ARNA regulations

 

The regulations specify that students must complete every assessment component contributing to the modules on their programme.  This applies to all forms of assessment as defined in the module descriptor.  Please note that:

 

• if any assessment component is not completed, students will be failed in the module even if the module pass mark has been achieved;

• if the requirements for referral specified in section 5 of ARNA1 are met, a resit opportunity will be given;

• if unable to complete an assessment component because of extenuating circumstances, students should follow the procedure described in the Student Guide to Extenuating Circumstances1.

 

This change was approved by Academic Board on 12 October 2009 in consultation with the Students’ Union.  Students should consult their Programme Leader or Guidance Tutor if they have any queries. Independent advice and support is also available from the Students’ Union Advice & Representation Centre ([email protected]) or from a student adviser in Student Services. 

 

1ARNA and the Student Guide to Extenuating Circumstances Affecting Assessed Work are available from http://www.northumbria.ac.uk/sd/central/ar/lts/assess/assproc/assdocstud/

 

Word Count

 

Students MUST declare the word count at the end of the assignment.

The word count is to be declared on the front page of your assignment.  The word count does not include title page, contents page, glossary, tables, figures, illustrations, reference list, bibliography and appendices.

Summarising and compressing the information in your assignment into the word limit is one of the skills that students are expected to acquire, and demonstrate as part of the assignment process. 

Word limits and penalties for assignments

 

If the assignment is within +10% of the stated word limit no penalty will apply.  However, if the word limit exceeds the +10% limit, 10% of the mark provisionally awarded to the assignment will be deducted.  For example: if the assignment is worth 70% but is above the word limit by more than 10%, a penalty of 7% will be imposed, giving a final mark of 63%.

 

 

Time limits and penalties for presentations

The time allocated for the presentation must be adhered to.  At the end of this time, the presentation will be stopped and will be marked based on what has been delivered within the time limit.

 

Submission of Assessment:

 

All assignments must be submitted via the Undergraduate Programme Office.  Each assignment must be accompanied by an Assessed Work Form which must be completed in full.  The assignment will not be accepted by the Undergraduate Programme Office unless the form is completed correctly.

 

Marked assignments will be returned to students.  It is advisable to retain a copy of your assignment for you own records.  Your mark will be returned on the Assessed Work Form via the Undergraduate Programme Office.

 

Referencing your work

 

The Harvard method of referring to publications and of arranging references uses the author's name and the date of the publication. References are listed at the end of the text in alphabetical order by author's name.  The general format of a journal reference is shown below:

 

Smith, J. (1999) ‘How to succeed!’, Journal of Entrepreneurs, 1 (2),pp.34-56

 

Author/s name and initials are listed first, followed by year of publication in brackets.  Then there is the title of article and the journal where article appears, which is in italics.  Finally, state the volume and issue Number (in brackets) along with the pages where article can be located.

For further information, access the Referencing web page found on the Library website: 

www.northumbria.ac.uk/helpguides

You will find other useful help guides on the Library web pages to help you with researching and writing your assessments.

 

Plagiarism and Cheating

 

Your attention is drawn to the University’s stated position on plagiarism. THE WORK OF OTHERS, WHICH IS INCLUDED IN THE ASSIGNMENT MUST BE ATTRIBUTED TO ITS SOURCE (a full bibliography and a list of references must be submitted).

Please note that this is intended to be an individual piece of work.  Action will be taken where a student is suspected of having cheated or engaged in any dishonest practice.  Students are referred to the University regulations on plagiarism and other forms of academic irregularity.  Students must not copy or collude with one another or present any information that they themselves have not generated.

 

 

Mapping to Programme Goals and Objectives:

 

This assessment will contribute directly to the following Undergraduate programme goals and objectives.  (Insert an ‘X’ in boxes where applicable)

 

1. Knowledgeable about the theory and practice of international business and management

Objectives: 

Students will be able to:

 

Note: For those assessments or partial assessments based on calculation, multiple choice etc.  Marks will be gained on an accumulative basis.  In these cases, marks allocated to each section will be made clear.

 

Students must retain an electronic copy of this assignment and it must be made available within 24 hours of them requesting it be submitted.