Blog

In a file system what problem(s) could occur if multiple users access a file at the same time and are able to copy the file to their personal computers to make updates? Check all that apply.

Donations Table EventDonorId DonorId EventId ParticipantId DonationAmount 1 3 5 6 50.00 2 1 4 5 20.00 3 2 2 3 10.00 4 2 5 1 5.0 5 4 2 4 20.00 Which of the following would display the table data ordered first by the ParticipantId, then by the DonationAmount?

Which statement correctly creates the event table with all components shown on the following ERD?

In the following ERD which table(s) would need to include CityID as a foreign key in the CREATE TABLE statement? 

A school district hosts several fun run events each year to raise money. Many participants join in the events and get multiple donors for each event. A donor can donate to multiple events and participants. The fun runs can be hosted at four different parks depending on which school is hosting the fun run. The school district would like to begin tracking the information for the fun run in a database instead of the current file system. The Event data has been organized into the following group. What data would end up needing it’s own group so that it is not repeated? List each item that would be pulled into a new group then explain why you think this data would be put into it’s own table.

What is the correct SQL syntax to create a table named “Courses” with columns “CourseID” (integer), “CourseName” (text), and “Credits” (integer)?

What role does a “table” play in a relational database?

File systems increase the possibility of data being repeated.

Products Table ProductID ProductName StockQuantity Price 1 Widget A 50 20 2 Widget B 30 15 3 Widget C 100 25 4 Widget D 20 30 5 Widget E 70 18 6 Widget F 40 22 What rows would be returned with the following SELECT Statement? SELECT ProductName from Products WHERE StockQuantity > 80 OR price < 20;

Kosovo is a member of the United Nations.