Member Table Quiz

In a community center, each member is registered with unique details. Which field is best suited as the Primary Key in the Member table?

• First Name

• Last Name

• MemberID

• Contact Number

Answer explanation

MemberID is the best choice for a Primary Key because it is unique for each member, ensuring that each record can be distinctly identified. First Name, Last Name, and Contact Number may not be unique.

In a school database, which data type is most appropriate for storing the Date of Birth of students like Jahmar and Juvante in the Member table?

• Text

• Number

• Date/Time

• Currency

Answer explanation

The most appropriate data type for storing a Date of Birth is Date/Time, as it accurately represents dates and allows for date-specific operations. Text and Number do not provide the necessary structure for date values.

After sorting the Member table by last name in descending order, which name appears first?

• Davis

• Tomm

• Brown

• Smith

Answer explanation

When sorting names in descending order, we look for the last names that come last alphabetically. 'Tomm' comes before 'Smith', 'Davis', and 'Brown', making it the first name in the sorted list.

Which SQL condition correctly selects members of the club who paid 1000 or more in dues?

• SELECT * FROM Club_Dues WHERE Dues_Paid >= 1000;

• SELECT * FROM Club_Dues WHERE Dues_Paid < 1000;

• SELECT * FROM Club_Dues WHERE Member_Type = 'Special';

• SELECT * FROM Club_Dues WHERE Dues_Owing >= 1000;

Answer explanation

The correct SQL condition is 'SELECT * FROM Club_Dues WHERE Dues_Paid >= 1000;' as it selects members who have paid 1000 or more in dues. The other options either select the wrong criteria or are unrelated.

In the school database, the Title field for students was moved to the second position in the Member table.

• True

• False

Answer explanation

The statement is true because the Title field has indeed been moved to the second position in the Member table, confirming the correctness of the answer.

The Club Dues table contains information about Elijah's payments and attendance.

• True

• False

Answer explanation

The statement is true because the Club Dues table indeed contains information about members' payments and attendance, which is essential for tracking member engagement and financial contributions.

In a school database, which field appears in both the students table and the classes table, helping to create relationships between them?

• Contact_Num

• MemberID

• Date_Joined

• Address

Answer explanation

MemberID is the common field that links both tables, allowing for the establishment of relationships between them. The other options do not serve this purpose.

In the context of a local community club, which of the following statements is correct?

• The Club Dues table contains member contact details.

• The Member table stores payment details.

• The Club Dues table stores payment and attendance records.

• The Member table contains attendance data.

Answer explanation

The correct statement is that the Club Dues table stores payment and attendance records, indicating it tracks both financial contributions and member participation, unlike the other options which misattribute data.

In a school database, what happens when you sort the 'Member' table by Last Name in descending order?

• The records are arranged alphabetically from A-Z

• The records are arranged by first name

• The records are arranged alphabetically from Z-A

• The records are deleted

Answer explanation

Sorting the 'Member' table by Last Name in descending order means the records will be arranged alphabetically from Z-A, placing names starting with Z first and those starting with A last.

In a school database, what is the purpose of setting a primary key for each student record?

• To store duplicate records

• To uniquely identify each record

• To sort data in a table

• To perform calculations

Answer explanation

The primary key's purpose is to uniquely identify each record in a database table, ensuring that no two records are the same. This is crucial for maintaining data integrity and enabling efficient data retrieval.