Questions from Database Systems


Q: When is a table in BCNF?

When is a table in BCNF?

See Answer

Q: Given the dependency diagram shown in Figure Q6.6, answer

Given the dependency diagram shown in Figure Q6.6, answer items 6a-6c: FIGURE Q5.6 Dependency Diagram for Question 6  a. Identify and discuss each of the indicated dependencies. b. Create a databa...

See Answer

Q: The administrators of Tiny College are so pleased with your design and

The administrators of Tiny College are so pleased with your design and implementation of their student registration/tracking system that they want you to expand the design to include the database for...

See Answer

Q: The dependency diagram in Figure Q6.7 indicates that authors are

The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of...

See Answer

Q: The dependency diagram in Figure Q6.8 indicates that a patient

The dependency diagram in Figure Q6.8 indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are...

See Answer

Q: What is a partial dependency? With what normal form is it

What is a partial dependency? With what normal form is it associated?

See Answer

Q: Write the connectivity and cardinality for each of the entities shown in

Write the connectivity and cardinality for each of the entities shown in Question 4. Details from Question 4:

See Answer

Q: What is a module, and what role does a module play

What is a module, and what role does a module play within the system?

See Answer

Q: What is a module interface, and what does it accomplish?

What is a module interface, and what does it accomplish?

See Answer

Q: Why must a conceptual model be verified? What steps are involved

Why must a conceptual model be verified? What steps are involved in the verification process?

See Answer