Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi i need help with the following question database and SQL THE TABLE Quastions Issue Tracking Database keeps track of issues (problems) within a company
Hi i need help with the following question database and SQL THE TABLE
Quastions
Issue Tracking Database keeps track of issues (problems) within a company reported by its users which handled by its IT and software development teams USERS PROJECTS NUM NAME EMAIL ROLE ID NAME DEPARTMENT 100 Jenny Thompson some email 1 1000 Citrix Metaframe Software Development 200 Bill McPherson some_email 1 2000 Wireless Access Points IT 300 Any Wilson some email 2 3000 Desktop for Lab IT 800 Daniel Revierra some_email 3 4000 Tableau Data Visualization Software Development ISSUES USERID ID PROJECTID PRIORITY STATUS CREATED_ON ASSIGNED_PERSON 891 100 1000 High Jane Doe Open Aug 1, 2019 John Doe 342 100 2000 Closed Sep 1, 2019 LOW Low Closed 4000 Sep 29, 2019 Jane Doe 541 300 Media Pending 2000 Oct 29, 2019 Mary Anderson 767 200 High Clased Aug 31, 2019 David Brown 239 3000 Open Aug 24, 2019 Mary Anderson 654 200 Figure C: TCSS445 Issue Tracking Database How many tuples (records) will be returned as a result of executing the following SQL statement: SELECT PROJECTID, Name, Status FROM PROJECTS, ISSUES WHERE Priority = 'High' AND PROJECTS.ID = ISSUES.ID: If the result-set contains no records (i.e. empty), enter 0 as an answer. Otherwise, enter the numeric value of the number of records that will be returned. In the space provided below, write an appropriate SQL query that will list all the information about the issues that either high priority or an open status. Edit View Insert Format Tools Table 14pt v Paragraph B I U Av 2 T2 : In the space provided below, write an appropriate SQL query which list the number of issues reported by each department. As part of the result-set, include the department (i.e. name) and the corresponding number of issues reported. Edit View Insert Format Tools Table 14pt Paragraph : In the space provided below, write an appropriate SQL query that will list all the information about the issues that have a high priority or are still open (e.g, have an open status). Edit View Insert Format Tools Table 14pt v Paragraph BIU A 2 TY In the space provided below, write an appropriate SQL query will return the total number of open issues, regardless of priority. Name the computed column as "Total Number of Open Issues" Edit View Insert Format Tools Table 14pt Paragraph B I UA 2 Tv : In the space provided below, write an appropriate SQL query that will list the name(s) of user(s) who have reported two or more issues that have a 'Closed' status, Edit View Insert Format Tools Table 14pt Paragraph BI U ? e T
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started