discussed big data , data warehouse and google database for big data and bootstrapping technique for data analytics to a real life business scenario.

Writing Requirements

• 3-5 pages in length in word document

List the phases of Waterfall methodology and list the roles involved in each phase.

Roles given include - project sponsor, business analyst, SME, database designer, system designer, software developer, quality assurance

After reading the Biography in Context database entries on Bill Gates and Steve Jobs, briefly compare and contrast these two leaders of industry. Considering that while both are quite different, observe some unifying qualities.

What does each letter in ACID stand for in the context of database transactions? Describe a concrete example (i.e. a scenario) to illustrate the property the letter "I" refers to, in terms how it works or how it breaks in the example.

Explain how the foreign key constraint maintains referential integrity between two tables when the database is inserted, updated, or deleted. What are the different 'referential actions' (foreign key rules) that can be specified?

Bill Arrow of the PROPS airplane service business that we learned about for 1 also has an auto rental business at that same small airport. He has been managing this part of his “empire” with a large, complicated spreadsheet. The spreadsheet has met his needs in the past, but with the success of the database you designed and implemented for the airplane storage and service parts of his business, he has recognized the value of the database to store, access, protect his data. He has asked you to develop a plan to incorporate his existing spreadsheet data into new database.

The spreadsheet contains data for the cars in the rental fleet. It tracks the maker, model, VIN number, body style, and number of doors for each car. It also tracks the dealers from whom Bill bought the cars with dealer name and address. (Most dealers have brick and mortar buildings and physical addresses. However, there are also some Tesla autos in the fleet. Bill buys these units directly from Tesla through a web site.)

The following table represents a portion of the spreadsheet. Using this table as a starting point, show the steps you would take to design a new, normalized table(s) that could be added to the existing PROPS database. There is no need to consider how this new table(s) would be actually be added to the PROPS database

PROPS Auto Rental Spreadsheet

1. Convert the PROPS Auto Rental spreadsheet into a 1NF relational database table(s). You may add fields to the table, if necessary. You may use the abbreviations from the spreadsheet in your table. Indicate prime key field(s).   Provide written justification for your solution, if necessary. Draw the table as a grid. (20 points)

2. Put the 1NF table from Question 7 into 2NF. Provide written justification for your solution, if necessary. (20 points)

3. Put the 2NF tables from Question 8 into 3NF. Provide written justification for your solution, if necessary. (20 points)

Choose one (1) and only one of the following three 3 assignment options. Investigate and document your response. Provide your response back in this document, and SUBMIT it back using Google Classroom once completed.

Alternative Options list:

1. Information Systems roles and jobs

2. Personal Use of Technology

3. Database creation

Details are provided below:

1. Information Systems roles and jobs:

Prepare a report on purchasing a computer for yourself.

Identify your requirements (what you will need to use it for, how much you would spend, etc.).

Identify at least 3 viable options (actual computers), 2 of them of the same type (e.g. PC) and 1 of them different type (e.g. Apple).

List the specifications for each in a side-by-side table, including:

Hardware specifications (processor, memory, storage, etc.), 1 row for each category item

Software specifications (OS, application software, etc.) 1 row for each category item

Networking specifications

Total cost

Identify which would be the most powerful, which would be the fastest.

Select your best alternative.  

Confirm that it will meet all your requirements, and indicate why you would choose it.

Provide response on table format. Provide final selection and explanation in paragraph format.

1-3 pages max.

2. Personal Use of Technology:

Create a list of at least 4 examples of technologies used by you within the last 2 months.  

For each:

Classify them by IT Component types

Research and identify approximately what year each technology was introduced, and when your specific version was introduced.

Indicate how you have used the technology.  

Indicate what your next-best alternate would have been if you did not have the technology. Estimate the associated impact to you if you did not have the technology (additional time, cost to you per day/week etc.)

Indicate 1 example of something you currently do manually (and that there currently is not a technology solution available yet). Investigate if anyone in the world is already innovating and working on it, and if so, provide a reference (name and link) and some details.

Response should be in table form, 1-3 pages max.

3. Database Creation:

Create a database project with the following requirements, use any professional principles and standards.

Use any relational database software application of your choice to develop database implementing the logical design into a physical design.

create the normalized physical database with tables, columns with data types, primary keys, constraints, etc.

Create a minimum of ten rows of test data in each table.

Submit a Zip .sql file with the scripts needed to create your tables with keys and the insert test rows, etc., into the tables and submit the Assignment Files tab as Zip.

Martha has been an employee at ABC Global for a total of 8 years. She has consistently been recognized for her solid work and creativity and has been twice promoted. Most recently, Martha received the Impact Award which is the highest recognition that the company bestows and also comes with a $2000 bonus. As a high-ranking American-born female of Nigerian descent, she has been an example to many in the organization in how hard-work & honesty can be rewarded.

Over the last several years, Martha's faith has become more important to her. As such, she silently reads the Bible only on her breaks and at lunch. A week ago, an employee named Drew complained that he was "offended" because he saw Martha reading her Bible. Drew has been with the company 10 years and has also been recognized for good performance. A factor that could be considered is that last year, Drew, Martha and a third employee competed for a promotion of which Martha received. In addition, Drew previously expressed a concern about a co-worker wearing a Sikh turban.

The owners of ABC Global are strongly opposed to any religious persecution and have taken a stance of accommodating all faith-based views whether they be Christian, Jewish, Muslim, Hindu etc. As a result, an informal survey of the organization has shown several employees reading the Torah, the Quran and other books.

Focusing strictly on the legality and ethical issue, as an ABC Global leader, how would you address the situation with Drew?

please respond using one or more citations minimum 250 words

Suppose the central bank conducts an unusually large open market purchase of bonds held by the First National Bank of $1400 billion due to a sharp contraction in the economy. Before the First National Bank turns proceeds to productive uses, update the balance sheet of the First National Bank