Click here to go to Analysis page.

Describe, exemplify and implement entity-relationship diagrams with three or more entities.

Identify relationship participation from an entity-occurrence diagram.

Describe, exemplify and implement surrogate keys.

Describe and provide examples of a data dictionary in relation to SQL, including three or more entities.

Exemplify a design of a solution query.

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

• constraints

• DROP statement

• HAVING clause of the SELECT statement 

• subqueries used with the WHERE clause of SELECT statements 

• data types

• logical operators

Read and explain code that uses the SQL at this level.

SQL-implemented tables match design 

SQL operations work correctly at this level

accuracy of output