1. Identify two departments in a manufacturing plant that would have Different uses for the same or similar inventory information. Then, describe how the subschema for the two departments might...

1.
Identify two departments in a manufacturing plant that would have Different uses for the same or similar inventory information. Then, describe how the subschema for the two departments might differ.

2.
What is the purpose of a database model?

3.
Summarize the roles of the application software and a DBMS.

4.
Answer the following questions based on the partial information given in the EMPLOYEE, JOB, and ASSIGNMENT relations in:

a.
Who is the secretary in the accounting department with experience in the personnel department?

b.
Who is the floor manager in the sales department?

c.
What job does G. Jerry Smith currently hold?