Defineanomaly? A database that has three mistakes in it? Are you going to figure out what's wrong and come up with a solution?

Are there any moral issues to think about while building a database? Should highly confidential personal information (like medical records) be kept in the same database management system as information about employee compensation and benefits?

Attracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, they are unaware of the specificities of databases and have therefore asked you to create an EER model. A large number of songs will be made available through their website, and the following information on each song needs to be stored: title, year, length, and genre. Also, artist information will be added, including date of birth, name, and a URL to a website (e.g., Wikipedia page) with additional information on the artist. You can assume an artist is uniquely identified by her name, and that a song always belongs to exactly one artist. The Musicmatic students also point out that songs having the same title are possible, and only the combination of song and artist can be assumed to be unique. The database will also have to store information on the people using Musicmatic. It was decided to only discriminate between two types of users: regular…

Make a list of the problems that a large amount of data presents, and then examine the solutions.