Post University Management Discussion

Comment on my classmates posts.

topic: work vs production breakdown

1. The work break structures are used primarily in projects that are tangible such as phones, tablets, and PCs. They break down the product into deliverables. Deliverables are essentially major pieces of the projects. Subdeliverables are pieces of the deliverables. For example, a Samsung TV. The Samsung Tv is the project. The Samsung Smart TV consists of 2500 high-tech components, which are assemblies of TV hardware and software technologies. (Smart TV: Piece by Piece, n.d. ) They break down the creation of the tv into 25 deliverables. One deliverable in the jack/tuner. Subdeliverables of the jack/tuner would be the HDMI ports, tuner, and USB ports.

The product breakdown structure is used in more non-tangible projects like software infrastructures. The breakdown of products by phases. ?The software industry often refers to a PBS as the ?waterfall method,? since progress flows downward through each phase.1?(Larson & Gray, 2018)

2. From research I’ve learned that a work breakdown structure is a visual, hierarchical, and deliverable-oriented deconstruction of a project. It is a helpful diagram for project managers because it allows them to break down their project scope and visualize all the tasks required to complete their projects. Work breakdown structure in project management is a method for completing a tumultuous project. You can say it’s in the phrase of divide and conquer for large projects to get things done in a faster and more efficient way. As for Product Breakdown Structure, it is a hierarchical structure of things that the project will make or outcomes that it will deliver. It can be thought of as the project “shopping list.” It decomposes a “Main Project Product” into its component parts in the form of a hierarchical structure.The Product Breakdown Structure is supported by a “Product Log” which is a list of producets and associated Product Descriptions that describe individual products in more detail. This enables quality expectations and responsibility for approval to be clearly identified at an early stage in the project life cycle. A product breakdown structure, for example, can be used to identify all of the features of a new mobile app and prioritize which ones should be produced first, if you’re planning on launching a new app and which ones can wait.

2nd topic: cross join

1. A CROSS JOIN is a JOIN operation that produces the Cartesian product of the sets of records from the joined tables. In other words, for each row in table A, the CROSS JOIN produces a row in the result set combined with each row from table B. This means that if table A has m rows and table B has n rows, the result set of the CROSS JOIN will have m * n rows.

CROSS JOINS are not very common in SQL because they do not usually produce valuable results. However, there are some situations where a CROSS JOIN can be helpful. For example, if you want to create a list of all the possible combinations of items from two different lists, a CROSS JOIN would be the best way to do this.

Another example where a CROSS JOIN might be helpful is if you want to find all the rows in a table that do not have a matching row in another table. This can be done with a LEFT JOIN, but it is sometimes easier to understand the query if it is written as a CROSS JOIN with a WHERE clause that checks for NULL values.

Overall, CROSS JOINS are not something you will use very often, but it is essential to be aware of them in case you come across a situation where they would be the best solution.

Examples:

SELECT *

FROM table1

CROSS JOIN table2;

2. The CROSS JOIN SQL function creates a new table from two chosen tables by using the Cartesian Product of those two tables. (Coronel & Morris, 2018) The Cartesian Product can be seen as the product of each line in one table multiplied by the other. (Coronel & Morris, 2018) For instance, if we had two tables each with one column and two rows of 1 and 2, with that being the only data, a CROSS JOIN of the two tables would result in a table with one column and 4 rows of the data 1, 2, 2, 4. You can see the results are a1*b1, a1*b2, a2*b1, a2*b2. Of course, this is a simplified example as the data would actually be pulled from a set of strings and those strings would be combined instead, but I felt that this illustrated the properties of the CROSS JOIN function effectively.

The example syntax for using CROSS JOIN is ?Select column-list FROM table1 CROSS JOIN table2.? (Coronel & Morris, 2018, pg. 264) For this, you would substitute which columns you would like to join from table 1 with table 2.