Consider the following SQL code to generate a table for storing data about a music library. CREATE TABLE playlists ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT ); CREATE TABLE songs ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, artist TEXT, album TEXT, year NUMERIC, playlist_id INTEGER, FOREIGN KEY(playlist_id) REFERENCES playlists(id) ); Critique the design of this database, as by proposing and explaining at least two ways in which its design could be improved. Hint: Might songs end up with (lots of!) duplicate values in some columns?
Answers
Answer 1
Answer:
1. The size of the text fields not mentioned. How long is the song? 100 characters? 10000 characters?
2. Song table has the playlist id in it. It means playlist is connected to the song, not the other way
Lets say song "abc" exists in 2 play lists "alphabets" and "nursery rhymes"
The song table will look like this
01 - "abc" - "alphabets"
02 - "abc" - "nursery rhymes"
If you asked me how many songs you had in the table, I cannot answer that directly.
The best way is to have three tables
Songs table (contains information about the song)
playlist table (contains information about the playlist)
song_playlist table - that ties the song id and playlist id
Explanation:
Answer 2
Answer:
Explanation:
557629
Related Questions
Other Questions
A medieval city has the shape of a square and is protected by walls with length 500 m and height 15 m. You are the commander of an attacking army and the closest you can get to the wall is 100 m. Your plan is to set fire to the city by catapulting heated rocks over the wall (with an initial speed of 80 m/s). At what range of angles should you tell your men to set the catapult? (Assume the path of the rocks is perpendicular to the wall. Round your answers to one decimal place. Use g 9.8 m/s2. Enter your answer using interval notation. Enter your answer in terms of degrees without using a degree symbol.)
Pharoah Company sublet a portion of its warehouse for five years at an annual rental of $71700, beginning on May 1, 2017. The tenant, Sheri Charter, paid one year's rent in advance, which Pharoah recorded as a credit to Unearned Rent Revenue. Pharoah reports on a calendar-year basis. The adjustment on December 31, 2017 for Pharoah should be
Read the following paragraph and then answer the question that follows:Video games can kill! That is what many who support legislation banning violent titles from underage players have stated. These supporters of video game reform cite studies that show increased statistics of violence among children who play games regularly at home. Opponents of this reform, however, have expressed doubts about the validity of the studies, requesting that further research be done before a dramatic statement is made about all gamers. It seems that the rising popularity of video games among youth has spiked a political debate that may last for several more years to come.Which sentence from this paragraph is an example of the support?A) These supporters of video game reform cite studies that show increased statistics of violence among children who play games regularly at home.B) That is what many who support legislation banning violent titles from underage players have stated.C) Video games can kill!D) It seems that the rising popularity of video games among youth has spiked a political debate that may last for several more years to come.
Can somebody please help me!!
What is a non-civic issue?
In "Life Without Go Go Boots, what evidence does Kingsolver use to support her claim that her profession justifies her fashion choices in the eyes of society?A) So many have so little.B) Artists make very little money. C) Style trumps fashion.D) Artists have more important things to think about.
whats 1/2 + 2/4 - 5/8?
How did the French and British differ in the tactics they used to control their empires in Asia? O A. The British ruled directly over their colonies, while the French did not. B The French offered native peoples new technologies, while the British did not O The British forced their colonies to export goods, while the French did not D. The French used violence to control their colonies, while the British did not.
The sum of three numbers is 84 The second number is 2 times the first. The third number is 16 less than the second. What is the second number?
I need help on this question will give brainly points must be right.
A student throws a 120 g snowball at 7.5 m/s at the side of the schoolhouse, where it hits and sticks. What is the magnitude of the average force on the wall if the duration of the collision is 0.15 s
This campaign ad was made to_______ a political candidate named Matt Myers. the central idea in this ad is ______. According to the text, the ad was paid for by PAC that most likely_______ this as best described as_____.
Suppose a random variable X is best described by a uniform probability distribution with range 1 to 5. Find the value of that makes the following probability statements true.a) P(X a)= 0.89e) P(X >a)= 0.31
Amir wants to buy a $1382 Apple iPhone that is 12% off. What is 1 pointthe discounted price before tax? *
Is (0,-2) a solution of 3x - y = 2?
ASAP!! Please help me. I will not accept nonsense answers, but will mark as BRAINLIEST if you answer is correctly with solutions.
help help help help pls
2. Punctuate the following passages using capital letter where necessary(a) Chalk is a kind of mineral we give the name of mineral to every kind of solid substance such as sand gravel stone coal gold silver copper etc. that can be dug out of the earth such things are called minerals from the word mine which signifies a hole pit or other kind of excavation cut into the earth for the sake of obtaining some useful or valuable substance not found on the surface.
65WEM-8-8-54-2-102-23cB-5Which of the four images was formed by a reflection of the letter M?
The avarage monthly salary of m male employees and f female employees of a company is 2000 if the avarage monthly salary of the male employees is (b+200) find the avarage monthly salary of the female employees