Questions from Database Systems


Q: Suppose a manufacturer produces three high cost, low volume products:

Suppose a manufacturer produces three high cost, low volume products: P1, P2, and P3. Product P1 is assembled with components C1 and C2; product P2 is assembled with components C1, C3, and C4; and pro...

See Answer

Q: Create an ER diagram for a hardware store. Make sure that

Create an ER diagram for a hardware store. Make sure that you cover (at least) store transactions, inventory, and personnel. Base your ER diagram on an appropriate set of business rules that you devel...

See Answer

Q: Use the following brief description of operations as the source for the

Use the following brief description of operations as the source for the next database design: All aircraft owned by ROBCOR require periodic maintenance. When maintenance is required, a maintenance log...

See Answer

Q: You have just been employed by the ROBCOR Trucking Company to develop

You have just been employed by the ROBCOR Trucking Company to develop a database. To gain a sense of the database’s intended functions, you have spent some time talking to ROBCOR’s employees and you’v...

See Answer

Q: Verify the conceptual model you created in Appendix B, Problem 4

Verify the conceptual model you created in Appendix B, Problem 4. Create a data dictionary for the verified model.

See Answer

Q: Verify the conceptual model you created in Appendix B, Problem 5

Verify the conceptual model you created in Appendix B, Problem 5. Create a data dictionary for the verified model.

See Answer

Q: Verify the conceptual model you created in Appendix B, Problem 6

Verify the conceptual model you created in Appendix B, Problem 6. Create a data dictionary for the verified model.

See Answer

Q: What are some of the managerial and technical issues encountered in the

What are some of the managerial and technical issues encountered in the implementation of client/server systems?

See Answer

Q: Verify the conceptual model you created in Appendix B, Problem 7

Verify the conceptual model you created in Appendix B, Problem 7. Create a data dictionary for the verified model.

See Answer

Q: Design (through the logical phase) a student advising system that

Design (through the logical phase) a student advising system that will enable an advisor to bring up the student's complete performance record at the university. A sample output screen should look lik...

See Answer