This week’s topics
Assignment workshop: research, planning and referencing
- Unpacking the assignment brief and criteria
- Finding and evaluating sources
- Planning and referencing
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
Plan the unit assignment against every criterion; source and reference the evidence.
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.