Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

FPTGreenwich Univercity, Exercises of Database Programming

assm1 mon data base giup moi nguoi giai dap thac mac ve mon hoc

Typology: Exercises

2020/2021

Uploaded on 06/27/2021

tran-thanh-danh
tran-thanh-danh 🇻🇳

5

(2)

1 document

1 / 39

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Page 1
ASSIGNMENT 1 BRIEF
Qualification
BTEC Level 5 HND Diploma in Computing
Unit number and title
Unit 06: Managing a Successful Project
Assignment title
Plan and conduct a small-scale research activity
Academic Year
2021 - 2022
Unit Tutor
Ho Hai Van
Issue date
22 July 2021
Submission date
22 July 2021
Submission Format:
Format: The submission is in the form of an individual written report that shows how you have manage
the project. This should be written in a concise, formal business style using single spacing and
font size 12. You are required to make use of headings, paragraphs and subsections as
appropriate, and all work must be supported with research and referenced using the Harvard
referencing system. Please also provide a bibliography using the Harvard referencing system.
Submission Students are compulsory to submit the assignment in due date and in a way requested by the
Tutors. The form of submission will be a soft copy in PDF posted on corresponding course of
http://cms.greenwich.edu.vn/
Note: The Assignment must be your own work, and not copied by or from another student or from
books etc. If you use ideas, quotes or data (such as diagrams) from books, journals or other sources, you
must reference your sources, using the Harvard style. Make sure that you know how to reference properly,
and that understand the guidelines on plagiarism. If you do not, you definitely get fail
Assignment Brief and Guidance:
Introduction to theme
Internet of Things
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27

Partial preview of the text

Download FPTGreenwich Univercity and more Exercises Database Programming in PDF only on Docsity!

ASSIGNMENT 1 BRIEF

Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 06: Managing a Successful Project Assignment title Plan and conduct a small-scale research activity Academic Year 2021 - 2022 Unit Tutor Ho Hai Van Issue date 22 July 2021 Submission date 22 July 2021 Submission Format: Format: The submission is in the form of an individual written report that shows how you have manage the project. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. Submission Students are compulsory to submit the assignment in due date and in a way requested by the Tutors. The form of submission will be a soft copy in PDF posted on corresponding course of http://cms.greenwich.edu.vn/ Note: The Assignment must be your own work, and not copied by or from another student or from books etc. If you use ideas, quotes or data (such as diagrams) from books, journals or other sources, you must reference your sources, using the Harvard style. Make sure that you know how to reference properly, and that understand the guidelines on plagiarism. If you do not, you definitely get fail Assignment Brief and Guidance:

Introduction to theme

Internet of Things

The Internet of Things (IoT) is the term which refers to the ever-growing network of physical objects with embedded sensors which can connect together via the internet allowing communication to occur between these objects and many other Internet-enabled devices and systems. The IoT is quickly becoming a necessary aspect of people’s daily lives. Physical items can now sense and collect data which can be controlled through digital and smart technology. The IoT extends internet connectivity beyond traditional devices like desktop and laptop computers, smartphones and tablets to a diverse range of devices that can utilise embedded technology such as security systems, thermostats, cars, electronic appliances, lights, medical equipment etc. These devices, often called "connected" or "smart" devices, can talk to other related devices (machine-to-machine (M2M) communication) and act on the information they get from one another. Along with the many benefits there is also considerable concern over the IoT which must be overcome in order to harness the power of this free flow of information. This unit will enable students to explore the benefits of the IoT, the potential future developments, the most pressing challenges and how to overcome them. Tasks As a member of Research and Development department, you have been assigned a mini-project to find out the impact of IoT including benefit, potential future development as well as challenges to implement IoT and how to tackle them. You need to do primary research (both qualitative and quantitative research) and secondary research to find out that impact and conduct a report for your research. Even it’s a mini-project, you must apply project management (PM) techniques such as project charter with aims, objectives, cost etc. As for time management, you need to produce WBS and Gantt chart with reasonable tasks and time. A project logbook is required to provide evidence of the project development process and ongoing reflection for every week. This logbook will be needed later for your reflection and evaluation in Assignment 2. As part

provide timeframes and stages for completion. LO2 Conduct small-scale research, information gathering and data collection to generate knowledge to support the project P4 Carry out small-scale research by applying qualitative and quantitative research methods appropriate for meeting project aims and objectives M2 Evaluate the accuracy and reliability of different research methods applied.

Tables of Contents:

  • I. P1 Devise project aims and objectives for a chosen scenario.
      1. Introduction Project Management
      1. Main aim of the project
      1. List of Objectives to achieve the aim
  • communication, risk and resources................................................................................................................. II. P2 Produce a project management plan that covers aspects of cost, scope, time, quality,
      1. Project scope
      1. Project time
      1. Project communication
      1. Project rick:
      1. Project resources
      1. Project Cost:..........................................................................................................................................
  • completion. III. P3 Produce a work breakdown structure and a Gantt Chart to provide timeframes and stages for
      1. Requirement’s analysis
      1. Work Breakdown Structure
      1. Gantt chart
      1. Schedule................................................................................................................................................
  • appropriate for meeting project aims and objectives IV. P4 Carry out small-scale research by applying qualitative and quantitative research methods
      1. List of interview questions
      1. Summary about interview
      1. List of survey questions
      1. Summary about survey
      1. Evaluation about interview and Survey
  • V. Secondary research
  • VI. My References:

Project management is the process of leading the work of a team to achieve goals and meet success criteria at a specified time. The primary challenge of project management is to achieve all of the project goals within the given constraints. This information is usually described in project documentation, created at the beginning of the development process. The primary constraints are scope, time, budget. The secondary challenge is to optimize the allocation of necessary inputs and apply them to meet pre-defined objectives. The objective of project management is to produce a complete project which complies with the client's objectives. In many cases the objective of project management is also to shape or reform the client's brief to feasibly address the client's objectives. Once the client's objectives are clearly established, they should influence all decisions made by other people involved in the project – for example project managers, designers, contractors and sub-contractors. Ill-defined or too tightly prescribed project management objectives are detrimental to decision making. ➢ Software Project Management Figure 2 Software Project Management Software project management is a collection of work done by a team (may have different expertise, different work, different project time) to achieve a result. as scheduled, in the scheduled time, with a projected budget. In the terminology of Software Engineering, Software Project Management is the activities in planning, monitoring and controlling project resources (e.g., budget, people), execution time, etc., risks and project implementation process to ensure the success of the project. Software

project management needs to ensure a balance between three factors: time, resources and quality. These three elements are known as the project triangle. ❖ Phase of project management Figure 3 Phase of project management ➢ Initiation: The project initiation phase is the first stage of turning an abstract idea into a meaningful goal. In this stage, you need to develop a business case and define the project on a broad level. In order to do that, you have to determine the need for the project and create a project charter. The project charter is an important document consisting of details like the project constraints, goals, appointment of the project manager, budget, expected timeline, etc. ➢ Planning: The project planning stage requires complete diligence as it lays out the project’s roadmap. Unless you are using a modern project management methodology like agile project management, the second phase of project management is expected to take almost half of the entire project’s timespan. In this phase, the primary tasks are identifying technical requirements, developing a detailed project schedule, creating a communication plan, and setting up goals/deliverables. ➢ Project execution: The project execution stage is where your team does the actual work. As a project manager, your job is to establish efficient workflows and carefully monitor the progress of your team.

 Evaluation of "connected cars" system engineering applications in IoT adoption in the auto industry

  1. List of Objectives to achieve the aim ➢ Title: IoT in Automotive Industry (Connected Cars) ➢ Introduction: With an annual production of more than 70 million units, the automobile sector is one of the biggest manufacturing industries in the world. According to an international estimate, the global turnover of the automobile industry in 2017 was an astonishing 3 trillion dollars, amounting to a combined global GDP of 3.65%. However, the total number of annual sales in automotive units is somewhat fixed since 2016. Yearly car sales have been wavering between the range of 75 to 80 million units for the past four years. One of the reasons due to which the automotive industry is unable to make a breakthrough in its annual production and sales record is due to the lack of innovative features in vehicles. Buyers nowadays look for more than 4 tires and a steering wheel in a car. They seek for a futuristic vehicle with which they can connect and interact. Internet of Things is one such disruptive technology that is helping automobile sector to build a batch of next-generation vehicles. The advent of IoT in automotive industry has opened new avenues for carmakers and buyers all across the world. With usage at both industrial and commercial level, IoT in automotive sector has become a prominent hotspot for variegated multi-purpose applications. From connected cars to automated transport systems, the applications of Internet of Things have made a deep dent in the global automotive market. ➢ Connected Cars:

Figure 4 Connected Cars Connected cars are part of IoT, a phrase used to refer to the days when consumer goods are connected to the internet with the goal of making life easier. A connected car is a vehicle that has its own connection to the internet, usually via a wireless local area network (WLAN) that allows the vehicle to share internet access and data with other devices inside and outside the vehicle. Connected cars don’t only connect with people and services – they can also connect with each other and the road network’s infrastructure. These attributes will become more important as self-driving cars appear. Connected cars facilitate fast transmission of data and increase drivers’ response time through enhanced vehicle communication. Based on the vehicle’s connection with different objects, the CV2X is sub-divided into four categories:

Self-driving cars will use information from cameras, lasers and radar to create a 3D digital map of their surroundings. They will also communicate with the cars around them to gain more information about whether they’re going to make a turn, accelerate or brake. In effect, the ability to do this lets the self- driving car see through the ones around it and anticipate their movements. They will also be able to get information from traffic lights, road signs, lane markings and roadwork sites to give you a heads-up about a traffic jam or sharp bend in the road before you can see it. Many car makers and technology companies are working on creating self-driving cars. Some production cars already have some semi-autonomous capabilities that promote safety, such as automatic emergency braking, lane-keeping assistance, blind spot monitoring, adaptive cruise control and cross-traffic alert. II. P2 Produce a project management plan that covers aspects of cost, scope, time, quality, communication, risk and resources.

  1. Project scope Figure 6 Project Scope Management This is a project that our team undertakes and must hand over within 65 days from the date of commencement and according to schedule. A very important task, it will decide if my team can meet the assigned requirements. or not. This software product must at least satisfy and support at least 15, customers who will use the service through an Internet connection by logging into the portal we created.

Moreover, customers will learn about all aspects of it, its benefits, future growth potential as well as challenges for IoT implementation and how to solve them.

  1. Project time Figure 7 Project Time Management Activity Estimated duration Select project manager 1 weeks Data collection 6 days Literature survey 6 days Develop scope statement 6 days Create WBS 6 days Develop and refine other plants 1 weeks Data analysis 15 days Complete report 12 days Total 65 days (2 months 5 days)
  1. Project rick: Figure 9 Project Risk Management Name of rick Priority Suggestions Project schedule 2 nd (^) Project planning Work Breakdown Structure (WBS) Get the job done quickly - with the right people - on time Budget project 1st Regularly reviewing your current resource and needs forecast will help keep your project budget on track. Human resource 3rd (^) Improve working environment. Human resource development. Policies to attract human resources
  1. Project resources Figure 10 Project Resource Management No Resource Name Work Details May- 14 June- 28 July- 15 July- 19 1 Truong Van Hieu 350hrs Work 1 35h 150 h 30 h 35 h 2 Tran Thanh Danh 37 5hrs Work 150 h 125 h 75 h 125 h 3 Nguyen Thi Tien Cuong 445 hrs Work 15 0h 145 h 95h 55 h 4 Truong Thanh Phu 39 0hrs Work 1 25h 45 h 175h 45h
  2. Project Cost: Figure 11 Project Cost Management
  1. Work Breakdown Structure
  2. Gantt chart 14-May-21 24-May-21 3-Jun-21 13-Jun-21 23-Jun-21 3-Jul-21 13-Jul-21 23-Jul- 1.Initiating 1.1 Select project manager 1.2 Data collection 1.2.1 Interview 1.2.2 Survey 1.3 Literature survey 2 Planning 2.1 Risk plan 2.2 Create WBS 2.3 Change plan 3 Executing 3.1 Concept 3.2 Data analysis 3.3 Review statistical tests 4 Monitoring and controling 4.1 Resource management 4.2 Cost management 4.3 Risk management 5 Closing 5.1 Complete Report 5.2 Audit
  1. Schedule Task Name Start date Duration End date Resource Name 1.Initiating 1.1 Select project manager 14 - May- 21 2 16 - May- 21 Hieu,Danh 1.2 Data collection 15 - May- 21 5 20 - May- 21 Cuong 1.2.1 Interview 17 - May- 21 3 20 - May- 21 Cuong 1.2.2 Survey 16 - May- 21 3 19 - May- 21 Phu 1.3 Literature survey 15 - May- 21 3 18 - May- 21 Hieu,Danh 2 Planning 2.1 Risk plan 18 - May- 21 10 28 - May- 21 Hieu,Cuong 2.2 Create WBS 19 - May- 21 5 24 - May- 21 Danh 2.3 Change plan 23 - May- 21 11 3 - Jun- 21 Phu,Cuong 3 Executing 3.1 Concept 30 - May- 21 21 20 - Jun- 21 Danh,Phu 3.2 Data analysis 7 - Jun- 21 24 1 - Jul- 21 Cuong,Phu 3.3 Review statistical tests 29 - Jun- 21 20 19 - Jul- 21 Hieu 4 Monitoring and controlling 4.1 Resource management 20 - May- 21 10 30 - May- 21 Hieu,Danh 4.2 Cost management 22 - May 15 6 - Jun- 21 Hieu 4.3 Risk management 5 - Jun- 21 29 4 - Jul- 21 Cuong 5 Closing 5.1 Complete Report 5 - Jul- 21 4 9 - Jul- 21 Phu 5.2 Audit 7 - Jul- 21 6 13 - Jul- 21 Danh,Phu 5.3 Document handover 11 - Jul- 21 5 16 - Jul- 21 Hieu