Blog

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.

A rectangle is used to identify a(n) [answer1] in an ERD.

What is the correct syntax to delete a database named Fun_Run?

Which of the following is considered a “keyword” in SQL?

Which of the following was created to replace the Office of Strategic Services?