1-Write the relational algebra expressions for the following (using Ç):
branch (branch_name, branch city, assets)
customer (customer_name, customer street, customer city)
loan (loan number, branch_name, amount)
borrower (customer name, loan number)
account (account_number, branch name, balance)
depositor (customer_name, account number)
a) Find the names of all customers who have a loan and an account at bank.
b) Find all customers who have an account from at least the “Downtown” and the “Uptown” branches.
2- University schema
Classroom (building, room number, capacity)
Department (dept name, building, budget)
Course (course id, title, dept_name, credits)
Instructor (ID, name, dept_name, salary)
Section (course id, sec id, semester, year, building, room number, time slot id)
Teaches (ID, course id, sec id, semester, year)
Student (ID, name, dept_name, tot cred)
Takes (ID, course id, sec id, semester, year, grade)
Advisor (student ID, instructor ID)
Time slot (time slot id, day, start time, end time)
Prereq (course id, prereq id)
Write the following queries in SQL, using the university schema
a) Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result
b) Increase the salary of each instructor in the IT department by 15%.
c) Insert every student whose tot cred attribute is greater than 75 as an instructor in the same department, with a salary of $15,000.
3- Refer to the university schema used in Q.2 and write the following queries using Nested subqueries.
a) Find the average instructors’ salaries of those departments where the average salary is greater than $50,000. (Hint: use subqueries in the From Clause)
b) Delete all courses that have never been offered (that is, do not occur) in the section relation.
4- Deleting a record can be costly to an organization if not done in the right way. Let us assume you are working as a DBA (database administrator) and you used the delete command without specifying a condition in the where clause. What do you think will happen to the record in the database? And in case a record was deleted, is there a way to recover the lost data? Answer should be in your own words.
700words: Effective leadership
Refer to the attachment:
1. How do geographically dispersed teams collaborate effectively?
2. Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team. Please note the pros and cons of each tool.
3. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why.
Virtual Installation
PLZ Follow the RUBRIC that’s everything you need to cover every check box
Assignment,Due Date 20th June
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
My course details: Descriptive Statistics , Paired and Independent samples t-tests .
- describe the essential characteristics of quantitative research.
- Apply inferential statistical tests on problems requiring parametric and non-parametric analyses.
- Identify potential research designs for various problems.
- Analyze statistical information in the professional literature on a topic related to their own research project.
Note: Minimum 500 words not including title and reference page. References should be taken from peer revived
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
paper
R is a language and environment for statistical computing and graphics. It is a GNU project which is similar to the S language and environment which was developed at Bell Laboratories (formerly AT&T, now Lucent Technologies) by John Chambers and colleagues. R can be considered as a different implementation of S. There are some important differences, but much code written for S runs unaltered under R.
Why are statistical programming languages important to data scientists? What are some advantages and disadvantages the R programming language has over the other main statistical programming languages (i.e. Python, SAS, SQL)?
Discussion Length (word count): At least 250 words (not including direct quotes).
References: At least three peer-reviewed, scholarly journal references.
Cost Model
Open a new Microsoft Word document, Microsoft Excel document, or use the provided template to complete the following tasks.
Tony Prince and his team are working on the Recreation and Wellness Intranet Project. They have been asked to refine the existing cost estimate for the project so they 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 6 months for under $200,000.
Use the Cost Estimate template and Cost Baseline template to assist with this assignment.
Tasks
- Prepare and upload a 1-page cost model for this project using spreadsheet software. Use the following work breakdown structure (WBS), and document your assumptions in preparing the cost model. Assume a labor rate of $100 per hour for the project manager and $60 per hour for other project team members. Assume that none of the work is outsourced, labor costs for users are not included, and there are no additional hardware costs. The total estimate should be $200,000.
- Project management
- Requirements definition
- Website design
- Registration for recreational programs
- Registration for classes and programs
- Tracking system
- Incentive system
- Website development
- Registration for recreational programs
- Registration for classes and programs
- Tracking system
- Incentive system
- Testing
- Training, rollout, and support
- Using the cost model you created in the first task, prepare a cost baseline by allocating the costs by WBS for each month of the project.
- Assume that you have completed 3 months of the project. The BAC was $200,000 for this 6-month project. You can also make the following assumptions:
- PV=$120,000
- EV=$100,000
- AC=$90,000
- What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?
- Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?
- Use the SPI to estimate how long it will take to finish this project.
After completing your charts, write a 150-word follow-up in which you complete the following:
- Explain how the project is doing based on the CPI and SPI. Is it ahead of schedule or behind? Is it under budget or over?
- Describe the strategies or steps that should be taken for human resource management to avoid additional costs.
- Describe the strategies or steps that should be taken for resource activity management to avoid additional costs.
- Recommend 2 tools to support these strategies and explain why these tools would be beneficial.
Submit your cost model, course baseline, and follow-up.
paper-
The COSO framework of internal controls is practiced within companies around the world. The objectives of the COSO framework are closely related to its five components. For this week’s activity, please discuss these five components of the COSO framework. Be sure to include each components’ impact on each of the COSO framework objectives. What do you feel an auditor would most be concerned with during an IT audit? Lastly, discuss suggestions for integrating COSO framework compliance into a company in which you are familiar.
Your paper should meet the following requirements:
• Be approximately 2-4 pages in length, not including the required cover page and reference page.
• Follow APA6 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
Data mining assignment
answer the questions in attached assignment
5s week 8 assignment BS
in 350 words,
You are the web master of a college website. You share a server with other school departments such as accounting and HR.
Based on this chapter, create at least five security-related rules for staff members who are adding web pages being added to your site. Include a justification and explanation for each rule. Rules should relate to college, staff and student, and system information security.
Write your answer using a WORD document. Do your own work and use your own words. Submit here. Note your Safe Assign score.
Include references, do not copy-paste.
Discussion with replies – 3
Many enterprise organizations believe that cloud computing is essential to their business operations. There are some; however, that argue it is not cost efficient and operationally appropriate. Provide a use case where cloud computing is not appropriate and explain why you feel this is an appropriate decision for the enterprise.