|
Lab 4: Structured Query Language (SQL)
|
|
Criteria
|
Unacceptable
Below 60% F
|
Meets Minimum Expectations
60-69% D
|
Fair
70-79% C
|
Proficient
80-89% B
|
Exemplary
90-100% A
|
|
1. Create the tables and relationships from the database design discussed in Lab 2.
Weight: 25%
|
Did not submit or incompletely created the tables and relationships from the database design discussed in Lab 2.
|
Insufficiently created the tables and relationships from the database design discussed in Lab 2.
|
Partially created the tables and relationships from the database design discussed in Lab 2.
|
Satisfactorily created the tables and relationships from the database design discussed in Lab 2.
|
Thoroughly created the tables and relationships from the database design discussed in Lab 2.
|
|
2. Add at least five (5) records into each table (Note: You must determine the field values). Weight: 20%
|
Did not submit or incompletely added at least five (5) records into each table (Note: You must determine the field values).
|
Insufficiently added at least five (5) records into each table (Note: You must determine the field values).
|
Partially added at least five (5) records into each table (Note: You must determine the field values).
|
Satisfactorily added at least five (5) records into each table (Note: You must determine the field values).
|
Thoroughly added at least five (5) records into each table (Note: You must determine the field values).
|
|
3. Create a query with all fields from the student table, where the student’s last name is “Smith”.
Weight: 15%
|
Did not submit or incompletely created a query with all fields from the student table, where the student’s last name is “Smith”.
|
Insufficiently created a query with all fields from the student table, where the student’s last name is “Smith”.
|
Partially created a query with all fields from the student table, where the student’s last name is “Smith”.
|
Satisfactorily created a query with all fields from the student table, where the student’s last name is “Smith”.
|
Thoroughly created a query with all fields from the student table, where the student’s last name is “Smith”.
|
|
4. Create a query that includes students’ first names, last names, and phone numbers.
Weight: 15%
|
Did not submit or incompletely created a query that includes students’ first names, last names, and phone numbers.
|
Insufficiently created a query that includes students’ first names, last names, and phone numbers.
|
Partially created a query that includes students’ first names, last names, and phone numbers.
|
Satisfactorily created a query that includes students’ first names, last names, and phone numbers.
|
Thoroughly created a query that includes students’ first names, last names, and phone numbers.
|
|
5. Create a query that includes instructors’ first names, last names, and courses they teach.
Weight: 15%
|
Did not submit or incompletely created a query that includes instructors’ first names, last names, and courses they teach.
|
Insufficiently created a query that includes instructors’ first names, last names, and courses they teach.
|
Partially created a query that includes instructors’ first names, last names, and courses they teach.
|
Satisfactorily created a query that includes instructors’ first names, last names, and courses they teach.
|
Thoroughly created a query that includes instructors’ first names, last names, and courses they teach.
|
|
6. Clarity, writing mechanics, and formatting requirements
Weight: 10%
|
More than 8 errors present
|
7-8 errors present
|
5-6 errors present
|
3-4 errors present
|
0-2 errors present
|