A music database stores details of a personal music library and could be used to manage your mp3, CD or vinyl collection. The collection consists of albums. An album is made by exactly one artist but an artist can make one or more albums. An album contains one or more tacks but each track is on exactly one album. The artists, albums and tracks each have a name. Required: Produce a conceptual data model complete with optionalities and cardinalities using crow's foot notation. b). Consider the table schema Player->(PlayerID, Firstname, Secondname, Address, Allowance). Write DML statements for each of the following tasks. To increase allowances of the players by 3%. Create a view to display all players from "London". iii. Add a new column to store age of the player. A stored procedure to increase allowance by 4% for players below 25 years.
a). A music
b). Consider the table schema Player->(PlayerID, Firstname, Secondname, Address, Allowance).
Write DML statements for each of the following tasks.
- To increase allowances of the players by 3%.
- Create a view to display all players from "London".
iii. Add a new column to store age of the player.
- A stored procedure to increase allowance by 4% for players below 25 years.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
