Data Manipulation Language (DML), 20 Queries
grenjo
DBST651_Project_Part4_Evaluation_Guideline1.docDBST651 Project Part 4 Evaluation Guideline
|
Evaluation Criteria |
Description |
Weight |
Score |
Feedback |
|
1 Project Description |
Statement of Work |
5 |
|
|
|
2 Database Design |
Requirement Definition and ERD |
10 |
|
|
|
3 Database Creation |
Implement the database model using SQL (DDL) |
10 |
|
|
|
4 Query Database |
|
|
|
|
|
4.1 Create SQL INSERT statements (DML) |
Create SQL INSERT statements (DML) to populate each table with sample data. Each table should have a minimum of 10 rows. |
20 |
|
|
|
4.2 Develop SQL SELECT statements to query tables |
Should have a minimum of 20 SQL select statements. Query 1 to 12 are basic queries, plus at least 8 advanced queries. |
45 |
|
|
|
5 Presentation
|
Submit one executable plain text file, and one output file. Each query should have comment/description to explain its business purpose, as well as which requirement item you are satisfying. |
10 |
|
|
|
Total |
|
100 |
|
|
