Blog

File systems decrease the possibility of data being repeated.

What is the primary purpose of a database?

Donors Table DonorId FName LName Email Phone 1 John Doe john.doe@gmail.com 123-456-7890 2 Jane Smith jane.smith@weber.edu 098-765-4321 3 Robert Johnson robert.johnson@hotmail.com 555-123-4567 4 Emily Brown emily.brown@usu.edu 222-333-4444 5 Michael Davis michael.davis@gmail.com 111-222-3333 Write a SQL Select statement that will Display All of the Donors that have a DonorID within the range of 2 to 4.  Display just their names in one column using the format LastName, FirstName such as… Smith, JaneJohnson, RobertBrown, Emily  

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 Complete the SELECT statement so it gets all the Donations that have an eventID of 1, 3, or 4. SELECT * from Donor WHERE eventID [LIKE] [condition];

What does the following query return? SELECT DAY(NOW()) AS DayOfMonth;

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

In a relational database, what is a “row” typically referred to as?

In SQL, what is a “literal”?

Which of the following best describes a “table” in a relational database?

In an ERD the components that describe the data collected on the entity are called what?