UMUC Views and Aggregate Functions

Content Type

User Generated

User

Wvnglpr

Subject

Computer Science

School

University of Maryland Global Campus

Description

Download, unzip, and attach the sample database ITCO630_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.

Download the database for this assignment.

The following are the tables and data in the ITCO630_A database:

Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.

Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
Create a view called v_no_points with all the columns of the assignment table except the points column.
Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

Tags: database database structure points View and Aggregate Function counts

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey once again😜 See attached. Let me know if you need any edits or revisions😃

Running Head: VIEWS AND AGGREGATE FUNCTIONS

View and Aggregate Function

Name

Institution

Cou...

Completion Status:

100%

Review

Review

Anonymous

Great content here. Definitely a returning customer.

Studypool

4.7

Trustpilot

4.5

Sitejabber

4.4

24/7 Homework Help

Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!

INF 103 Ashford Benefits of Using the Ashford University Library Essay

Write a one- to two-page essay that describes the benefits of using the Ashford University Library. Your paper should: ...

INF 103 Ashford Benefits of Using the Ashford University Library Essay

Write a one- to two-page essay that describes the benefits of using the Ashford University Library. Your paper should: Explain the differences between scholarly resources and popular resources. Describe the key things to remember when searching for sources within the Ashford University Library (e.g., databases, FindIt@AU search tool). Detail how you will be most effective and efficient in finding resources that fit your research needs.

CST 630 University of Maryland Data Loss Prevention Analysis Paper

By now, you have an idea of your team members and your role on the team project. Now, it's time to get the details about t ...

CST 630 University of Maryland Data Loss Prevention Analysis Paper

By now, you have an idea of your team members and your role on the team project. Now, it's time to get the details about the devices and technologies needed to be included in the Strategic Technology Plan for Data Loss Prevention. You should limit the scope of this project by selecting a set of devices and technologies that are most appropriate for data loss prevention for your business mission and future success. Based on your prior knowledge of your company and based on the project roles you agreed upon in the previous step, perform independent research on the following topics and identify a set of devices and technologies that you propose for your company, and your business rationale for selecting them:

Lexical Analyzer Game C++ Programming Fundamental Worksheet

Lexical Analyzer Game C++ Programming Fundamental Worksheet

Ashford University Legal Compliance Paper Question

As a CIO, you will be responsible for your company’s compliance with certain federal laws. Additionally, there may be s ...

Ashford University Legal Compliance Paper Question

As a CIO, you will be responsible for your company’s compliance with certain federal laws. Additionally, there may be several industry-regulated standards or guidelines that your company may voluntarily follow which may add security and/or social benefit to the management of your company’s data. In this scenario, you are the CIO of a publicly-traded American corporation that provides health care consulting to families who are seeking international medical treatment for their children. The company automatically charges its customers on a monthly basis from their credit card, debit card, or bank account using personal financial data that the company stores and manages. For this assignment, you will analyze federal laws as well as a voluntary, industry-based set of standards that pertain to data management. Select a minimum of three federal laws and one voluntary-based set of standards and include the elements below. For this assignment, you do not need to consider the implications of any state specific laws. Provide a brief overview of each federal law and the voluntary industry-based standard. Analyze legal issues regarding data management and describe how the company must comply with each federal law and the voluntary, industry-based standard. Explain the legal and/or financial consequences to the company for non-compliance of each federal law and the voluntary industry-based standard. t.

CYB 405 University of Phoenix Security Policy & Aligning Controls Discussion

The information security strategic plan and security policies are strongly interrelated within an organization’s inf ...

CYB 405 University of Phoenix Security Policy & Aligning Controls Discussion

The information security strategic plan and security policies are strongly interrelated within an organization’s information security program. The security plan and security policies will drive the foundation and selection of security controls to be implemented within the organization. Part 1 Write a 1- to 2-page summary of the comparison chart of strategic plans and security policies you completed in this week’s Learning Team assignment. Part 2 Review the control families described in this week’s reading, NIST SP 800-53a Revision 4, Assessing Security and Privacy Controls for Federal Information Systems and Organizations. Review the controls from this week’s reading, CIS Controls V7.1. Develop a 2- to 3-page matrix using Aligning Security Controls to NIST Security Controls Matrix Template that accurately maps CIS controls to NIST security control families. Note that some CIS controls may map to multiple NIST control families. Cite all sources using APA guidelines.Submit your assignment.

5 pages

Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for You have the option to u ...

Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for You have the option to use MS Visio (if you have the ...

Similar Content

American InterContinental University Network Troubleshooting Discussion

In your own words, answer this unit's discussion questions in a main post (recommended minimum 300 wordsAssignment Details...

Which malware you consider the most dangerous and why?

Question: After reading about malware in the below attachment, which malware do you consider the most dangerous and why? I...

User Frustration , computer science homework help

Assignment 4: User FrustrationThe quality of the user experience is very important to the success of an application. In th...

UC Computer Science Major Steps in The Implementation Process Paper

List the major steps in the implementation process and describe them briefly using the diagram. Why is implementation an i...

physical security, computer science homework help

"Physical Security" Please respond to the following:Students should go on a learning walk at work and document the p...

LU Static and Dynamic Routing Network Settings Questions

. Why would static routing be chosen over dynamic routing? . Why would dynamic routing be chosen over static routing?...

In this topic, we were introduced to the concept of leadership. The entire chapter was an interesting experience learning ...

Josh, the proprietor of Glow Foods was invited for a meeting, which according to him was a merger arrangement with Interna...

Company S Ethics

Gaskarth, J. (2015). Rising powers, global governance and global ethics. New York: Routledge...

Related Tags

software engineering networking File Source parity bits technology value Software Testing technology data integration Data warehouse WAN Implementation information technology

Homework help

Our tutors provide high quality explanations & answers.

Post question

INF 103 Ashford Benefits of Using the Ashford University Library Essay

Write a one- to two-page essay that describes the benefits of using the Ashford University Library. Your paper should: ...

INF 103 Ashford Benefits of Using the Ashford University Library Essay

Write a one- to two-page essay that describes the benefits of using the Ashford University Library. Your paper should: Explain the differences between scholarly resources and popular resources. Describe the key things to remember when searching for sources within the Ashford University Library (e.g., databases, FindIt@AU search tool). Detail how you will be most effective and efficient in finding resources that fit your research needs.

CST 630 University of Maryland Data Loss Prevention Analysis Paper

By now, you have an idea of your team members and your role on the team project. Now, it's time to get the details about t ...

CST 630 University of Maryland Data Loss Prevention Analysis Paper

By now, you have an idea of your team members and your role on the team project. Now, it's time to get the details about the devices and technologies needed to be included in the Strategic Technology Plan for Data Loss Prevention. You should limit the scope of this project by selecting a set of devices and technologies that are most appropriate for data loss prevention for your business mission and future success. Based on your prior knowledge of your company and based on the project roles you agreed upon in the previous step, perform independent research on the following topics and identify a set of devices and technologies that you propose for your company, and your business rationale for selecting them:

Lexical Analyzer Game C++ Programming Fundamental Worksheet

Lexical Analyzer Game C++ Programming Fundamental Worksheet

Ashford University Legal Compliance Paper Question

As a CIO, you will be responsible for your company’s compliance with certain federal laws. Additionally, there may be s ...

Ashford University Legal Compliance Paper Question

As a CIO, you will be responsible for your company’s compliance with certain federal laws. Additionally, there may be several industry-regulated standards or guidelines that your company may voluntarily follow which may add security and/or social benefit to the management of your company’s data. In this scenario, you are the CIO of a publicly-traded American corporation that provides health care consulting to families who are seeking international medical treatment for their children. The company automatically charges its customers on a monthly basis from their credit card, debit card, or bank account using personal financial data that the company stores and manages. For this assignment, you will analyze federal laws as well as a voluntary, industry-based set of standards that pertain to data management. Select a minimum of three federal laws and one voluntary-based set of standards and include the elements below. For this assignment, you do not need to consider the implications of any state specific laws. Provide a brief overview of each federal law and the voluntary industry-based standard. Analyze legal issues regarding data management and describe how the company must comply with each federal law and the voluntary, industry-based standard. Explain the legal and/or financial consequences to the company for non-compliance of each federal law and the voluntary industry-based standard. t.

CYB 405 University of Phoenix Security Policy & Aligning Controls Discussion

The information security strategic plan and security policies are strongly interrelated within an organization’s inf ...

CYB 405 University of Phoenix Security Policy & Aligning Controls Discussion

The information security strategic plan and security policies are strongly interrelated within an organization’s information security program. The security plan and security policies will drive the foundation and selection of security controls to be implemented within the organization. Part 1 Write a 1- to 2-page summary of the comparison chart of strategic plans and security policies you completed in this week’s Learning Team assignment. Part 2 Review the control families described in this week’s reading, NIST SP 800-53a Revision 4, Assessing Security and Privacy Controls for Federal Information Systems and Organizations. Review the controls from this week’s reading, CIS Controls V7.1. Develop a 2- to 3-page matrix using Aligning Security Controls to NIST Security Controls Matrix Template that accurately maps CIS controls to NIST security control families. Note that some CIS controls may map to multiple NIST control families. Cite all sources using APA guidelines.Submit your assignment.

5 pages

Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for You have the option to u ...

Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for You have the option to use MS Visio (if you have the ...