Reference no: EM131037627
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.
|
What are the strengths and weeknesses
: What are the strengths? What are the weaknesses? What recommendations would you make for improving host security? Write a one-page paper on your analysis.
|
|
What learning activities would you use in your training
: What learning activities would you use in your training? (i.e. Role playing, lectures, games, group discussions, etc.) Be sure to justify your decision.
|
|
Sketch the circuit of a current-mirror-loaded
: (a) Sketch the circuit of a current-mirror-loaded MOS differential amplifier in which the input transistors are cascoded and a cascode current mirror is used for the load (b) Show that if all transistors are operated at an overdrive voltage VOV an..
|
|
Evaluate impact of policies designed to reduce inequality
: Inequality within many developed countries is increasing. Evaluate the impact of policies designed to reduce inequality in a developed country of your choice
|
|
Draw an erd for the parrot palace information system
: 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
|
|
Equilibrium output in steps with the behavoural equation
: How can i find the equilibrium output in steps with the behavoural equation - Government spending and taxes are constant.
|
|
How could trinity further reduce sox-related expenses
: In 2008, how could Trinity further reduce SOX-related expenses? For each of your recommendations, be sure to take the barriers Trinity would face into account.
|
|
Health care policy and law
: The Role of Accreditation -What types of factors should policy makers consider when discussing whether to outsource accreditation to private accrediting bodies?
|
|
Why did keda decide to embark on erp implementation project
: What are the key case objectives (i.e. why did the author(s) write the case)?ERP projects are expensive and risky. Why did Keda decide to embark on an ERP implementation project?
|