Consider variation on the suppliers-parts-projects database

Assignment Help Basic Computer Science

Reference no: EM131528846

Question: 1. Suppose the suppliers-pans-projects database is to be represented by means of a single containment hierarchy. How many possible such hierarchies are there? Which one is best?

2. Consider a variation on the suppliers-parts-projects database in which, instead of recording that certain suppliers supply certain parts to certain projects, we wish to record only that

(a) certain suppliers supply certain parts,

(b) certain parts are supplied to certain pro-jects, and

(c) certain projects are supplied by certain suppliers. How many possible 00 designs am there now (with or without containment hierarchies)?

Reference no: EM131528846

Questions Cloud

Write a suitable set of opal data definition statements : Design an 00 version of the suppliers-and-parts database.

Why your culture finds that particular story inspiring : Describe a situation that you know about in which someone overcame some type of life-threatening obstacle and who has shared their stories in a way.

Show what is involved in deleting an enrollment : Consider the education database once again. Show what is involved in deleting an employee.

Discuss the role of the 5 ws : Discuss the role of the 5 Ws (who, what, when, where, and why) in the context of a still-evolving global marketplace.

Consider variation on the suppliers-parts-projects database : Suppose the suppliers-pans-projects database is to be represented by means of a single containment hierarchy. How many possible such hierarchies are there?

Explain your role and duties to rose : Explain your role and duties to Rose, as well as your recommendation for or against clinical exercise testing. Be convincing in your explanation

Develop a set of ethics guidelines that will meet the needs : The steps you would need to take to develop a set of ethics guidelines that will meet the current needs of the organization.

Identify any conflicts between the irr and the npv : What is the expected value of each project's annual after tax cash flow? Justify your answers and identify any conflicts between the IRR and the NPV.

What are implications of schema evolution for existing data : Systems typically support integrity constraints in a procedural fashion, via methods; the main exception is that referential constraints are typically.

User Account

All Pages