Questions from Database Systems

Q: Using the ERD shown in Appendix C, “The University Lab

Using the ERD shown in Appendix C, “The University Lab Conceptual Design Verification, Logical Design, and Implementation,” Figure C.22 (the Check_Out component), create the equivalent OO representati...

Q: Using the contracting company’s ERD in Chapter 6, “Normalization of

Using the contracting company’s ERD in Chapter 6, “Normalization of Database Tables,” Figure 6.15, create the equivalent OO representation.

Q: Use the Internet at your university computer lab or home to research

Use the Internet at your university computer lab or home to research the scenarios described in Problems 1-10. Then work through the following problems: a. What web sites did you visit? b. Classify ea...

Q: Research – and document -- the purchase of a new car.

Research – and document -- the purchase of a new car. Based on your research, explain why you plan to buy this car. Requirements: a. What web sites did you visit? b. Classify each site (B2B, B2C, and...

Q: Research – and document -- the purchase of a new house.

Research – and document -- the purchase of a new house. Requirements: a. What web sites did you visit? b. Classify each site (B2B, B2C, and so on.) c. What information did you collect? Was the informa...

Q: Tiny College wants to keep track of the history of all administrative

Tiny College wants to keep track of the history of all administrative appointments (date of appointment and date of termination). (Hint: Time variant data are at work.) The Tiny College chancellor may...

Q: Verify the conceptual model you created in Appendix B, problem 3

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

Q: Using an ER diagram, illustrate how the change you made in

Using an ER diagram, illustrate how the change you made in problem 1 affects the relationship of the USER entity to the following entities: LAB_USE_LOG RESERVATION CHECK_OUT WITHDRAW

Q: What is the most common design trap, and how does it

What is the most common design trap, and how does it occur?

Q: Why may the client/server evolution be characterized as a bottom

Why may the client/server evolution be characterized as a bottom-up change and how does this change affect the computing environment?