Letter Separated Numbers (C++)

I've encountered a corrupted database that has a series of important numbers, but instead of being separated by a space, the spaces have been randomly changed in alphabetic characters. Write a function named "my_numbers" that can take a string like "18y5638b-78" and return a vector of ints {18, 5638, -78}.

Thanks!

Develop a function to read a document in the MongoDB database “city” in the collection “inspections.” Be sure it can handle error conditions gracefully.
a. Input -> arguments to function should be the key/value lookup pair to use with the MongoDB driver find API call
b. return -> result in JSON format if successful else MongoDB returned error message

1. You work for Mooney’s Consulting. They have assigned you to an engagement with Anavrin a healthfood café based in Los Angeles. The company currently only produces and sells organic sandwiches, pastries, coffee, and smoothies. They currently spend anywhere from $5,000 to $25,000 per year on marketing with the majority of this being on billboards and viral media targeted at the Los Angeles market. They maintain all their records within an Access database. They have provided you with access to their database which contains the last eight years of data about the company, including all sales, spending, customers, vendors, and employees. Anavrin has hired Mooney’s Consulting (You) to determine if their advertising budget and approach is optimal.

Required: Below, write each step of the IMPACT cycle then determine the steps you would take pertaining to this specific engagement for each step of the cycle. Be specific on what actions you would take, writing at least 3 sentences describing your actions for each step.

Develop an iteration schedule diagram using the information provided in the attached document. Create this schedule using either Microsoft Project or ProjectLibre.

(a) According to Graduating Student and Alumni Survey in 2019, among the 1230 respondents, 180 said that they expected difficulty finding a job after graduation. If we can reasonably presume that the percentage of people expected difficulty will be between 15% and 25%, obtain a sample size that will ensure a margin of error of at most 0.02 for a 90% confidence interval.

(b) A recent survey of 254 customers, selected at random from a database with 12,861 customers, found that 202 are satisfied with the service they are receiving. Find a 99% confidence interval for the percentage satisfied for all customers in the database.

(c) Independent simple random samples of 400 Hong Kong women and 380 Macao women were taken. Of Hong Kong women, 318 were found to be in the labor force; of the Macao women, 276 were found to be in the labor force. At the 5% significance level, do the data suggest that the labor-force participation rate of Hong Kong women is higher? Use the P-value approach to perform a hypothesis test.

System Architecture

Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane’s information system consists of a file server and three workstations where freight clerks enter data, track shipments, and prepare freight bills. To perform their work, the clerks obtain data from the server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, Passing lane’s president approved your recommendation to create a relational database to handle operations and provide links for the company’s shippers and customers.

Tasks

1. What would be the advantages of selecting an Internet-based architecture for Passing Lane’s system?

2.  Since the firm is growing rapidly, what design features should be included in the new system to ensure it can grow with the company.

3.  Given that Passing Lane currently uses computers for managing their operations, what design considerations should be given to legacy systems? Explain your answer.

Part 2:

1. Use MySQL Workbench to add a table to your database on the class server and name the table “Person”. Include these fields in the Person table:

LoginID should be the Primary Key of the table.

Add at least ten records to the Person table.

3. Add a Persons page, named person.php. This page should display the contents of your Person table in an HTML table by using SQL to read records from the database table. Use linked styles to decorate the page background, all headers and table cell contents. E.g., font family, font size, color, etc. Place the .css file in an appropriate application subdirectory as in the class examples.

The Delta Insurance Company is having a policyholder subsystem which has started giving trouble. Over the years, the application evolved from using fixed length, multi-record type files to using a hierarchic database to using a relational database. The programs did not change much, but the data structures changed radically. Program code was patched to provide for the new data structure. The amount of people-time allocated to policyholder maintenance grew 15% per year over the last five years and is now costing as much per year as it did in 1980 to develop the original application. No one ever considered reevaluating the subsystem for redevelopment, but they would like to now. Upon inspection, the documentation was found to be up-to-date and includes flow charts and data flow diagrams. There are no current diagrams of the data structure. There are also no historical files of decisions or of changes. Apply the concepts of change management to discuss how should the company get this application in order? What type( s) of maintenance should they consider for the next set of changes?

A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the loan, interest rate ( which may be different for each loan as determined by the bank), duration of the loan, monthly payment, remaining balance, school ID, school name and address, number of years the student has been at the school, bank name, bank branch, and bank ID. Draw an ER diagram. State any assumptions you make in the diagram. Note: You must use one of the automated database design tools such as: ER STUDIO ER Assistant Vision Enterprise or draw.io website.

Introduction to Database SHort answer question

-1)Can intersection data be placed in the entity box of one of the two entities in the many-to-many binary relationship? If yes, describe which one. If not, where can you put it? Explain.

-2)What is the difference between a record type and an occurrence of that record? Explain and give example(s).

-3)Name at least 4 entities, some sample attributes for each entity, and the primary key field for each entity, in a university environment .

4)How foreign key is used to set-up one-to-many relationships in relational databases? Explain and give example (example from the lecture is ok).

5) How to implement Many-to-Many relationship in a relational Database? Explain and give example (example from the lecture is ok)

6)Describe referential integrity problem in general. In the specific case of deleting a record in a table on the “one side” of a one-to-many relationship, how would referential integrity occur?