This week’s topics
Assignment workshop: drafting, feedback and improvement
- Drafting against the criteria
- Tutor and peer feedback
- Improving the final submission
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
Draft the assignment, get feedback and improve it before submission.
Study materials
The teaching notes, exercises and videos of this week are in the student portal. Your portal is set up as soon as you receive final acceptance, so you can open them before the semester starts.
