Write a C++ program based on this information below

https://docs.google.com/document/d/1nM3WyAKAwJN6QHNia99ReTT50oRNXirUzEPVjtMjB1U/edit?usp=sharing

 

Refer to Ch. 3, “Pine Valley Furniture Company Background,” in Part One, “Foundations for Systems Development,” of Modern Systems Analysis and Design. In this course, there are weekly assignments incorporating Pine Valley Furniture, and you might use components from the previous week’s assignment to complete future Pine Valley Furniture assignments. 

Imagine this scenario: You work for Pine Valley Furniture. The board of directors is considering launching a WebStore and does not know what is involved in developing a new system. You have been asked to present to the board of directors to help them know what to expect.

Create a 12- to 16-slide presentation directed to the board of directors in which you:

• Explain the importance of using systems analysis and design methodologies when building an information system.
• Justify the systems development life cycle (SDLC) implementation, and explain why that’s the best option, rather than the quick and easy process.
• Summarize the criteria for selecting commercial off-the-shelf software (COTS) presented in Modern Systems Analysis and Design, Ch. 2.
• Identify additional criteria that are, or might be, used to select COTS.
• Consider if the choice was between alternate custom software developers rather than pre-written packages.
• Select appropriate criteria for comparing multiple application custom development bids.
• Briefly define each of these criteria.
• Briefly summarize the project management process.
• Explain which of the 4 project management process phases you think is most challenging.
• Explain how to mitigate the risks for that stage.

Include speaker notes and media, such as graphics or tables.

Cite any references and graphics used to support your assignment.

Format your citations according to APA guidelines.

 

1 The Problem

This assignment deals with a program places items into separate inventories.

In this assignment, you will make use of inheritance–e.g., virtual functions. You will need to complete the Armour and Consumable classes.

1.1 Input

The program reads data from one file, items-0x.txt. Each line in this file represents one item. The first item on every line denotes the Item type–the remainder of the line varies by item type.

 Tool Pickaxe Diamond 100 1 Fortune 5

  Potion Speed-II-Potion Spd*2 1

  Food Tomato Hunger-10 2

  Tool Axe Stone 10 2 Unbreaking 2

  Armour Boots Diamond 100 10 Protection 3 lightning

Each Item type is denoted by a keyword:

• Tool indicates a Tool object.
• Armour and Armor indicate an Armour object.
• Food, Potion, and Disposable indicate a Consumable object.

After the leading keywords, each line has a distinct structure:

1. The remainder of a Tool line contains–in order–a name, material, durability, speed, enchantment, and enchantment level. Tool Items are not stackable.
2. The remainder of a Armour line contains–in order–a name, material, durability, defense, enchantment, enchantment level, and element. Armour Items are not stackable.
3. The remainder of a Consumable line contains–in order–a name, effect, and # uses. Consumable Items are stackable.

1.2 Output

If the program is run with the first provided input file, items-01.txt, the following output should be generated:

Processing Log:

 (S) Speed-II-Potion

 (S) Tomato

 (S) PotatoCamera

 (S) PotatoCamera

 (S) Boots

 (S) Boots



Player Storage Summary:

 -Used 50% of 10 slots

  Nme: Speed-II-Potion

  Eft: Spd*2

  Use: 1

  Qty: 1



  Nme: Tomato

  Eft: Hunger-10

  Use: 2

  Qty: 1



  Nme: PotatoCamera

  Eft: ImageQuality-97%

  Use: 5

  Qty: 2



  Nme: Boots

  Dur: 100

  Def: 10

  Mtl: Diamond

  Mdr: Protection (Lvl 3)

  Emt: lightning



  Nme: Boots

  Dur: 100

  Def: 10

  Mtl: Diamond

  Mdr: FeatherFalling (Lvl 4)

  Emt: lightning

Note how there is no Tool output. The Tool class is not present in this assignment. The Tool class will be part of a future assignment.

Your output–including labels and spacing–must match the expected output. The easiest way to see generate the expected output is to run the sample executable solution I have provided.

Hint – each line of output in your display functions should probably start with two leading spaces.

To run this program with items-01.txt as input type:

./storage items-01.txt

(On a Windows system, you would omit the “./”. If you are running from Code::Blocks or a similar development environment, you may need to review how to supply command-line parameters to a running program.)

1.3 Your Tasks

The key abstractions employed in this program are Item, ItemStack, Inventory Armour, and Consumable.

Your overall task is to complete the Armour and Consumable ADTs.

1. As an initial step, you will need to complete the Armour and Consumable Default Constructors:
   1. Set the stackable attribute–i.e., stackable.
      Hint Remember initializer lists?
   2. Set the name attribute–i.e., Item::name. The attribute, name, is a protected data member of Item.
2. Implement Armour::clone and Consumable::clone.
3. Implement Armour::read and Consumable::read.
4. Implement Armour::display and Consumable::display.

You are expected to generate additional input files to test your code. Test your code throughly before submitting your solution.

1.3.1 Expected Initial Error Messages

If you run make without adding the missing read, clone, and display methods, you will see something simliar to

/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function

Armour.cpp:14: error: undefined reference to 'vtable for Armour'

/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function

Consumable.cpp:4: error: undefined reference to 'vtable for Consumable'

/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function

Consumable.cpp:12: error: undefined reference to 'vtable for Consumable'

/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function

collect2: error: ld returned 1 exit status

make: *** [storage] Error 1

While these errors may be intimidating, they are simply telling you to implement the necessary virtual functions for Armour and Consumable.

1.3.2 Testing Your Code

I have provided you a set of unit tests. In addition to your normal checks (e.g., running the completed program and performing head-to-head testing) run the unit tests with

make tests

./testNewClasses

You should see:

PASSED -> testDefaultArmourConstructor

PASSED -> testArmourCopyConstructor

PASSED -> testArmourClone

PASSED -> testArmourDisplay

PASSED -> testArmourRead

PASSED -> testDefaultConsumableConstructor

PASSED -> testConsumableCopyConstructor

PASSED -> testConsumableClone

PASSED -> testConsumableDisplay

PASSED -> testConsumableRead

2 Grading

In the grade report that you receive, you will see tests numbered 000 through 008.

1. Test 000 evaluates your implementation of Armour::Armour()
2. Test 001 evaluates your implementation of Armour::clone()
3. Test 002 evaluates your implementation of Armour::display
4. Test 003 evaluates your implementation of Armour::read
5. Test 004 evaluates your implementation of Consumable::Consumable()
6. Test 005 evaluates your implementation of Consumable::clone()
7. Test 006 evaluates your implementation of Consumable::display
8. Test 007 evaluates your implementation of Consumable::read
9. Test 008 (System Test) evaluates all both classes–i.e., your solution as a whole–including output and output formatting.

Do not procrastinate.

3 Files

See Attachment 

4 Submitting

Files to Submit:

• Armour.cpp–i.e., your version of the Armour ADT.
• Consumable.cpp–i.e., your version of the Consumable ADT.

QUESTION 1

 Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.1 into a dependency diagram that is in at least 3NF. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image047.jpg

  Make sure that the file is saved as ch6_problem1_deleon.doc

———————————————————————————————————

QUESTION 2 

 Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image049.jpg

  Make sure that the file is saved as ch6_problem2_deleon.doc

———————————————————————————————————

QUESTION 3

 Using the INVOICE table structure shown in Table P6.3, do the following:
SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image051.jpg

 a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.)

b. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created.

Note: You can assume that any given product is supplied by a single vendor, but a vendor can supply many products. Therefore, it is proper to conclude that the following dependency exists:

PROD_NUM S PROD_lABEl, PROD_PRICE, vEND_CODE, vEND_NAME

(Hint: Your actions should produce three dependency diagrams.)

c. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.

d. Draw the Crow’s Foot ERD. 

 Make sure that the file is saved as ch6_problem3_deleon.doc

———————————————————————————————————

QUESTION 4

 Using the STUDENT table structure shown in Table P6.4, do the following:

a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies.

b. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

c. Using the results of Problem 4, draw the Crow’s Foot ERD. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image053.jpg

Make sure that the file is saved as ch6_problem4_deleon.doc

———————————————————————————————————

QUESTION 5

 To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT Company uses the table structure shown in Table P6.5. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image054.gif

 a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies.

b. Write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.

c. Draw the Crow’s Foot ERD. 

Make sure that the file is saved as ch6_problem5_deleon.doc

———————————————————————————————————

QUESTION 6

 The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes, naming conventions are violated, and some attributes are not atomic. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image057.jpg

 a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.

b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)

c. Draw the relational diagram.

d. Draw the Crow’s Foot ERD. 

Make sure that the file is saved as ch6_problem6_deleon.doc

———————————————————————————————————

QUESTION 7

 

Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on.

• Each dinner serves many members, and each member may attend many dinners.
• A member receives many invitations, and each invitation is mailed to many members.
• A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn, or the dinner may be composed of a fish entree, a baked potato, and string beans.

Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Table P6.7.

a. Given the table structure illustrated in Table P6.7, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. (Hint: This structure uses a composite primary key.) 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image059.jpg

 b. Break up the dependency diagram you drew in Problem 7a to produce dependency diagrams that are in 3NF, and write the relational schema. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)

c. Using the results of Problem 7b, draw the Crow’s Foot ERD. 

Make sure that the file is saved as ch6_problem7_deleon.doc

———————————————————————————————————

QUESTION 8

 Use the dependency diagram shown in Figure P6.8 to work the following problems.

a. Break up the dependency diagram shown in Figure P6.8 to create two new dependency diagrams: one in 3NF and one in 2NF.

b. Modify the dependency diagrams you created in Problem 8a to produce a set of dependency diagrams that are in 3NF. (Hint: One of your dependency diagrams should be in 3NF but not in BCNF.)

c. Modify the dependency diagrams you created in Problem 8b to produce a collection of dependency diagrams that are in 3NF and BCNF. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image061.jpg

Make sure that the file is saved as ch6_problem8_deleon.doc

———————————————————————————————————

QUESTION 9

 Suppose you have been given the table structure and data shown in Table P6.9, which was imported from an Excel spreadsheet. The data reflects that a professor can have multiple advisees, can serve on multiple committees, and can edit more than one journal. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image063.jpg

 Given the information in Table P6.9:

a. Draw the dependency diagram.

b. Identify the multivalued dependencies.

c. Create the dependency diagrams to yield a set of table structures in 3NF.

d. Eliminate the multivalued dependencies by converting the affected table structures to 4NF.

e. Draw the Crow’s Foot ERD to reflect the dependency diagrams you drew in Problem 9c. (Note: You might have to create additional attributes to define the proper PKs and FKs. Make sure that all of your attributes conform to the naming conventions.) 

Make sure that the file is saved as ch6_problem9_deleon.doc

———————————————————————————————————

QUESTION 10

 The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in Table P6.10.

Table P6.10 was created to enable the manager to match clients with consultants. The objective is to match a client within a given region with a consultant in that region and to make sure that the client’s need for specific consulting services is properly matched to the consultant’s expertise. For example, if the client needs help with database design and is located in the Southeast, the objective is to make a match with a consultant who is located in the Southeast and whose expertise is in database design. (Although the consulting company manager tries to match consultant and client locations to minimize travel expense, it is not always possible to do so.) The following basic business rules are maintained:

• Each client is located in one region.
• A region can contain many clients.
• Each consultant can work on many contracts.

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image065.jpg

 

• Each contract might require the services of many consultants.
• A client can sign more than one contract, but each contract is signed by only one client.
• Each contract might cover multiple consulting classifications. For example, a contract may list consulting services in database design and networking.
• Each consultant is located in one region.
• A region can contain many consultants.
• Each consultant has one or more areas of expertise (class). For example, a consultant might be classified as an expert in both database design and networking.
• Each area of expertise (class) can have many consultants. For example, the consulting company might employ many consultants who are networking experts.

a. Given this brief description of the requirements and the business rules, write the relational schema and draw the dependency diagram for the preceding (and very poor) table structure. Label all transitive and/or partial dependencies.

b. Break up the dependency diagram you drew in Problem 10a to produce dependency diagrams that are in 3NF and write the relational schema. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)

c. Using the results of Problem 10b, draw the Crow’s Foot ERD.
 

Make sure that the file is saved as ch6_problem10_deleon.doc

———————————————————————————————————

QUESTION 11

 Given the sample records in the CHARTER table shown in Table P6.11, do the following:

a. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points. (Hint: Look at the data values to determine the nature of the relationships. For example, note that employee Melton has flown two charter trips as pilot and one trip as copilot.)

b. Decompose the dependency diagram you drew to solve Problem 11a to create table structures that are in 3NF and write the relational schema.

c. Draw the Crow’s Foot ERD to reflect the properly decomposed dependency diagrams you created in Problem 11b. Make sure the ERD yields a database that can track all of the data shown in Problem 11. Show all entities, relationships, connectivities, optionalities, and cardinalities. 

SEE ATTACHED: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image067.jpg

Make sure that the file is saved as ch6_problem11_deleon.doc

———————————————————————————————————

  1   

Unified Communications System (e.g., email, conferencing, and messaging) – The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment and should include instant messaging as well as video conferencing on demand. 

Objectives

1. Decide on a client-based      email application or cloud service email.
2. Email application should      include an IRQ messaging center and have access to tablets and      smartphones. 
3. Research and select a      desktop video conferencing application. 

Activities

2.1. Plan and implement Microsoft Exchange in the central data center. Push 2016 Outlook to all PCs and company computing nodes. 

2.2. Use Google Hangout for video audio conferencing and have each employee sign up for their own account. 

2.3. Use the instant message feature in Google Hangouts to provide user IM and IRQ services via their desktop. Embed Google Hangouts app on company cell phones to extend the reach of this capability.

2   

Enterprise Resource Programming (ERP) System and Internally Facing Business Support Systems – The company must upgrade its ERP functionality to handle the growing business and its international expansion. The system must be capable of integrating with one or multiple point-of-sale (POS) systems. This system will also involve a human resource management system (HRMS) and a materials resource management (MRP) system.

. .

ObjectivesObjectives

1. Research and select a new      ERP System.
2. Determine the modules and      functionality of the ERP System (to include HRMS, MRP, FICO, etc.)
3. Determine the type of      platform for the ERP (e.g., in premise, colocation, SaaS).

Activities

5.1. Establish a project to plan and implement business planning and control system’s (BPCS) version 9.6 to upgrade the current version.

5.2. Assign a program manager to the project and identify sponsor, steering committee, and stakeholders. 

5.3. Identify and document an ERP implementation resource plan. Use knowledgeable programming and support resources that know BPCSs and attempt to document this implementation (as the previous implementation failed to fully document the changes or provide a run book for operational support and usage). 

5.4. Implement a train-the-trainer program after the version upgrade is made. Take the next year to make sure everyone in the support group and all programmers have gone through the basic new version training.

5.5. Use the current monthly reports to keep people informed. Add a new box on the report to indicate the progress of the project. 

3   

Point-of-Sale (POS) System – The company must upgrade and/or implement sales automation and customer management. There are various manual and single instance systems currently existing that must be consolidated and/or refurbished or replaced to support the growth of the company, especially in the international marketplace. 

Objectives

1. Consolidate and select a point-of-sale system that will operate anywhere in the world. 

2. Research, select, and implement a new Salesforce automation system.

3. Research, select, and implement a new customer response/relationship system.

Activities

6.1. Dovetail the current, various POS systems and manual methods in lieu of this new system. Determine if an in-house application or a SaaS service is better suited to the company.

6.2. Get together with the sales and marketing groups in each region and let them implement their own point-of-sale system. Make sure each of these applications can be customized to fit the Hyperion reporting system that will gather the data monthly for reconciliation and reporting.

6.3. Consolidate all the customer data from the different regions and put it into an MS Access database. Make the database accessible to the intranet so that all employees can get to it via that portal.

6.4. After the MS Access database is developed and implemented, train everyone who wants to be trained on the system. Try to cover all daily users and customers of the system within the current year. 

6.5. Streamline the batch data exchange between the BPCS system and the Access database with customer data. Consider going to a new format for tape that takes less time to copy and load. Current data rollovers are taking almost all night, and as the data increases, so will the rollover time to load.

4   

Customer Relationship Management (CRM) System – The company must upgrade and/or implement a unified CRM. There are various manual and single instance systems currently existing that must be consolidated and/or refurbished or replaced to support the growth of the company, especially in the international marketplace. 

Objectives

1. Research, select, and implement a new customer response/relationship system.

2. Consolidate all instances of Salesforce CRM within the company including non-SFDC CRMs and customer ticketing systems. Consolidate Salesforce customer relationship management (SFDC CRM) into a single corporate entity.

Activities

11.1. Roll over current customer data into a consolidated SQL database and allow users that need access authentication into the database. 

11.2. Develop an offline output data source with all the different SFDC instances and make the consolidated database available to authenticated users. 

11.3. Develop a new UI in the SharePoint intranet to control and monitor the data for use by both sales and customer service.