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?
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:
Explanation:
557629
When data has been processed and is meaningful, which of these has it
become?
A. Information
B.Processed data
C.Identifiable data
D.Profiled
Data that has been processed and is meaningful is now an (A). Information
Meaning of Data and InformationData can be defined as raw facts, unprocessed ideas, details that makes little or no sense.
Information can be defined as a refined, processed and well arranged data that now makes sense to the operator.
In conclusion, Data that has been processed and is meaningful is now an Information
Learn more about Data and Information: https://brainly.com/question/16019928
#SPJ2
Dinah is using an IDE to write, modify, and save code. Which tool should she use?
is it possible to fix a SIM card if it dosn't work
Yes but only experts would know how to do it
URGENT!!!! WILL GIVE BRAINLIEST Select the correct answer. Jason works as a graphic designer. He has been tasked with creating an animated character for the corporate video of the company. What would be an ideal practice for Jason to follow when designing this character? A. create a complex character design that needs a lot of detailing B. create a simple character design that can be easily reproduced C. borrow from other famous designs used by other companies D. discard all colors from the character design
An ideal practice for Jason to follow when designing this character is to create a simple character design that can be easily reproduced. Thus, the correct option is B.
What is a Graphic designer?A graphic designer may be defined as a profession that deals with designing the element, animations, etc. that convey the information by the creator to the influencer with probable effects.
A graphic designer usually works with creating an animated character for the corporate video of the company, institution, or any workplace that requires some sort of initiation, affection, and new establishment of facts and theories in front of society.
The most probable practice of graphic designing is based on the efficiency and accuracy of creating a simple character design that can be easily reproduced without any external processes and expenses.
Therefore, an ideal practice for Jason to follow when designing this character is to create a simple character design that can be easily reproduced. Thus, the correct option is B.
To learn more about Graphic designer, refer to the link:
https://brainly.com/question/9774426
#SPJ2
When cleaning a firearm, what end of the firearm should you generally clean from?
Answer:
Explanation:
You should always clean from the breech (chamber) end. On firearms that you don't have access to the breech, you should put the cleaning rod through the muzzle to the breech. Then place the cleaning patch or brush on the end of the rod. Then PULL the rod through the barrel and out of the muzzle.
Ms. Jones, the art director for the game Ninja: Shadow
Warrior, prepares the game's art style guide. What phase of
game development is Ms. Jones currently in?
the pre-production phase
the alpha phase
the gold phase
the concept phase
Answer:
i think the pre-production phase. Sorry if i'm wrong
Explanation:
Google Docs, MS Word, Google Slides, MS PowerPoint, Google Sheets, MS Excel In your opinion which software in each category is easier to use?
Answer:
ms word and ms excel
Explanation:
because thwy are easier to use for begineers
What is the purpose of indexing?
A. To combine characters in order to form a single string
B. To combine two or more strings into one big string
C. To pull out a group of characters from a string
D. To pull out one specific character from a string
Answer:
D. To pull out one specific character from a string
Explanation:
Indexing allows you to access individual characters in a string directly by using a numeric value.
Which of the following describe a required
argument? Check all that apply.
an argument that does not need to be
specified
an argument defined by its parameter name
an argument passed to the function in the
correct positional order
an argument wherein the number of
arguments in the function call should match
the definition of the function
DONE
Answer:
The last 2 point in the given question is the correct answer to the given question i.e
an argument passed to the function in the correct positional order an argument wherein the number of arguments in the function call should match the definition of the function.Explanation:
The required argument are those argument that are passing to the method the in the right location order.In the required argument the number of arguments in the call method must match the definition of the function .
For example
def fun( s ): #function definition
print(s) #display s
fun('er')#calling
In this example there is function fun() in which we pass the argument 'er' we call that function from main() .The control moves to the function definition it checks the number of argument in the calling function fun() is matched with the definition of function fun() and print 'er'.
All the other option are not describing the required argument that's why this is incorrect option .
Answer:
Its the last two points
Explanation:
Inside which command group will a user find the ability to configure Outlook rules used to organize a mailbox?
O Tags
O Groups
Move
Find
Help fast
Answer:
Move
Explanation:
The rules in Outlook help you to move and answer emails automatically and this option is found in the command group Move where you have the options to create a rule and manage the existing ones. According to this, the answer is that the command group in which a user will find the ability to configure Outlook rules used to organize a mailbox is Move.
The other options are not right because Tags allows you to assign different tags to messages and mark an email as read or unread, Groups allows you to select several people and share resources easily with them. Also, Find allows you to look for an email or specific information inside one. Help provides you several options to find a solution for an issue.
What can JavaScript be used for if I want to hack something I learned JavaScript but don’t know what to hack with it
Answer:
JavaScript allows users to interact with web pages.
Explanation:
Which was the first home game console to be launched?
O A.
VCS 2600
OB. Odyssey
OC. Odyssey 100
OD.
Magnavox
O E.
VCS 5800
Answer:
B: Odyssey
Explanation:
Odyssey, by Magnavox, was the first console ever made.
Answer:
B: Odyssey
Explanation:odyssey by magnavox was the first ever console made
Which statement about serious games is true?
OA. They teach players subjects such as math.
B. They are developed only for the military.
OC. They are developed only for the educational sector.
D. They are designed for entertainment.
O E. They comprise the biggest game market segment.
Answer:
A. They teach players subjects such as math.
Explanation:
Process of Elimination. B and C are not true - there are educational and military serious games. D is not true - serious games are designed for informational purpose. E is also not true - games for entertainment are the biggest game segment.
Hope it helps :P
Which HTML tag is formatted correctly? This is a heading This is a heading This is a title This is a paragraph
Answer:
The tags must be formatted:
<h1> This is a heading </h1>
<h1> This is a heading </h1>
<title>This is a title</title>
<p>This is a paragraph</p>
Explanation:
You always need a start tag <> and an end tag </>. Depending on what you want in the tag is up to you. If you want a title, then the tag is <title> at the start and </title> at the end.
Answer:
A, the first one
<h1>This is a heading</h1>
hope this helps :)
What is the method for removing a single item in History?
Select one:
a. Open the History list, point to the item, and click the Remove button.
b. Open the History list, point to the item, and click the X to its right.
c. Open the History list and click the Pin this pane button.
d. Open the Favorites list, click the item, and click the X to its right.
The correct option is B. Open the History list, point to the item, and click the X to its right which is the method for removing a single item in History.
How do I selectively delete browsing history?Your surfing history will appear when you press Ctrl+H or Cmd+Y. You can view checkboxes next to the websites you've recently visited. The websites you browsed will be removed if you check the relevant boxes next to the problematic pages and then click the Remove Selected Items button.
Launch the Android app for the search engine Chrome. Select History by tapping the three dots in the top right corner. The X buttons next to each link allow you to remove specific things from this list.
Activate the History/Bookmark Manager. On the first entry, click once. Click the additional entries while Windows' Control key is still depressed. When finished, click Delete.
Thus, The best choice is B. To remove a single thing from History, open the list, point to the item, and click the X to the right of it.
Learn more about the deletion of a single item in History here:
https://brainly.com/question/22636311?referrer=searchResults
#SPJ2
Which information can you apply to every page of your document with the page layout options?
Answer:
the page layout tab holds all the options that allow you to arrange your document pages Just the way you want them. you can set margins, apply themes, control of page orientation and size
Answer:
the page layout tab holds all the options that allow you to arrange your document pages Just the way you want them. you can set margins, apply themes, control of page orientation and size.
Explanation:
Google Docs, MS Word, Google Slides, MS PowerPoint, Google Sheets, MS Excel In your opinion which software in each category is easier to use?
Answer:
I my opinion Google software is easier to use.
Explanation:
It is more upgraded and it's basically like kind of the latest version of Microsoft Software
This is just my opinion, I use Google Applications for every single thing in my life
Answer:
Google Docs.
Explanation:
I chose Google Docs because, in my opinion I feel that Google Docs lets me more creative with my papers. I feel this way because in Google Docs, I am able to add pictures in wherever I want, and I am able to resize them. Not to say that any of the other platforms listed don't have these features. But, Google Docs is easier to use. I think this way because, it doesn't have a bunch of shortcuts and other things on the top which is helpful. Not having the shortcuts at the top is helpful because I happen to find myself just looking for a specific shortcut and I accidentally click the wrong one it takes forever to go back and redo what it did.