CSC
352 / 452: Database Programming
assignment #3
Click Link Below To Buy:
Contact Us:
Hwcoursehelp@gmail.com
Please note that
only TEXT files will be accepted. All other file types (e.g., DOC, DOCX, RTF,
PDF, JPG, or ZIP) will be rejected. In D2L, only the most recent submission is
kept.
·
If
you modified the DEPARTMENT and EMPLOYEE
tables created in Assignment #1, you need to delete and re-populate them.
·
Do not try to use complicated queries/cursors (e.g., joins) to get
the results. You can use
multiple PL/SQL statements to get the results easily.
·
You cannot use hard-coded values (e.g., IF department_name = 'MARKETING' THEN ……) in your programs.
·
You are not allowed to
create temporary tables, views, functions, or procedures.
·
The EXCEPTION section is NOT allowed in your programs.
·
Please
review your assignment file before submitting it to make sure you have the
correct one. It is your responsibility to ensure that you upload the correct
assignment file.
1) (CSC 352 – 25 Points | CSC 452 – 15 Points)
The
table popular_names consists of some
popular given names for male and female babies born during the years 1915-2014.
Rank 1 is the most popular, rank 2 is the next most popular, and so forth.
2) (CSC 352 – 35 Points | CSC 452 – 20 Points)
Based
on the tables created in Assignment #1, write a PL/SQL anonymous block to perform the following tasks:
·
Display the number of employees in the company.
·
Display the maximum/minimum/average salary for
the company.
·
Display 50% of the maximum salary for the
company.
·
For each department whose average salary is greater than 50% of the
maximum
salary for the company, display the name of the department, the number of
employees in the department, and the maximum/minimum/average salary for the
department.
3) (CSC
452 only – 25 points)
The
table AUTO_SERVICE consists of auto
repair and maintenance information. Create and populate the table AUTO_SERVICE by using the following
SQL statements.
No comments:
Post a Comment