All posts by : chebby

Please go through the pdf file named Assignment 1 that contains the main problem set to be answered. The remaining files are provided for reference to the course material please go through them. 

Chapter 7 – Read the Running Case at the end of the chapter.
Each team member will complete the 3 tasks for this case project and submit individually.

Running Case Chapter-7:

You and your team are continuing your work on the Global Treps Project. Your project sponsor,

Dr. K., has asked you to refine the existing cost estimate for the project so you can evaluate

supplier bids and have a solid cost baseline for evaluating project performance. Recall that

your schedule and cost goals are to complete the project in six months for under $120,000.

You planned to use up to $50,000 total to pay yourself and your team members, and your initial

estimates were $30,000 for travel expenses, $20,000 for hardware and software, and $20,000 for

organizing four events, including consultants, legal/business fees, etc.

Tasks:

1. Prepare and print a one-page cost model for the project, similar to the model provided in

Figure 7-2. Use the following WBS or the WBS you developed in Chapter 5, and be sure to

document your assumptions in preparing the cost model. Assume a labor rate of $20/hour

for yourself (the project manager) and team members (Kim, Ashok, and Alfreda). You will pay

Bobby, your IT guy, $30/hour. The project will fund refreshments for the four shark tank like

events and prizes for the winners, at a cost of $1,000 for each event.

1.1 Project management

1.2 Hardware (3 laptops and Internet access for Kim, Ashok, and Alfreda)

1.3 Software

1.3.1 Outsourced

1.3.1.1 Domain name and site hosting

1.3.1.2 Donation acceptance feature of website

1.3.1.3 Video creation for website

1.3.2 In-house Development

1.3.2.1 Guidelines and templates for events

1.3.2.2 Acceptance of ideas for needed new products or services

1.3.2.3 Custom site for 20 events

1.3.3 Testing

1.4 Business Plan

1.4.1 Internal labor

1.4.2 Legal information/assistance

1.5 Travel

1.6 Events

1.6.1 Internal labor

1.6.2 Consultant labor

1.6.3 Refreshments

1.6.4 Prizes

2. Using the cost model you created in Task 1, prepare a cost baseline by allocating the costs

by WBS for each month of the project.

3. Assume that you have completed three months of the project. The BAC was $120,000 for

this six-month project. You can also make the following assumptions:

PV $60,000

EV $55,000

AC $50,000

a. What is the cost variance, schedule variance, cost performance index (CPI), and

schedule performance index (SPI) for the project?

b. How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget

or over budget?

c. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project

performing better or worse than planned?

d. Use the SPI to estimate how long it will take to finish this project.

e. Sketch an earned value chart using the information from your answers to parts a through

d. Use Figure 7-6 as a guide.

Chapter 8 – Read the Running Case at the end of the chapter.
Each team member will complete tasks 1 and 2 for this case project and submit individually.

Running Case Chapter-8:

Part 5: Project Quality Management

The Global Treps Project team is working hard to ensure they meet expectations, especially

for the people who will be holding and participating in the four events. The team has a detailed

scope statement, but you want to make sure you are not forgetting requirements that might affect

how people view the quality of the project. You know that the project’s sponsor and other key

stakeholders are most concerned with getting people to use the new website, having successful

events, and helping promote entrepreneurship across the globe. You also know that various

geographic and cultural issues will need to be addressed.

Tasks:

1. Develop a list of quality standards or requirements related to meeting the stakeholder

expectations described in the running case. Provide a brief description of each requirement.

For example, two requirements related to the new website might be that users can read

the content in several different languages and that users provide good ratings for the online

video training.

2. Based on the list you created for Task 1, determine how you will measure progress on

meeting the requirements. For example, you might have people take a survey after they view

the online training videos to collect feedback.

 ***I attached text book for reference. Question is from Chapter-7 & Chapter-8***** 

Need to complete given Tasks in both cases. Please take care of Plagiarism.

 In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements.
You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.
You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.
The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors, and at different wholesale prices.
Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor’s serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title, and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop and the information from these catalogs must be included in the database.
Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the academy awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.
There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and academy awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People’s Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.
Using this information, you should:
Step 1) (7 points) Determine and list your entities. Then create relationship sentence pairs between those entities that are related. You should not have any many-to-many relationships.
Step 2) (13 points) Create an entity/relationship diagram (ERD) showing all your entities, attributes, and relationships. Sketch your ERD by hand or use a drawing program. Your diagram must beon a single page. All entities should be relatated to at least one other entity. Your ERD should have all one-to-many relationships and not have any many-to-many relationships.
Step 3) (5 points) Create metadata that describes the table created from each entity and the column created from each attribute in the ERD. Particular attention will be given to the proper specification of all primary key (via “PK”) and foreign key (via “FK”) columns in the table layouts. These should match your ERD exactly.

Contingency planning is a risk mitigation process for developing back-up plans in anticipation of events (scenarios) that might disrupt ‘business as usual’. Business continuity planning is an expanded version of contingency planning that typically encompasses a more comprehensive and extended response plan for getting back to ‘business as usual’. In a well-formatted, highly-detailed research paper, address the need to contingency planning, ensuring to address the following items:(1) Benefits of scenario events/planning.
(2) Questions to consider when implementing scenario planning.
(3) The common types of scenario planning.Your paper should meet these requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Instructions

Assume that you want to create a linked list structure

for ‘item’s. You are given

struct item

{

string data;

item *next;

item(string x, item* t)

{

data

=

X; next

= t:

7

}:

In our implementations we used first and last

pointers to keep first items and last item of linked list.

Once we add new item, a new structure is created

and added as last item.

Assume that we have only first pointer, and do not

have last pointer. Complete the following function to

add an item to at the beginning (front) of Linked

Listed using only “first” pointer. Just submit function

implementation, not the whole program.

bool Bag::insertFront(string str)

{

}

NOTE: **** post answers in separate documents for each Question

      **** Please follow the instructions to

1. Describe DBLC (Database Life Cycle) and its phases.
2. Describe concurrency in a DBMS and how it is managed.

For the following tables write the required SQL statements:

3. Write an SQL statement to create the PET table.

4. Write an SQL statement to show the breed and type of all pets.

5. Write an SQL statement to display the breed, type, and DOB of all pets having the type Dog.

6. Write an SQL statement to show the pet owner first name, last name, and pet name. Hint: you need to link PET_OWNER and PET tables.

 project:

A factory has several departments. A department may have many employees but must have at least seven. Every employee works for one and only one department. Every department has a manager — only one manager per department. A manager is an employee of the company, but not all employees are managers. A department may have many machines, and every machine is assigned to a specific department. Products are produced on machines. A product can be an assembly of several different components or a single piece. Every product goes through one or more machines for appropriate production operations. Likewise, several products may go through a particular machine for a production operation. The employee has a first name, last name, and middle name, gender, address, and salary. An employee number uniquely identifies an employee. Departments have departments name, type, and location. The department’s name and number are both unique identifier of a department. Every machine will have a unique machine number, name, type, and vendor’s name.

When a machine goes for maintenance, the date of maintenance must be captured, since a maintenance activity is identified by the date of the maintenance for each machine. The attributes of maintenance activity are time taken and cost.
A product is identified by its component ID, component name, and description.

7- Create an ERD by first identifying the entities, then their relationships, and finally add the attributes to each entity.

8- Create a logical data model from ERD, including primary and foreign keys.

9- Implement the logical model into a DDL and build the database in SQL Server (or any other DBMS that you have installed)

10- Create some synthetic data and insert the data into the database.

 Lists and dictionaries are two of the most popular abstract data types in Python. Like most data types, each has its own specific uses in code. This week we will concentrate on lists.   

• Describe what a list is in your own words.  
• Provide reasons as to when it makes sense to use it in your code.   
• Give an example of data that you feel is a good candidate for being stored in a list.
• Be sure to post a substantive response to one of your classmates’ posts and cite any resources used.

For this project, select an organization that has leveraged Cloud Computing technologies in an attempt to improve profitability or to give them a competitive advantage. Research the organization to understand the challenges that they faced and how they intended to use Cloud Computing to overcome their challenges. The paper should include the following sections each called out with a header.

• Company Overview: The section should include the company name, the industry they are in and a general overview of the organization.
• Challenges: Discuss the challenges the organization had that limited their profitability and/or competitiveness and how they planned to leverage Cloud Computing to overcome their challenges.
• Solution: Describe the organization’s Cloud Computing implementation and the benefits they realized from the implementation. What was the result of implementing Cloud Computing? Did they meet their objectives for fall short?
• Conclusion: Summarize the most important ideas from the paper and also make recommendations or how they might have achieved even greater success.

Check attachments!!!