Database fundamentals questions.

Outilne five advantages and three disadvantages of a database

Briefly explain the steps followed during database design

Define entity relationship diagram

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

What is a relation as applied in database

What is the long form of the following terms as applied in database

• DML
• DDL
• SQL

Briefly explain with examples

• DML
• DDL

Consider the following database schema  and answer the following questions

Professor (SSN, firstname, middlename, lastname, salary, rank)

Project(Pid, SSN, Title, startyear, location, amount, sponseredBy)

Student(regno, SSN, Firstname, middlename, lastname, yearofstudy, pid)

• Write SQL statement to create a database with a name UniversityProjects
• Write SQL statement to create the professor, project and student tables. Then assign primary key for each table.