CSCI12 CT Midterm Quiz

Instructions:

1. Short coupon bond. Sub 20.
2. There are two parts of the quiz. Use two papers.
3. To be submitted on TUESDAY(Aug. 24, 2010)

I. ERD

Create an ERD for the following system.

A publishing company produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not unecessarily being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers essentially one of the specialist subjects and is normally
written by a single author. When writing a particular book, each author works with on editor, but may submit another work for publication to be supervised by other editors. To improve their
competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject.

II. SQL

Based on the EMP table, create the correct sql statement and show the expected results for the following items:
1. Retrieve all records that belong to department 30 and has a salary that does not exceeds 2000.
2. Retrieve the name(s) that has a job as SALESMAN, CLERK and ANALYST
3. Retrieve the name(s) arrange in an order starting from recently hired.
4. Retrieve the name(s) that directly reports to President King (7839).
5. Retrieve the name(s) that starts with 'A'.
6. Retrieve the name(s) that ends with 'rd'.
7. Retrieve the name(s) that contains with 'rd'.
8. Retrieve the name(s) arrange in increasing order of empno.
9. Retrieve the name(s) that was hired in 1981 and the job is MANAGER and has a salary of more than or equal to 2500.
10. Retrieve the name(s) that was hired in 1982 and later or that belong in department 20.

Read more...