Reference no: EM132302145

Assignment 1

Database Design & Development - Hostel management System

Purpose of this assignment

Database is a crucial part of most of the organizations. Database is defined as the skeleton of any application. An understanding of database tools and technologies is an essential skill for designing and developing systems to support them. The assignment provides opportunities to the students to develop an understanding of the concepts and issues relating to database design and development and to extend the practical skills to translate that understanding into the design and creation of complex databases. The completion of the assignment will make sure that the students have been able to use appropriate tools to design and develop a relational database system for the substantial problem. The students will have an opportunity to test the system ensuring that user and the system requirements are met. And also, fully document that system by providing the technical and user documentation.

The completion of the assignment will demonstrate that that the student has been able to:

• Use an appropriate design tool to design a relational database system for a substantial problem.
• Develop a fully functional relational database system, based on an existing system design.
• Test the system against the user and system requirements.
• Produce technical and user documentation.

Each student has to submit their assignment as guided in the assignment brief. The students are guided what sort of information is to be produced to meet the targeted criteria. All the tasks need to be done individually and the student has to produce an individual assignment.
Unit Learning Outcomes targeted in this assignment
LO1: Use an appropriate design tool to design a relational database system for a substantial problem.
LO2: Develop a fully functional relational database system, based on an existing system design.
LO3: Test the system against user and system requirements.
LO4: Produce technical and user documentation.

Scenario I

A Hostel management has maintained their hostel information in spreadsheets and they are storing information in regular basis. They have recorded information like student record, fees, mess and visitor in separate sheets. Referring to the multi-user property, every person must update their own spreadsheet with new data. For instance, if there is a new student to register or a last name in the "Student" sheet to correct, every user must make these changes manually. You would justifiably think Google Docs and the latest versions of Office solve this issue, but they do so only partially. In Google Docs, you might have trouble finding out who changed or deleted information incorrectly, which often leads to a cumbersome situation where people have a hard time organizing their tasks.

Access to a spreadsheet is sometimes limited to one person at a time. As we know that with database management systems, however, several people can access the same data set. Such systems manage editing of data so that two people cannot alter the same data values at the same time. This preserves data integrity, which is harder to manage when using spreadsheets.

Most of the small institution or hostels are maintaining their information in traditional approach i.e. spreadsheet and flat files. Out of them, one of the ISMT Hostel has decided to automate and centralize their information related to Student, Fees and hostel using database management system that would perform the following operations:

• Keep data in a properly organized way and provide greater efficiency to the end user.
• Track the stationery stock and sales that has been generated previously.
• Allow multiple users with different roles like Administrator, Supervisor, Normal User etc
• As the application might store sensitive information security features should be implemented for the access and authorization.
• Reduce daily work as most of the things will be accomplished automatically.

While designing a database we should consider probable future expansion of the proposed system. So, the proposed system might be used in different Co-location in a distributed environment and might have multiple databases to be merged or migrated in a single system. To overcome this locking situation in future, every row in a table should be uniquely identified by global unique identification.
To achieve above described objectives, at least following different entities should be created in proposed database system. And you are encouraged to add other related entities you think required in system. One GUID column should be assigned in each table.
• User details with username and password (password should be stored in encrypted format)
• Roles with Role ID, Role Name, Created On, Created by etc.
• Student details with Studentid, name, fathername, age etc.
• Hostel details with Building_Number, No_Of_Rooms, Students, Location etc.
• Fees details with Fee_Month,Fee_Status,
• Rooms details with RoomId, Capacity, Building Number etc.
• Visitor details with VisitorId, Visitor_Name, TimeIn, TimeOut, Date etc.
• Mess_Employee withEmployeeId, Employee_Name, Salary, Contact, MessIncharge

For the reporting purpose and to minimize the SQL injection hacking, you will have to create some stored procedures as follows:
• User Authentication (validate authenticate user while trying to get access in the system)
• Create Trigger; if student has been allotted a room then capacity should decrease in Rooms table.
• Create procedure to get the defaulter name whose fees have not been paid at the end of month.
• Create report to get visitors visited details at the end of the month

Assuming that you have been hired a junior database administrator you are required to perform the following operations that are tabulated below.

Based on the context above, complete the followings.

Part 1

Before you start the development process, your manager has asked you to produce a report for the CEO of the given company, containing:

1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.

2. Clear statements of user and system requirements.

You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization.
Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements.

Part 2

Once the designs have been accepted by your manager you have been asked to develop the database system using evidence of user interface, output and data validations and querying across multiple tables.

You want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features.
• You have decided to implement a query language into the relational database system.
• The developed system will be demonstrated to your manager.
• Your manager has asked you to produce a report including the followings:

1. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.

2. Evaluating the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.

3. Once the system has been developed, you will test the system and your manager will complete a witness statement indicating how your tests are performing against user and system requirements.

4. You will produce a brief report assessing the effectiveness of the testing, including an explanation of the choice of test data used.

Part 3

1. Lastly you will produce technical and user documentation which will be given to the company.

2. You want to provide some graphical representations for ease of reference in the technical guide, so you have decided to produce a technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.

Assignment 2 - NMB Bank Network System

Purpose of this assignment

Computer networks have become the essence of our daily lives. Computer networks are the driving force behind the evolution of computer systems allowing users to access data, hardware and services regardless of their location. The major purpose of this assignment is to provide the students an opportunity to exhibit their knowledge in the field of computer networking, how the network operates, protocols, standards, security considerations and the prototypes associated with a range of networking technologies.

The assignment will help the students to check their knowledge for configuring the and installation of networking system exploring the range of technologies and troubleshooting the network. The students will be able to demonstrate their skills and understandings over the operation of IP data networks, router, switching technologies, IP routing technologies, IP services and troubleshooting through the completion of this assignment.

Besides technical stuffs, the students will be demonstrating their skills such as communication literacy, critical thinking, analysis, reasoning and interpretation, which are crucial for gaining employment and developing academic competence.

The completion of this assignment will illustrate that the student has been able to:

• Examine networking principles and their protocols.
• Examine networking devices and operations.
• Design efficient networked systems.
• Implement and diagnose networked system.

There are two parts based on the scenario. You are required to contextualize the task as per the given scenario wherever possible.
Each student has to submit their assignment as guided in the assignment brief. The students are guided what sort of information is to be produced to meet the targeted criteria. All the tasks need to be done individually and the student has to produce an individual assignment.

Assignment submission format

Each student has to submit their assignment as guided in the assignment brief. The students are guided what sort of information is to produce to meet the criteria targeted. Some tasks might require group work, but the student has to produce individual assignment.

Scenario I

NMB Bank Limited also known as NMB Bank is a public owned bank in Nepal. NMB bank was established in June 1990 with and authorized capital of Rs. 140 million and paid up capital of Rs. 50 million.

The head office of the bank is located in Tinkune -31, Kathmandu. The bank has a network of 35 branches and, 7 Branchless banking and 33 ATM terminals. NMB Bank also provides banking services through E-Banking, and mobile banking viz. NMB SMART. Recently, the bank signed an agreement with Khalti Digital Wallet in Nepal to facilitate digital payments to its customers.

The organization has recently made a decision of opening a new branch in New Baneshwor in order to facilitate general public with its financial services. For the given branch, central office has decided with the following structure of the office.

There are five departments with following responsibilities and infrastructure:

IT Department: It is the department with core responsibility of managing, configuring and maintaining the IT infrastructure of the branch office. Network and System management, configuration of server

features and services, network planning, design and implementation, etc. are the main functionalities of this department. There is infrastructure for IT officer and Assistant IT Officer available in the bank.

Finance Planning Department: This department is responsible for financial planning of the bank. It comprises of Finance Officer along with other three lower level officers responsible for the operation of finance department.

HR Department: This department is responsible for managing and optimizing the work force of the branch. Hiring, firing, capacity development of working personnel, etc. are some of the main responsibilities of the bank. It comprises of a HR Officer allowing with an assistant officer for its operation.

Management Department: This department is solely responsible for operational management of the branch office. It comprises of a Branch Manager and other two personnel for its operation.

Account Department: This department is responsible for handling all the accounts of bank. Regular internal audit and monitoring of account is done by this department. It comprises of Account Head and other two account staffs for its operation.

You have been hired as and IT officer in the IT Department and your major roles and responsibilities are to Plan, manage, design, implement and optimize the network system for the bank considering IP addressing, Server System, various other services, Network devices, Security devices etc.

In order to prepare a report, your report will demonstrate that you understand the principles of network infrastructure management and able to design, implement and test complex network systems suitable to banking sector.

Part 1

LO1 Examine networking principles and their protocols.
LO2 Explain networking devices and operations.

You will need to produce a report for the CEO that includes the following:
1. An introduction to provide an overview of your report.
2. An explanation of networking principles, protocols and devices, including benefits and constraints of networked solutions, the impact of network topology, communication and bandwidth requirements, effectiveness of networking systems, operating principles of networking devices and server types and networking software.

Part 2

LO3 Design efficient networked systems.
LO4 Implement and diagnose networked systems.

This part of the assignment will contain the following based on the tasks in section 1 and section 2.

• A LAN design plan and blueprint and justification document.
• A fully completed test plan including an evaluation of results and recommendations for improvements to LAN.
• A proposed and justified maintenance schedule.
• Evidence of an implemented network.

Section 1 based on the scenario above, design efficient networked systems

1. Prepare a written step-by-step plan of how you are going to design a Local Area Network including a blueprint of your LAN.
2. Justify your choice of devices for your network design.
3. Produce a test plan to evaluate this design for the requirements of bandwidth and cost constraints as per user specifications.
4. Justify the security requirements and quality of services needed for selection of accessories.
5. Suggest a maintenance schedule to support the networked system.

Section 2 Implement test and diagnose networked systems

1. Implement a networked system based on your prepared design.
2. Conduct verification with e.g. Ping, extended ping, trace route, telnet, SSH, etc.
3. Record the test results and analyse these against expected results.
4. Investigate what functionalities would allow the system to support device growth and the addition of communication devices.
5. Discuss the significance of upgrades and security requirements in your recommendations.

Assignment 3

Professional Practice - Enhancing professional practices

Purpose of this assignment

This assignment help students to demonstrate their employability skills required for effective employment and to manage their own personal and professional development. The assignment provides an opportunity to the learners to assess and develop an understanding of their own responsibilities and performance in or when entering the workplace.

Completing this assignment you will demonstrate a range of interpersonal and transferable communication skills to a given target audience, apply critical reasoning and thinking to a range of problem scenarios, be able to discuss on the importance and dynamics of working within a team and the impact of team working in different environments and most importantly examine the need for Computing Professional Development (CDP) and its roles within the workplace and for higher level learning.

Assignment submission format

Each student has to submit their assignment as guided in the assignment brief. The students are guided what sort of information is to produce to meet the criteria targeted. Some tasks might require group work, but the student has to produce individual assignment.

Part 1: Training schedule (using project management software) for the two-day event and a training pack to include a range of activities, seminars, workshops, team-building activities and break-out sessions.

Part 2: Ten-minute Microsoft® PowerPoint® style presentation with interactive links to suitable sites and an activity sheet. The presentation slides for the findings should be submitted with speaker notes. You are required to make effective use of headings, bullet points and subsections as appropriate. Your research should be referenced using the Harvard referencing system. The recommended word limit is 600 words, including speaker notes, although you will not be penalized for exceeding the total word limit.

Part 3: A written evaluation of your performance in this task and your contribution to the team. You are required to make use of headings, paragraphs, subsections and illustrations as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. The recommended word limit is 1,000 words, although you will not be penalized for exceeding the total word limit.

Part 4: A report discussing problem-solving techniques.

Part 5: A report examining the need for CPD (continuing Professional needs)

Scenario I

Assume that you have been working as an intern in an IT company. Your key task is to support your training and development manager with the planning and implementation of a professional development event to targeted audiences.

The training event is scheduled over a two-day period at a mutually agreed venue, and will include a number of activities such as workshops, pair works, presentation and discussion. The centre requires a schedule of the types of activities proposed so that plans can be finalized. You have also been asked to design and deliver a workshop as part of the training event based on the dynamics of team working.

To effectively complete the tasks below you need to be able to apply a range of skills such as effective communicative skills, interpersonal skills, and time management skills. You need to be able to develop a specification of an identified problem, identify the tools and methods to solve the problems, plan and implement the solutions and finally be able to evaluate the problem.
Based on the context above, complete the followings.

Part 1 (work in a small group of 3 or 4 but each has to produce individual report)

1. Produce a professional schedule for a two-day event (using project management software) that identifies planning and resourcing prior to the event.

2. Design a training pack including a range of activities, seminars, workshops, team-building activities and break-out sessions. It is expected that 30 employees will attend the event. There is a large auditorium that will seat 60, and the outdoor center can accommodate 15 at any one time for activities. In addition, there are three break-out rooms, one with computers for up to 20 and two other seminar rooms that seat up to 30.

Part 2
1. Design a two-hour workshop session based on ‘team dynamics'. The workshop will include a presentation which will discuss the importance of team dynamic in the success and/or failure of a group work. You will also provide interactive links to suitable sites and prepare an activity sheet that will require delegates (trainees/ participates) to take part in some form of team-building task.

Part 3
1. Following the event, your training and development manager has asked you to provide some feedback. Produce a written evaluation of the effectiveness and application of interpersonal skills during the design and delivery process. You should also include an evaluation of your performance in this project and your contribution to the team you worked in.

Part 4
1. Produce a report discussing problem-solving and its importance in planning and running an event. Your report should include a discussion of various problem-solving techniques and justify the solution methodologies used during your project. You should also include a critique of the application of critical reasoning and your experiences of it.

Part 5

1. Having completed the Training Event Management project, you now need to reflect on your experience and consider your Continuous Professional Development (CPD) needs.

Section 1

Consider your personal and/or career goals and identify your CPD needs and what actions would put you in a position to achieve these goals. Produce a development plan outlining your future goals and identifying how these can be realized.

Section 2

Conduct some research into motivational theories and illustrate how they can be used to improve employee performance. Compare a number of theories and present your findings.

Section 3

Write a report on the usage of CPD within organizations and what evidence would be required to measure how effective this CPD is in helping employees achieve their goals while using their time and resources effectively.