Choose the correct data types for the fields in the Products table.  Product_id: unique identifier whole number [int] Price: May store 2 decimal places [decimal] Manufacture_date: Date item was manufactured [datetime] Product_name: name of the product [varchar] Stock_quantity: number of items in the inventory [int2]

Rules enforcing the values that can be entered into a column are called what?

Donations Table EventDonorId DonorId EventId ParticipantId DonationAmount 1 1 5 6 50.00 2 1 4 5 20.00 3 2 2 3 10.00 4 2 5 1 5.0 5 3 2 4 20.00 What would the following query return? SELECT DISTINCT DonorId from Donations;

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. 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.

Which best describes a relational database? (Select two)

Once a column is designated as a primary key in the CREATE TABLE statement what two constraints are automatically applied?

______ policy has enormous consequences for the ability of senior citizens to live in dignity and meet their most essential needs during what is often a financially difficult period in their lives.

Which of the following were identified by the Brookings Institute as the government’s greatest achievements of the past half-century?

In a [answer1] it is more likely to have incorrect data entry because the data could be repeated in multiple places and therefore when updating it would need to be done multiple times increasing the chance for error.

A party’s level of public participating in policy process, whether it is voting in elections or taking active roles in civic affairs is referred to as ______.