Construct a crow''s foot model showing relationships

Assignment Help Basic Computer Science

Reference no: EM131219947

Consider the CD cover in Figure 5-61.

A. Specify identifiers and attributes for the entities CD, ARTIST, ROLE, and SONG.

B. Construct a crow's foot model showing relationships among these four entities. Name each relationship and specify cardinalities. Indicate which cardinalities you can justify on the basis of the CD cover and which you will need to check out with the users.

C. Consider a CD that does not involve a musical, so there is no need for ROLE. However, the entity SONG_WRITER is needed. Create a crow's foot model for CD, ARTIST, SONG, and SONG_WRITER. Assume that an ARTIST can either be a group or an individual. Assume that some artists record individually and as part of a group.

D. Combine the models you developed in your answers to B and C. Create new entities if necessary, but strive to keep your model as simple as possible. Specify identifiers and attributes of new entities, name new relationships, and indicate their cardinalities.

Reference no: EM131219947

Questions Cloud

Guidelines for performing project management functions : Why is it important to have standards or guidelines for performing project management functions?

Discuss the implications of a firm using debt versus equity : Discuss the implications of a firm using debt versus equity for funding purposes. Include the important risk and valuation implications. Illustrate the concept using the example of your study company.

Where do you feel nursing research is lacking : "In your nursing setting, where do you feel nursing research is lacking? - Give an example, and why it's lacking."

Cash receipts start exceeding cash disbursements : Blake and Anna Carlson are preparing a plan to submit to venture capitalists to fund their business, Music Masters. The company plans to spend $380,000 on equipment in the first quarter of 20X7. Assume that the company needs enough funding to cover a..

Construct a crow''s foot model showing relationships : Combine the models you developed in your answers to B and C. Create new entities if necessary, but strive to keep your model as simple as possible. Specify identifiers and attributes of new entities, name new relationships, and indicate their card..

Discuss three nonverbal differences you might encounter : Explain some of the differences in information systems in other countries and the effect those differences have on business relationships.

Head of human resources at a local health care organization : 1) Arrange an interview with the head of human resources at a local health care organization. 2) Write a report (1,000-1,250 words) on your interview that reviews the organization's human resources processes. Address the following:

Transfer cost of completed units to finished goods inventory : Tamar Co. manufactures a single product in one department. All direct materials are added at the beginning of the manufacturing process. Conversion costs are added evenly throughout the process. Prepare the journal entry dated May 31 to transfer the ..

Write a literature review of the given articel : Write a Literature review of the given article. - The Article is "Safe at home? an experiment in domestic airline industry".

User Account

All Pages