subject

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?


Consider the following SQL code to generate a table for storing data about a music library. CREATE

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 04:30
There is a simple pattern for determining if a binary number is odd. what is it and why does this pattern occur? how many bits would you need if you wanted to have the ability to count up to 1000? how high could you count in binary if you used all 10 of your fingers as bits? (finger up means 1, finger down means 0)
Answers: 3
question
Computers and Technology, 23.06.2019 03:50
Iam a bacterium. i cause stomach cramps and diarrhea. i am caused by eating rotten foodssuch as chicken, fish, or eggs. sometimes turtles carry my bacteria.what am i?
Answers: 2
question
Computers and Technology, 23.06.2019 06:30
You are consulting for a beverage distributor who is interested in determining the benefits it could achieve from implementing new information systems. what will you advise as the first step?
Answers: 1
question
Computers and Technology, 23.06.2019 09:00
Design a class tictactoe that: holds the following information about the game: two-dimensional array (3 by 3), and winner. add additional variables as needed. includes the functions to perform the various operations on objects. for example, function to print the board, getting the move, checking if move is valid, determining if there is a winner after each move. add additional operations as needed. includes constructor(s). write the functions of the class, and write a program that uses the class. the program should declare an object of type tictactoe. the program will create the board and store it in the array. the program will allow two players to play the tic-tac-toe game. after every valid move update the array, check if there is a winner. if there is no winner and no tie, then print the board again to continue.
Answers: 2
You know the right answer?
Consider the following SQL code to generate a table for storing data about a music library. CREATE T...
Questions
question
Mathematics, 26.10.2020 17:10
Questions on the website: 13722361