Database fundamentals UE Past Papers Questions.

Outilne five advantages and three disadvantages of a database

Answer / Solution

Briefly explain the steps followed during database design

Answer / Solution

Define entity relationship diagram

Answer / Solution

Songambele studio has decided to share in database information about musicians who perform on its albums. the requirements are given below:

1. Each  musician that  records at Songambele has an SSN, a name , an address , and a phone number.
2. Each instrument that is used in songs recorded at songambele has a name (eg, guiter, synthesizer, flute) and a musical key (eg, C, B-flat , E-flat
3. Each album that is recorded on the songambele has a title , copyright date , a format(e.g CD or MC) and an album identifier.
4. Each song recorded at songambele has a title and an author.
5. Each musician may play several instruments and given instruments, and a given instrument may be played by several musicians.
6. Each album has a number of songs on it, but no song may appear on more than one album
7. Each song is performed by one or more musicians, and a musician may perform a number of songs
8. Each album has exactly one musician whoa acts as its producer. A musician may produce several albums, of course.

respond to the following questions.

• Identify the entities and attributes
• Identify the primary key for each entitity
• Draw the ERD for Songambele studio

Answer / Solution

What is a relation as applied in database

Answer / Solution