Embedded Files
Analysis
Analysis
Design
Design
Describe, exemplify, and implement entity-relationship diagrams with three or more entities indicating: entity name, entity type (strong, weak), attributes, relationship participation (mandatory, optional), name of relationship, cardinalityÂ
Describe, exemplify, and implement entity-relationship diagrams with three or more entities indicating: entity name, entity type (strong, weak), attributes, relationship participation (mandatory, optional), name of relationship, cardinalityÂ
Identify relationship participation from an entity-occurrence diagram
Identify relationship participation from an entity-occurrence diagram
Describe, exemplify, and implement surrogate keys
Describe, exemplify, and implement surrogate keys
Describe and exemplify a data dictionary, in relation to SQL, with three or more entities for the following: entity name; attribute name; primary and foreign key; attribute type: varchar, integer, float, date, time; attribute size; validation: presence check, restricted choice, field length, range
Describe and exemplify a data dictionary, in relation to SQL, with three or more entities for the following: entity name; attribute name; primary and foreign key; attribute type: varchar, integer, float, date, time; attribute size; validation: presence check, restricted choice, field length, range
Exemplify a design of a solution to a query using: tables and queries; fields; search criteria; sort order; calculations; grouping; having
Exemplify a design of a solution to a query using: tables and queries; fields; search criteria; sort order; calculations; grouping; having
Implementation
Implementation
Implement relational database using SQL Data Definition Language (DDL) and Data Manipulation Language (DML) to match the design
Implement relational database using SQL Data Definition Language (DDL) and Data Manipulation Language (DML) to match the design
Describe, exemplify, and implement the following SQL operations: CREATE statement: CREATE DATABASE; CREATE TABLE;Â constraints: primary key, foreign key, not null, check, auto increment
Describe, exemplify, and implement the following SQL operations: CREATE statement: CREATE DATABASE; CREATE TABLE;Â constraints: primary key, foreign key, not null, check, auto increment
Describe, exemplify, and implement the following SQL operations: DROP statement: DROP DATABASE; DROP TABLE
Describe, exemplify, and implement the following SQL operations: DROP statement: DROP DATABASE; DROP TABLE
Describe, exemplify, and implement the following SQL operations: HAVING clause of the SELECT statement
Describe, exemplify, and implement the following SQL operations: HAVING clause of the SELECT statement
Describe, exemplify, and implement the following SQL operations: subqueries used with the WHERE clause of SELECT statements
Describe, exemplify, and implement the following SQL operations: subqueries used with the WHERE clause of SELECT statements
Describe, exemplify, and implement the following SQL operations: data types: varchar, integer, float, date, time
Describe, exemplify, and implement the following SQL operations: data types: varchar, integer, float, date, time
Describe, exemplify, and implement the following SQL operations: logical operators: IN, NOT, BETWEEN, ANY, EXISTS
Describe, exemplify, and implement the following SQL operations: logical operators: IN, NOT, BETWEEN, ANY, EXISTS
Testing
Testing
Describe, exemplify, and implement the following: integrative testing; usability testing based on prototypes; final testing; end-user testing; SQL-implemented tables match design; SQL operations work correctly at this level
Describe, exemplify, and implement the following: integrative testing; usability testing based on prototypes; final testing; end-user testing; SQL-implemented tables match design; SQL operations work correctly at this level
Evaluation
Evaluation
Evaluate solution in terms of: fitness for purpose; maintainability: perfective, corrective, adaptive; robustness; accuracy of output
Evaluate solution in terms of: fitness for purpose; maintainability: perfective, corrective, adaptive; robustness; accuracy of output
(c) 2026 I Simpson, All Rights Reserved
Page updated
Google Sites
Report abuse