Review and coursework completion

This week’s topics

Review and coursework completion

1. Reviewing the learning outcomes
2. Completing and checking coursework against the criteria
3. Self-assessment

What you will be able to do

• 1.1 Compare several major database management systems.
• 1.2 Describe the key concepts of database systems.
• 1.3 Explain the principle of queries and views in databases.
• 1.4 Explain the use of the SQL query language in databases.
• 1.5 Critically evaluate the benefits of the relational database model.
• 2.1 Identify user requirements and needs for data for particular applications.
• 2.2 Create an entity-relationship diagram based on user requirements.
• 2.3 Explain the process of normalisation and its importance in database design.
• 2.4 Implement a relational database schema that satisfies user requirements.
• 3.1 Use SQL to formulate queries to extract data from databases.
• 3.2 Use SQL to formulate queries to manipulate and update data in databases.
• 3.3 Use PHP to access and update an SQL database for practical applications.
• 3.4 Explain how PHP can be used to interface with databases in server-side applications.

Activity

Guided review of every criterion; coursework completion clinic and peer review.

Study materials