Reference no: EM13317442
Parrot Palace works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, ladder climbs, and various other tricks. Parrot Palace has about 50 birds and a list of 20 tricks from which to choose. Each bird can perform one or more tricks, and many tricks can be performed by more than one bird. When a bird learns a new trick, the trainer assigns a skill level. Some customers insist on using birds that score a 10, which is the highest skill level. As an IT consultant, you have been asked to suggest 3NF table designs. You are fairly certain that a M:N relationship exists between birds and tricks.
Tasks
1. Draw an ERD for the Parrot Palace information system.
2. Indicate cardinality.
3. Identify all fields you plan to include in the birds and tricks tables. For example, in the bird table, you might want species, size, age, name, and so on. In the tricks table, you might want the trick name and description. You will need to assign a primary key in each table. Hint: Before you begin, review some database design samples in this chapter. You might spot a similar situation that requires an associative entity that you can use as a pattern. In addition, remember that numeric values work well in primary key fields.
4. Create 3NF table designs.
|
Calculate the internal rate of return
: Calculate the Internal Rate of return and explain the changes that possibly took place - Calculate the contribution margin ratio and thereafter use this ratio to determine the sales value required to achieve an annual operating profit of R1200 000.
|
|
Stabilizing a nation price level and the purchasing power
: Suppose that US prices rise 4 percent over the next year while prices in Mexico rise 6%. According to the purchasing power parity theory of exchange rates, what should happen to the exchange rate between the dollar and the peso?
|
|
If the federal reserve reduced its reserve requirement
: Considering an economy with a current trade deficit and considering only the direct effect on income, an expansionary monetary policy tends to
|
|
Discuss the law and ethics as it relates to paramedics
: Discuss the law and ethics as it relates to paramedics or biomedical science. Write a paper with total 2000 words count,
|
|
Draw an erd for the parrot palace information system
: Parrot Palace works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, ladder climbs, and various other tricks.
|
|
How did the united states become the world s largest debtor
: Use the national income identity GDP= C + I + G + X to explain what a current account deficit(negative net exports) means in terms of domestic spending, production, and borrowing
|
|
What will happen to the equilibrium price and quantity
: What will this do to the demand curve? Of the available list of things in the text that causes a change in demand, which best fits here as the cause of the demand shift?
|
|
Implement your algorithm in python
: The program should display the total sales, sales for each car type, total bonus, bonus contributed by each car type, additional bonus for each car type and grand total bonus.
|
|
Disinflation refers to a situation where
: Which definition(s) of the money supply include(s) only items which are directly and immediately usable as a medium of exchange?
|