Questions from Database Management

Q: What changes can be made in data administration at each stage of

What changes can be made in data administration at each stage of the traditional database development life cycle to deliver high-quality, robust systems more quickly?

Q: Interview a database analyst and ask how they go about identifying business

Interview a database analyst and ask how they go about identifying business rules in the data modeling process. How do they decide to document what business rules they will gather, utilize, manage, an...

Q: List the nine major components in a database system environment.

List the nine major components in a database system environment.

Q: Interview a database analyst or a systems analyst. How do they

Interview a database analyst or a systems analyst. How do they extract business rules for ER modeling? Ask for specific sources. Are they all listed in the text? Did they purchase an ER model and cust...

Q: Ask a database or systems analyst to give you examples of unary

Ask a database or systems analyst to give you examples of unary, binary, and ternary relationships that the analyst has dealt with personally at his or her company. Ask which is most common and why. A...

Q: Ask a database or systems analyst in a local company to show

Ask a database or systems analyst in a local company to show you an E-R diagram for one of the organization’s primary databases. Ask questions to be sure you understand what each entity, attribute, an...

Q: For the same E-R diagram used in Field Exercise 2

For the same E-R diagram used in Field Exercise 2-56 or for a different database in the same or a different organization, identify any uses of time stamping or other means to model time dependent data...

Q: Interview system designers and database designers at several organizations. Ask them

Interview system designers and database designers at several organizations. Ask them to describe the process they use for logical design. How do they transform their conceptual data models (e.g., E-R...

Q: Obtain an EER diagram from a database administrator or system designer.

Obtain an EER diagram from a database administrator or system designer. Based on what you have learned in this book, convert this into a relational schema in 3NF. Now interview the administrator on ho...

Q: Using the online Appendix B, available on the book’s Web site

Using the online Appendix B, available on the book’s Web site, as a resource, interview a database analyst/designer to determine whether he or she normalizes relations to higher than 3NF. Why or why n...