Database design

Please read carefully and only bid if you know SQL and have MySQL screenshots will be needed. 

Please base your answer on the diagram attached.
 

Physical Design
In Week Four, you created your database in the SQL server you were provided within your lab environment and translated this design into SQL server tables with appropriate fields. Select the appropriate data type for every field. The specific data type you select will depend on the size and range of the values that will be stored in the field.

Specify all primary keys as “identity” fields, and not as auto-increment.

After creating the tables, use the “insert” command to populate the tables with sample data for all the tables. (This will be affirmed in your SQL server in the lab environment.)

Data Retrieval
Provide select statements to satisfy the following data requests.

  • List all available laptops assigned laptops to managers.
  • List all available named licenses.
  • List the workstations that are over three years old (from the date of purchase) and assigned to leads.
  • List the name of the leads, workstation IDs, and location.
  • List the names of all the leads in the operations department.
  • List all the workstations with an amount of disk space less that the average disk space available in all workstations.
  • List the names of all managers with employees who have not been assigned a workstation.

Include screen shots of the SQL statements used to perform each step as well as the result sets resulting from the execution of the SQL statements. Describe what you did to complete each step.

Connect Online Databases with Front-End Interfaces
In order to connect the database with the front-end interface you will modify the Java code provided on the Connection URL Sample (Links to an external site.) website to retrieve the list of all workstations assigned to managers. The output must include the first name, last name, and department of the managers as well as the workstation ID and date of purchase.

Modify the Java Code to insert new workstation record in the workstations table if provided with the WorkstationID, type, location, purchase date, memory, disk space and CPU speed.
Include the modified code by copying and pasting the code as plain text at the bottom of this section.

The Database Design Project 

Easy Own words

 This week we start looking at project Scope Management, and project  Schedule Management. For some of this week’s tasks, you will need to use  Microsoft Project. 

If you have not started familiarizing yourself with MS Project, here  is a very short, simple tutorial that you can start with. There are MANY  others out there on the Internet, but this one isn’t as complex as a  lot of them. You can view it here:

https://www.youtube.com/watch?v=pU4UzCfUDX4

If you do not have a copy of MS Project on your computer, you can run  it from our Remote Server, by following the instructions in this .pdf  document: VMWare Student Application Server Access Instructions                Download VMWare Student Application Server Access Instructions              

Your Assignment for This Week

Chapter 5 – Read the Running Case at the end of the chapter. Do tasks  1 through 4. Do NOT do task 5. On Task 1, ONLY do the requirements  traceability matrix. You do NOT need to develop a list of questions for  the project sponsor. .

Chapter 6 – Read the Running Case at the end of the chapter. Complete tasks 1 through 3.

Running Case Chapte-5: 

You have been selected as the project manager for the Global Treps project. You helped to run

a local shark tank like event at your college last year as part of a class project, so you have a

general idea of what is involved. The schedule goal is six months, and the budget is $120,000.

Your favorite professor, Dr. K., and a few of her associates have agreed to fund the project. Your

strengths are your organizational and leadership skills.

You are a senior, live on-campus, and get free room and board by being a resident assistant

in your dorm. Bobby, a computer whiz who funded a lot of his college expenses by building

websites, will be your main technical guy on the project. He goes to your college and lives

off-campus. Three other people will form your core project team: Kim, a new college grad now

working for a non profit group in Vietnam; Ashok, a business student in India; and Alfreda, a

student in the United States planning to visit her home town in Ethiopia for two months in a few

months. You will hold most meetings virtually, but you can meet face-to-face with Bobby and

Dr. K. as needed. You have all known each other for at least a year and are excited to make this

project a success.

You and your team members will do the work part-time while you finish school or work at

other jobs, but you can use up to $50,000 total to pay yourselves. You estimate that you will need

another $30,000 for travel expenses, $20,000 for hardware and software, and the other $20,000

will go toward organizing events, consultants, legal/business fees, etc.

Your goal is to develop a fully functioning website and test it by holding four events in four

different countries. You’ll make improvements to the site after those events, develop plans to

scale it up, and recommend how to transition the project results into a successful business.

Recall from Chapter 4 that this system would include the following capabilities:

• Provide guidelines and templates for running a shark tank type event

• Accept donations from potential investors targeted toward specific schools or

organizations wishing to host an event (similar to the popular DonorsChoose.org site,

where people can fund teachers’ requests)

• Accept ideas for needed new products or services

• Provide the ability for organizations to create their own custom site to solicit local

participants and sharks, accept applications, and promote the winners as well as

losers.

Note that you decided not to include the idea of providing an online version of the event

as part of the initial project as your sponsor and team decided that physical events would be

most effective. You have also decided to limit the scope of this first project to provide the ability

for 20 organizations to create their own custom websites. Your team members will screen the

organizations and assist people in using the site to plan their events.

You plan to hold four shark tank like events within four months, using your team members

abroad to help organize and run those events, plus one at your college. Your semester has just

started, so you plan to hold your event at the end of the term. The project will fund refreshments

for the events and prizes for the winners, with a budget of $1,000 for each event. You don’t think

you’ll get any donations via the new website before these events, but you’ll try to have it set up to

accept donations by the last month.

You will create some short videos to show people how to use the site and provide

suggestions for holding the events.

After testing the site and getting customer feedback, you will make some changes and

document recommendations for a follow-on project. You will also create a business plan

recommending how to transition this project into a real business that can make a profit after two

years.

Assume that you would pay for a new website and account through an online provider.

Bobby would do most of the customization/programming for the site, but you would consider

outsourcing or purchasing services to provide some of the capabilities like accepting donations

and developing the short videos on the site. You would also buy a new laptop and Internet

access for your three team members abroad so that they could share information with their

contacts in those countries.

You and Dr. K. want to attend all of the events as part of the project, and you might include a

full face-to-face meeting with the whole team if possible.

Tasks

1. Document your approach for collecting requirements for the project. Include at least five

technical requirements and five non technical requirements in a requirements traceability

matrix. Also develop a list of at least five questions you would like to ask the project sponsor.

Let your instructor answer them for you, if applicable.

2. Develop a first version of a project scope statement for the project. Use the template

provided on the Companion website for this text and the example in Chapter 3 as guides.

Be as specific as possible in describing product characteristics and requirements, as well as

all of the project’s deliverables. Be sure to include the Global Treps website, four shark tank

like events, a business plan, and outsourced items (laptops, donation acceptance, video

creation, etc.) as part of the project scope.

3. Develop a work breakdown structure for the project. Break down the work to Level 3 or Level 4,

as appropriate. Use the template on the Companion website and samples in this text as

guides. Print the WBS in list form. Be sure the WBS is based on the project charter (created

for the Chapter 4 Running Case), the project scope statement created in Task 2 above, and

other relevant information.

4. Use the WBS you developed in Task 3 to begin creating a Gantt chart using your choice of

software. Do not enter any durations or dependencies. Print the resulting Gantt chart on one

page, and be sure to display the entire Task Name column.

5. **I removed no need to do**

Chapter 6 – Read the Running Case at the end of the chapter. Complete tasks 1 through 3.

Running Case Chapter-6:

You are the project manager for the Global Treps Project, sponsored by Dr. K. Team members

include Bobby, your IT guy; Kim, a new college grad now working for a non profit group in

Vietnam; Ashok, a business student in India; and Alfreda, a student in the United States originally

from Ethiopia. You plan to outsource some of the work (e.g., purchasing laptops, developing a

website feature for accepting donations, and creating videos for the website). Recall that your

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

Tasks

1. Review the WBS and Gantt chart you created for Tasks 3 and 4 in Chapter 5. Propose three

to five additional activities that would help you estimate resources and durations. Write a

one-page paper describing these new activities.

2. Identify at least five milestones for the Global Treps Project. Write a short paper describing

each milestone using the SMART criteria. Discuss how determining the details of these

milestones might add activities or tasks to the Gantt chart. Remember that milestones

normally have no duration, so you must have tasks that will lead to completing them.

3. Using the Gantt chart you created for Task 4 in Chapter 5 and the new activities and

milestones you proposed in Tasks 1 and 2 above, create a new Gantt chart using Project

2016 or another tool. Estimate the task durations and enter dependencies as appropriate.

Remember that your schedule goal for the project is six months. Print the Gantt chart and

network diagram, each on one page.

 

***I attached text book for reference. Question is from Chapter-5 & Chapter-6***** 

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

Discussion 7

 This week we focus on the concept of false discovery in data.  After reviewing the article by Naouma (2019), answer the following questions:

  1. What is a false discovery rate?
  2. Can a false discovery rate be completely avoided?  Explain.
  3. What was the outcome of the results of the use case?

Read:

  1. ch.10 in textbook: Avoiding False Discoveries
  2. Naouma, P. (2019). A comparison of random-field-theory and false-discovery-rate inference results in the analysis of registered one-dimensional biomechanical datasets. PeerJ (San Francisco, CA), 7, e8189–e8189.

Residency: Practical Connection

Residency: Practical Connection ( Big Data concepts learned ) 

At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where you will demonstrate how this course research has connected and put into practice within your own career.Assignment: Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. (Include references).Requirements: 

  • Provide a 500 word (or 2 pages double spaced) minimum reflection. 
  • Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited. 
  • Share a personal connection that identifies specific knowledge and theories from this course. 
  • Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.  
  • You should NOT provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

Write a response to the following questions

 

  1. Analyze the four performance measures of cost, quality, duration, and customer satisfaction. What additional metrics or measurement could be important (beyond the additional measurement of size noted in the text)?
  2. Compare and contrast quantitative versus qualitative data in evaluating performance of IT systems. Is one data collection methodology better at assessing the overall effectiveness of operations?

Response should be 1-2 pages or at least 500 words.

2/3 Discussion

  1. Read Chapters 5–8 in your textbook.
  2. Using the discussion link below, respond to the following prompts and questions:
    1. Classify the types of cryptographic methods that are currently in use and describe their functionality.
    2. What function does PKI play in secure transactions? Discuss any issues with the use of PKI.
    3. Discuss why physical security is important. Select several physical security measures and provide reasoning for their implementation.
  3. Your initial post should be at least 300 words and supported with at least three references.

Operational excellence

Discussion:

 This week we focus on the productivity paradox.  Please define the productivity paradox and explain current thinking on this topic 

Assignment: 

  Information Systems for Business and Beyond Questions:

  • Chapter 7 – study questions 1-10, Exercise 2
  • Chapter 8- study questions 1-10, Exercise 2

Information Technology and Organizational Learning 

Assignment:Chapter 6 – Review the section on knowledge creation, culture, and strategy.  Explain how balance scorecards impact knowledge creation, culture, and strategy.  Why are these important concepts to understand within an organization?