Orinoco is a medium sized record producer offering music on CDs, Tape, and Vinyl. They have just brought a number of smaller recording companies and are rapidly expanding. There is a great deal of information in the brochures that Orinoco produces along with an accompanying price guide. Some of the information is on computer but this is somewhat cumbersome as it is in separate systems that are incompatible, incomplete and difficult to use (due to the recent takeovers). It is particularly difficult to find music that matches a customers specific requests unless the brochure is browsed carefully. Orinoco has decided to computerize the information in their brochure, to include purchase information, and to sell directly over the web. They need to make it easier to: Gather specific information from customers and answer questions about products. Check the availability of specific products. Give costs of products. Keep information about artists, albums, and tracks. Keep information about the back catalogues of the companies recently taken over. Keep contract information about artist signings etc. For simplicity, you may assume that the system is stand-alone and does not have to integrate with any other. Note that many other simplifying assumptions will be made (e.g., that price information is fixed and is not flexible, and there are no sale items etc.). You should be sure to solve the problems as specified not as you imagine they would be in the real world.

Each Artist has an artistic name a musical genre and is managed by a manager who can have a series of contact telephone numbers. Artists also have a contract with Orinoco, which has a date from and to, and the duration of the contract in days. An Artist records a number of master tracks which have IDs a working title and duration; tracks are edited by a sound engineer, who has a name and ID. A finished track originates from a master track and has a version number (a finished track may have a number of different versions) a released title and a final duration. Albums group finished tracks into a sequence or play list / order. Albums have a title, are created by an artist, and can be distributed as a CD, on Vinyl, or as a Tape Cassette (denoted by c, v, and t respectively).

What you need to do this exercise

A Dia file has been created for you to extend

Basis.dia represents a part-completed EER schema which, models some of the information implemented in the system, as a starting point for this exercise.

1. Understanding the EER schema for the Orinoco system.

To demonstrate that you understand the information represented by the schema, explain using MANAGER, CONTRACTINFO, ARTIST, MASTER TRACK, FINISHED TRACK, ALBUM, and SOUND ENGINEER as examples:

a) attributes, entities and relationships

b) cardinality & participation constraints on relationships

You dont need to explain the entities etc BUT you should explain question a and b using the schema you have been given to more easily explain your answers. Dont write more than half a page to answer question 1.

name date_from contact_ID ( telephone ) date_to 1 Contractinfo duration Manager I ManagedBy > Master Track EditedBy > Sound Engineer CreatedBy >> title OriginatesFrom> album_ID m Finished Track - Album version sequence final_duration released_title )