Reference no: EM132475638

COSC510 - Software Project Management Assignment - University of New England, Australia

Assessment 1 - Short essay (1,000 words)

Identify and investigate a major software project failure. The cause of the failure must be related to issues in the management of the project. Provide a succinct essay specifying:

a) Project objective(s)

b) Project failure(s)

c) Impact(s) of the project failure(s)

d) Factors which resulted in project failure(s)

e) Lessons learned for future projects.

Assessment 2 - UFO Tracker

Aims -

Develop a piece of software that matches the task description.

Solve problems and design software solutions using a high-level programming language and a range of technologies, protocols and algorithms.

Build a program with visual elements.

Move an object around the screen.

Description -

Intelligence agencies have been unsuccessfully tracking an identified flying object (UFO) for months now. The UFO appears to have advanced cloaking devices and is moving quite quickly while scanning objects all over the globe. Due to recent advances in technology your team of engineers have managed to track the trajectory of the object and have successful identified it's shape. The origin of the object is unknown and your role is highly classified.

Your mission is to develop a graphical user interface (GUI) that provides a visual representation of the object and it's trajectory. You should report back the trajectory as text to the console as well. Potential trajectories include, North-East, South-East, South-West and North-West. Artists have provided images that you can use, good luck and happy coding!

Task - Your task is develop the graphical user interface using the Processing environment. The specific implementation details and images, as well as skeleton code are provided, but if you wish to add any further details or use additional/alternative images, you are free to do so.

The first task will be to get the images to appear on the screen and to give the interface a screen size that works with the background image.

Once this is complete, try to get the image object to move around the screen.

As this is a fictional exercise, the starting position can be random, while the starting trajectory can be fixed.

The interface will be restriction to a bounded 2D space, for this reason the object should bounce off the sides of the containing window and return in the opposite direction.

The object only needs to move in 4 directions, North-East, South-East, South-West and North-West.

Five marks have been allocated to any further effects you might want to add, this part is entirely up to you.

Assessment 3 - Theory Assignment

Aims -

Communicate technical concepts in natural language.

Demonstrate an understanding of Unix commands.

Use group work to examine both sides of an argument.

Explain the history and/or ethics of information technology, including concepts related to intellectual property, and how they have shaped the current day.

Introduction -

In this assignment, you will individually demonstrate an understanding of Unix commands and, in pairs, explore some history and/or ethical issues related to free software.

Task Description - Individual Task - UNIX Commands

1. For each of the following, write a command to perform the given task:

1. Display the system manual for the command date

2. List the contents of the current directory, sorted by file size, from largest to smallest

3. List the contents of the info subdirectory of the current directory

4. Rename the file info.txt to 2020-01.info

5. Move the file 2020-01.info to the info subdirectory of the current directory

6. Display the entire contents of info/2020-01.info to the terminal

7. Display the first 8 lines of info/2020-01.info to the terminal

8. Display the last 2 lines of info/2020-01.info to the terminal

9. Display the contents of info/2020-01.info one page at a time

10. Delete the file info/2020-01.info

2. For each of the following, use English to explain the given commands. You can assume that all referenced files exist and no errors occur. (Note: The man command might be useful for these questions):

1. echo info/2020-01.info

2. wc info/2020-01.info

3. grep INFO info/2020-01.info

4. grep INFO info/2020-01.info > info.txt

5. head info.txt

6. grep INFO info/2020-01.info | tee info.txt | head

7. ls *o.txt

8. ls *[oO].txt

9. ls *[oO]?.txt

10. ls *[oO]*.t?t

Pair Task - Argument (500 words approx.)

You will assign yourselves into pairs using the Assignment 1 Pairs section of Moodle. You will then be given access to an Assignment 1 Pairs Discussion forum through the Assessments module of Moodle, where you can communicate with your partner. You MUST post a message introducing yourself to your partner and use the Assignment 1 Pairs Discussion forum to mutually decide which side of the following argument each of you will take.

You and your partner will each present a short argument on the following topic:

Free software should be abolished

One of you must argue that free software should be abolished, and the other that this should not be the case. You must use the above-mentioned discussion forum to clarify which side you will both be taking.

In either case, you should first define the concept of free software (as covered in lecture) and then present arguments to support your stance, citing references where appropriate to improve the strength of your claims.

Assessment 4 -

Aims -

Revise and apply the concepts relating to the relational data model.

Understand and apply Entity-Relationship and Enhanced Entity-Relationship modelling to database design scenarios.

Revise some of the basic SQL DDL clauses/statements.

Instructions -

Your answers should be presented in a word-processed document.

This assignment is maked out of a total of 10 marks, with marks for each part indicated.

All diagrams should be constructed using image manipulation software such draw.io or Paint.

All content should be organised in a clear and readable fashion - Marks will be deducted if I can't follow your assignment.

Question 1 - a) Explain the differences between logical data-independence and physical data-independence?

b) Describe the key components/modules of a database management system and their interactions.

c) Explain what a domain, attribute, tuple and relation are within the context of the relational model.

d) You have designed a database table for storing information about people. The primary key for this table is a combination of the first name, last name and middle name fields. At the time of creation, the middle name for some people is not known and you intend to insert NULL values into this field for these records. Are there any issues with this approach and if there are, what solutions can be applied?

Question 2 - Consider the following scenario:

An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many other products. Each of these products has a name and a unique ID number associated with them.

Components to make these devices can be purchased from a single vendor or from multiple vendors. Each component has a name, unique ID number and may include a component description (this information is optional).

The manufacturer sells its products to commercial buyers and also directly to consumers. The manufacturer keeps track of the name, address and phone numbers of the commercial buyers. Only the postcode for non-commercial buyers is stored.

a) Your first task is to construct an Entity-Relationship diagram that captures entities and their relationships. You are free to make assumptions about any information that you believe is not supplied as long as you state these assumptions. (Your assumptions should not contradict the description!)

b) Translate the E-R diagram from part (a) into a database schema in SQL. * Your DDL statements should define foreign keys that reflect the relationships outlined in the scenario. * Your foreign key contains should have appropriate referential triggered actions defined. Include an explanation of the referential actions. * Make sure that you select reasonable types for each table's attributes

c) The manufacturer requires that all phone numbers from commercial buyers include the country code (e.g. for Australia this will be +61). How can you use the your database to enforce this rule? Include an appropriate SQL statement(s) in your answer.

Question 3 - Review the Enhanced Entity-Relationship diagram that describes the computer systems (Hardware and Software) currently in use with an organisation.

a) Give three reasons why subclass relationships are a necessary addition to Entity-Relationship daigrams.

b) Describe the insertion/deletion rules that would need to be applied to the superclasses of Accesssory and Computer.

c) Explained the difference between disjointed, overallapping and union constraints.

Attachment:- Software Project Management Assignment File.rar