DBST651 Project Part 4 Evaluation Criteria

Dbst651 Project Part 4 Evaluation Guidelineevaluation Criteriadescript

DBST651 Project Part 4 Evaluation Guideline Evaluation Criteria Description Weight Score Feedback 1 Project Description Statement of Work Database Design Requirement Definition and ERD Database Creation Implement the database model using SQL (DDL) 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. .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. 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

Paper For Above instruction

The purpose of this assignment is to develop a comprehensive database project, beginning from defining the requirements and creating an Entity-Relationship Diagram (ERD), to implementing the database using SQL, populating it with sample data, and querying it thoroughly. The project involves multiple stages that collectively demonstrate understanding of database design principles, SQL syntax, and data manipulation capabilities.

Initially, a clear statement of work must be prepared, outlining the project scope, objectives, and specific requirements of the database. This includes specifying the data entities, their attributes, and the relationships among different entities, visualized through an ERD. The ERD acts as a blueprint for the physical database design, guiding the creation of tables, constraints, and relationships.

Following the design phase, the physical database must be created using Data Definition Language (DDL) commands in SQL. This involves writing CREATE TABLE statements that accurately define all entities, include primary keys, foreign keys, and other constraints to maintain data integrity. Proper normalization should be applied to ensure an efficient database structure.

Once the database schema is established, sample data must be populated into each table using Data Manipulation Language (DML) statements, specifically INSERT statements. Each table should contain at least ten sample rows, representing realistic data for testing and demonstration purposes. This step verifies that the database can handle data insertion and storage effectively.

Following data population, the project requires developing at least twenty SQL SELECT statements to query the database. These queries serve to extract meaningful information, verify data integrity, and demonstrate different levels of query complexity. Basic queries (1-12) should cover simple data retrieval tasks such as selecting specific columns, filtering with WHERE clauses, and sorting results. Advanced queries (13-20) should demonstrate more complex operations, including joins, subqueries, aggregations, and grouping.

For each SQL query, comprehensive comments or descriptions must be included to explain the business purpose of the query, the specific requirement item it addresses, and any relevant notes on its construction. This documentation enhances the clarity of the project and showcases understanding of how each query fulfills a particular data retrieval need.

Finally, the project deliverables include submitting two files: an executable plain text file containing the SQL code for all queries, and an output file displaying the results of executing these queries. Both should be well-organized, clearly labeled, and include all comments for explanation. The total weight of this project is 100 points, reflecting the importance of design, implementation, data entry, and querying skills.

References

• Connolly, T., & Begg, C. (2014). Database Systems (6th ed.). Pearson.
• Pratt, P. J., & Adamski, J. (2018). Concepts of Database Management (8th ed.). Pearson.
• Marine, M., & Silberschatz, A. (2018). Fundamentals of Database Systems (7th ed.). Addison-Wesley.