Draw an erd for the parrot palace information system

Assignment Help Basic Computer Science

Reference no: EM131125360

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.

Reference no: EM131125360

Questions Cloud

Identify the best organizational pattern : For each of the lettered topics that follow, identify the best organizational pattern for a discussion of the subject. For example, a discussion of distance education and on-campus courses could be organized using the comparison-and-contrast patte..

What accounts should be debited and credited by the payee : What accounts should be debited and credited by the payee to record the dishonored note receivable?

What part did the anti-immigration sentiment play : What did this "dream" look like for immigrants coming to the United States after the Civil War was over? Explain which leisure opportunities could be part of the American dream. What part did the anti-immigration sentiment play in the American dream?

What is the title of the account used by tucker company : What is the title of the account used by Tucker Company in recording the note?

Draw an erd for the parrot palace information system : Draw an ERD for the Parrot Palace information system.

Worksheet uses a weighted-point evaluation system : The following worksheet uses a weighted-point evaluation system to calculate weighted performance scores along four dimensions for up to four potential sources. Re-create this spreadsheet in Microsoft Excel. Code your spreadsheet so that any chan..

Gallatin hardware is a small hardware store : Gallatin Hardware is a small hardware store in the rural township of Willow Creek that rarely extends credit to its customers in the form of an account receivable.

Write a c program that reads several different name : This union should itself contain two structures, one for baseball-related statistics and the other for football-related statistics. Test the program using a current set of league statistics. (Ideally, the program should be tested using both baseba..

First calendar quarter to consider three projects : Your company Portfolio Manager is convening a review board in the first calendar quarter to consider three projects. You have been asked to provide recommendations with respect to the capital budgeting aspects of these projects.

User Account

All Pages